Access 2003 -- Insert AutoNumbers -- "Set Identity_Insert On"?
Posted on 2007-10-03
I need to copy (programatically) some tables from one Access 2003 DB to another. The DB's are actually in MDE files so that any rogue customers have a bit more trouble stealing my code, and I'm finding that limits me in some ways.
My problem w/ the data copy is that many of the tables use AutoNumbers. Those, of course are referenced by other tables.
How do I copy the AutoNumber from the populated table into the empty one?
In MS SQL Server, I'd use "Set Identity_Insert On". Is there an Access 2003 equivalent?