Create an Access db template from an existing db (incl all objcts)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The creator of an Access db made a copy but we want to create a template of
this database so that that objects (forms etc.) can be reused without having
to dupelicate the contents of the database.

How do I create a template from an existing database?
 
-Create a blank db
-File>GetExternalData>Import
-Select all the objects (Forms, Reports, Modules, Queries, Tables, etc.)
that you want to import
-Options: Import Tables>Definition Only
- Use the additional settings under Options as you wish

I would make sure "Auto Correct" is off before you do the Import, and I'd
probably do this in 2 steps: 1) Tables 2) everything else. If AutoCorrect
is off, its probably not necessary to do it in 2 steps, but I'd probably do
it that way anyhow, but that may just be me.

HTH,
 
Thank You! I did find this information but not the "Auto Correct" piece.
Thanks as your response confirms what I've discovered and provided additional
'helpful' information. Have a great day.
 
Back
Top