Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / November 2008

Tip: Looking for answers? Try searching our database.

access 2007 runtime

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Kevin - 22 Nov 2008 13:38 GMT
Is there a way to setup different install options for a split DB using Access
2007 Runtime?  install both frontend and backend, install just backend,
install just frontend.  From what I can tell it only allows one setup option.
Any information would be appreciated.
Allen Browne - 24 Nov 2008 02:34 GMT
I guess you could set up different install packages, Kevin, but I'm not
aware of a way to do that in one.

What I personally do is to install the front end only. This is the safer
choice anyway: it could be disastrous to overwrite an existing back end full
of data with a shiny new blank back end from the install disk.

So, in the installation instructions, we document how they need to choose a
location with full rights (including delete for the ldb) for all users, and
copy the back end data there. Then install the front end. Our startup code,
then looks for the data, and if not available pops up a File | Open dialog
so they can locate the front end. It sets the Connect property, and so they
don't get promped again unless the data file is moved or renamed.

There's a bit more to it if you are using Access security (MDW.)

Signature

Allen Browne - Microsoft MVP.  Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Is there a way to setup different install options for a split DB using
> Access
> 2007 Runtime?  install both frontend and backend, install just backend,
> install just frontend.  From what I can tell it only allows one setup
> option.
> Any information would be appreciated.
Rick Brandt - 27 Nov 2008 13:20 GMT
> Is there a way to setup different install options for a split DB using
> Access 2007 Runtime?  install both frontend and backend, install just
> backend, install just frontend.  From what I can tell it only allows one
> setup option.
>  Any information would be appreciated.

What I do in my runtime installers is install the front end file and an
empty copy of the back end that has a different name.  This is
essentially a template for the back end.

When the front end is launched it refreshes the links to the back end.  
If it finds and existing back end file it links to that.  If not, it
creates one using the template file and links to that.  In this way the
app can be re-installed as many times as the user wants and their
existing data file is never over-written.

If I distribute a new version that has changes to the back end, then
variations on this same strategy can move all of the users existing data
into the new back end file.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt   at   Hunter   dot   com

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2010 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.