Access 2007 FAQ
Can I use the 2007 Package Wizard to install the data file (BE) in one location and the program file (FE) in a different location?
According to the following Help article - Deploy an Access 2007 application:
http://office.microsoft.com/en-us/access/HA102188641033.aspx
"The Access 2007 Developer Extensions Package Solution Wizard does not accommodate multiple installation paths. If your application has separate data and logic components, and you use the Access 2007 Developer Extensions to package your application, you may want to manually install the Access 2007 data files in the appropriate location, such as a file server.
An application that has separate data and logic components uses linked tables to connect the two components. Because every network is different, it may be impractical to specify the installation path of both components. In most cases, if you use the Package Solution Wizard, you will use the wizard only to package the logic component.
If you have enough information about the installation paths of the two components, you may want to create two installation packages by using the Package Solution Wizard so that you can specify the install path for each component."
See more tips and tricks like this in our book: Microsoft Office Access 2007 Inside Out
Back to FAQ main page