Opening Multiple DBs from one App

[grupert]

I have been developing access databases for a great while, but am very new at developing free standing access applications. I have a compiled database that contains the full data structure as well as forms and reports. However, I would like to be able to have the standard FILE-OPEN and FILE-NEW functions that would allow me to open other access files with identical structure (just different data) or create blank files with identical structure and no data. My application would then utilize this newly opened or created file for its data source. Any help on this would be greatly appreciated. Thanks?

 

[ghudson]

Sounds like you want to create your own templates? If so you should be able to rename the db's file extension from .mdb to .mdz. Then copy the file to your systems Acess templates directory for Office. Here is where mine would go for Office 2003...

C:\Program Files\Microsoft Office\Office11\Templates\Access\YourTemplate.mdz

The YourTemplate.mdz file would then appear in the "Access" tab when you click the menu options... File \ New Database \ Access