Error with linked tables in install disk created

[Guest]

Hi. I used the package wizard to create an install CD with the runtime
version of Access included. I tried to install it on a computer. The
install ran fine. But when I tried to start the application it would not
start because it was looking for an invalid path. The path is the path on
the PC I developed the database. I think it is looking for the linked tables
(backend) in the directory I used on my machine on the new machine. I added
a path during the setup of the wizard but the linked tables retained the old
path. How do I change this to be the same path that the front end is
installed to? Thanks I appreciate any help.

 

[Roger Carlson]

I do one of two things:

1) Create the directories on the target PC exactly as they are on your PC.
This does not give the user any flexibility on where to install it. Also,
with the brain-dead Package and Deployment wizard, you can't designate any
default directory except Program Files, so your user has to type in the
directory that you designate.

2) A better solution is to programmatically re-link the tables on open if
the Invalid Path error occurs. On my website (www.rogersaccesslibrary.com),
is a small Access database sample called "RelinkOnOpen.mdb" which
illustrates how to do this.

--
--Roger Carlson
Access Database Samples: www.rogersaccesslibrary.com
Want answers to your Access questions in your Email?
Free subscription:
http://peach.ease.lsoft.com/scripts/wa.exe?SUBED1=ACCESS-L