create a "template" database from existing (complex) database

[magpie]

I have an Access database that is somewhat complex that i would like to
duplicate without the records. One of the issues that I have is that I
need to have the old database with the records as well as a new clean
database on the same computer. I have tried already to create a new
database and import all of the tables, forms and macros to the new
database using "get external data" and selecting the option "definition
only" for those tables that i want to delete the records. Some of the
tables appear as drop down menus in the forms and the "data"
essentially a option for a feild. This method was about 80% successful
but some of the links and pointers seem not to know where to look for
information as I go about entering new records. I will get a message
that says "jet database engine can not find ..." The biggest problem
is that the existing database is extremely user friendly with a great
front end. It opens to a main menu that allows choices for "data
entry", "view and edit" "view only" etc.. which is convienient when you
want to just look and make sure that you don't accidentally change
records. It also allows collaborators to access the database based on
a number that corresoponds to various permission levels. I have no
idea how to make this happen in the new database. I know nothing about
database design or language and have gone as far as I can figure out on
my own. I would appreciate any advice or suggestions. tia--

 

[SusanV]

Hi magpie,

Have you checked your relationships in the new db?

 

[dbahooker]

if you used Access Data Projects; it would be trivial to get a script
of all objects in a database and to create a blank database.

SQL Server 2005 Express Edition.