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

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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/information-technology/11416-create-template-database-existing-complex-database.html
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11416
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--

 
Do share your immediate thoughts or reactions on this issue? We value your views! Login Now! or Sign Up Today! to share your views with us.. Gurfateh!

Hi magpie,

Have you checked your relationships in the new db?
--
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11416
hth,
SusanV

"magpie" wrote in message
news:1150302124.814050.251000@p79g2000cwp.googlegr oups.com...
>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
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11416
> 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--
>

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.


SusanV wrote:
> Hi magpie,
>
> Have you checked your relationships in the new db?
> --
> hth,
> SusanV
>
> "magpie" wrote in message
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11416
Reference:: Sikh Philosophy Network http://www.sikhphilosophy.net/showthread.php?t=11416
> news:1150302124.814050.251000@p79g2000cwp.googlegr oups.com...
> >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--
> >