Relink tables

[Ray]

I have a split database and need to send to other office to use. In that
office, they do not install link manager so they are unable to change the
table path. The back-end database is located in the folder of "Data" under
the front-end database. Can someone advise how to relink the table without
link manager installed.

Thanks,

Ray

 

[Roger Carlson]

On my website (see sig below) called "RelinkOnOpen.mdb" which illustrates
how to do this.

 

[Larry Daugherty]

Hi Ray,

go to www.mvps.org/access and search for "relink tables" or some variant
thereof. You'll find some code contributed by Ken Getz. The solution may
initially seem cumbersome and overkill, but it isn't. You can copy that
code into a module in your project and modify it to suit. It will solve the
relinking problems beautifully, including bringing up a dialog for the user
to navigate to the back end if necessary.

HTH

 

[Ray]

Roger,

Thanks for your advice and I have downloaded the sample program for trial
test.

I have two questions:

1. Is it workable on Access 97?
2. Do I have to put the back-end database in the folder of Privodata and
it is right under the front-end database?

Thanks,

Ray

 

[Ray]

Larry,

It sounds what I need. I visited the website and read the example but
unsure if I fully understand what should I do. Let me check my
understanding with you if you don't mind. Firstly, copy the codes of Relink
Access Tables from code in a new module. The example asks for running this
code at startup - how can I do it. Secondly, in Call the standard Windows
File Open/Save dialog box (GetOpenFileName) example, copy the code given in
a new module and set the module name as GetOpenFileName. Your further
enlightenment is highly appreciated.

Thanks,

Ray

 

[Roger Carlson]

Sorry for the delay in answering. I've been out of the office.

1. Yes, there is an Access 97 version
2. This particular sample DOES require that the back-end be in a folder
called Pivotdata underneath the folder where the Front-end resides.
HOWEVER, this is just a requirement of the sample because I programmed it
that way. The back-end can be ANYWHERE you want it to be. You just have to
set the paths correctly.

 

[Roger Carlson]

Whups! I'm sorry, there is NOT a 97 version. I created it after I stopped
adding or modifying 97 samples. However, the method WILL work in Access 97
as I am using DAO and not using any 2000 specific actions. If you can open
it in 2000, you should be able to convert it backwards to 97.