Similar syntax of "SET IDENTITY OFF" in Ms Access

Question

0.00/5 (No votes)

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 4-May-13 11:17am

abhinavvijay

Add a Solution

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

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

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

Dave Kreskowiak · Answer 1 · 2013-05-04T11:35:00

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.

Posted 4-May-13 11:35am

Dave Kreskowiak