How do I create an empty copy of an Access database?

[Guest_imported]

Does anyone know how I can create an empty copy of Access database (resetting all auto-number fields)?

 

[AlexMidd]

Only way I know is to use code, using the TransferDatabase method. You would have to invoke this for all the objects (Tables, Queries, Forms etc) and set the parameter for including table data to False. Not sure if this resets the Autonumber field though. See Access help on TransferDatabase for more info. Have fun! )

Alex Middleton

 

[Robertd]

Hi

You can do this manualy, by creating a NEW database and selecting the objects from the source database you want to import. when you import tables just import data structures and any "autonumber" fields are reset to default.

hth
Robert


Robert Dwyer
rdwyer@orion-online.com.au

 

[AlexMidd]

Ah, of course! I forgot about that option in the import/export process. Have fun! )

Alex Middleton