Re: Setting table links with runtime installation.
From: Paul Overway (paul_at_I.hate.spam.logico-solutions.com)
Date: 01/21/05
- Previous message: Kam: "Access Workflow Designer for Access 2003???"
- In reply to: Lisa: "Re: Setting table links with runtime installation."
- Next in thread: Douglas J. Steele: "Re: Setting table links with runtime installation."
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 20 Jan 2005 22:45:37 -0500
An Access application that fails to check the validity of table links and
allow the end user to locate the BE data file is incomplete. You MUST
include code in your application to relink the tables....the runtime
provides no facility for doing it. Linked Table manager is not installed
with the runtime.
The only option beyond including relinking code in your application is to
distribute a single file instead of a split database. But if the app will
be multiuser or contain user data, that isn't a workable option.
Distributing Access applications IS a lot of work. Get used to it....or
find a new profession.
-- Paul Overway Logico Solutions http://www.logico-solutions.com "Lisa" <Lisa@discussions.microsoft.com> wrote in message news:103831E3-88A4-42E1-934C-7AFA99553B7E@microsoft.com... > Thanks, looks like a lot of work though, and I don't want to ask the user > to > make an decisions. > > I thought that as a last resort, if I Package my database with the > run-time > files, then put them on a CD. When I take the CD to the client, I could > just > open the database file that's on the CD and link them to the network > drive. > > Then they can use the CD to install as needed. > > Do you forsee any problems with this idea? > > Thanks again > Lisa > > "Douglas J. Steele" wrote: > >> Not reliably, but you can always add code to your routine to relink the >> tables once they're installed. >> >> One approach is shown in http://www.mvps.org/access/tables/tbl0009.htm at >> "The Access Web" >> >> -- >> Doug Steele, Microsoft Access MVP >> http://I.Am/DougSteele >> (no e-mails, please!) >> >> >> >> "Lisa" <Lisa@discussions.microsoft.com> wrote in message >> news:3500C390-6B6F-431E-A3D4-29BD96119771@microsoft.com... >> > Hi, I'm not new to Access Applications, however, I am new to using the >> > run-time. >> > >> > On my "development" computer, I have the frontend linked to the backend >> > in >> > the same folder. However, when I use the packaging wizard to package >> > the >> > frontend with the run-time, my front end will be linked my local folder >> > instead of their network folder. >> > >> > Is there a way to set the linked tables in the database to the correct >> > network drive before I package it? >> > >> > Thank you. >> >> >>
- Previous message: Kam: "Access Workflow Designer for Access 2003???"
- In reply to: Lisa: "Re: Setting table links with runtime installation."
- Next in thread: Douglas J. Steele: "Re: Setting table links with runtime installation."
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
