use macro or event procedure to link tables

[Guest]

I create databases using the front end/back end method and then send the
databases to others to use on their network.
Can I write a macro or event procedure that will make make the table linking
process easier for database setup at the new location, erhaps using a macro
or event procedure based on a text box?

 

[Ken Snell \(MVP\)]

This article presents one way of doing it. I've used this code as a starting
point for customized variations in my applications:

http://www.mvps.org/access/tables/tbl0009.htm

 

[Peter Hibbs]

Tom.

Have a look at :-

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

which should help.

Peter Hibbs.