Hello!
I want to use the following code
SELECT *
INTO Persons_Backup IN ‘Backup.mdb’
FROM Persons

But all I ever get is the error message: "Incorrect syntax near IN"
How could I solve this?
But when I miss the IN clause, it works perfectly.
I think the problem is that I’m not connected to the second database, which I need to copy the […]

• 0 Comments

hi,
in my MS ACCESS front end, when i press TAB to jump to next text box or button focus is shifting in a disorderly way with no proper pattern.
What might be the reason. Please help me.
Regards
Jagadeep

a2a_linkname=”unordered TAB movement in Front end”;a2a_linkurl=”http://itquestions.info/unordered-tab-movement-in-front-end/”;

• 0 Comments

First off i’m not sure if this post goes in mysql or php so if this is the wrong place please move this post for me.
I am setting up a page with a list of commands that are pulled from a mysql database. I have the page that displays all the commands setup and am […]

• 0 Comments

Hi,
In my Insert SP, I have 5 local variables:
@MemberID int,
@VideoID int,
@Total money,
@DateRented datetime,
@DateDue datetime
insert into RentalRecord
values (@MemberID,@VideoID,@Total,GETDATE(), DATEADD(dd,5,GETDATE()))

When I try to execute the SP, I get this error:
Procedure or function ’sp_AddRentalRecord’ expects parameter ‘@DateRented’, which was not supplied.
Please advise.
Thanks

a2a_linkname=”Stored Procedure”;a2a_linkurl=”http://itquestions.info/stored-procedure/”;

• 0 Comments