Linking tables

  • Thread starter Thread starter Rick
  • Start date Start date
R

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
 
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?
Click to expand...

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
 
On my website, see sig below, is a small sample database called
"RelinkOnOpen". I think this does what you need.
 
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
Click to expand...

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.
 
Back
Top