Need code to link to different drives

[marathonlady]

I have an access db that links to tables on a CD drive. Any code
out there for when the clients have their CD's mapped to different drives? For instance, one is mapped to E: and another is mapped to F: and we don't want them to have to relink each time.

Thanks.

 

[WayneRyan]

marathonlady,

I'm sorry you haven't gotten a response yet.

Here's a Knowledge Base article:

http://support.microsoft.com/default.aspx?scid=KB;en-us;q291575

I know I've seen this before on some other forum. I'll look
again.

Once you survive the article above you'll neet to programattically
set the links, repost and we'll take it from there.

good luck,
Wayne

 

[pdx_man]

Good find Wayne. Very cool code. Will work seamlessly in Access!