Click here to Skip to main content
14,300,872 members
Rate this:
Please Sign up or sign in to vote.
See more:
hello,

I want to copy records from one database to other database in MS-Access database.

I have some table whose ID is stored as foreign key in other table.

Now i want something Similar syntax to "SET IDENTITY OFF" of sql in Ms Access

can any body help me.
Posted
Comments
Amir Mahfoozi 5-May-13 1:15am
   
The answer in stackoverflow seems correct : http://stackoverflow.com/questions/16379101/similar-syntax-of-set-identity-off-in-ms-access

1 solution

Rate this:
Please Sign up or sign in to vote.

Solution 1

There is no equivilent in Access. You can, however, just specifiy the value you want for the ID column in the INSERT statement, so long as it doesn't conflict with an existing record.
   

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100