Linking tables

[Rick]

I have a split database. I was wondering if you could
write something in VB to make it search for the back end
of the database instead of having it linked to one
specific location. My problem is that people think they
can move the database and make it work. Is this possible
or not?

Thanks

 

[Tim Ferguson]

I have a split database. I was wondering if you could
write something in VB to make it search for the back end
of the database instead of having it linked to one
specific location. My problem is that people think they
can move the database and make it work. Is this possible
or not?

I don't fully understand the question, but you can manipulate where linked
tables point to by changing the .Connect property of the Tabledef object.
This is well explained in help files.

HTH


Tim F

 

[Roger Carlson]

On my website, see sig below, is a small sample database called
"RelinkOnOpen". I think this does what you need.

 

[John Vinson]

I have a split database. I was wondering if you could
write something in VB to make it search for the back end
of the database instead of having it linked to one
specific location. My problem is that people think they
can move the database and make it work. Is this possible
or not?

Thanks

Quite possible. I use the code from the _Access 2000 Developers
Handbook_ by Getz et al, which is copyrighted so I can't post it here,
but several folks have put example relinking code on the web:

http://www.rogersaccesslibrary.com/download3.asp?SampleName=RelinkOnOpen.mdb

is one that I found quickly, there are others.