Relink tables

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

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

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"Ray" wrote in message
...
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

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
--
-Larry-
--

"Ray" wrote in message
...
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,

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

"Roger Carlson" wrote in message
...
On my website (see sig below) called "RelinkOnOpen.mdb" which illustrates
how to do this.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"Ray" wrote in message
...
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

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

"Larry Daugherty" wrote in message
...
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
--
-Larry-
--

"Ray" wrote in message
...
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

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
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"Ray" wrote in message
...
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

"Roger Carlson" wrote in message
...
On my website (see sig below) called "RelinkOnOpen.mdb" which
illustrates
how to do this.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"Ray" wrote in message
...
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

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.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"Roger Carlson" wrote in message
...
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
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"Ray" wrote in message
...
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

"Roger Carlson" wrote in message
...
On my website (see sig below) called "RelinkOnOpen.mdb" which
illustrates
how to do this.

--
--Roger Carlson
www.rogersaccesslibrary.com
Reply to: Roger dot Carlson at Spectrum-Health dot Org

"Ray" wrote in message
...
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