auto update links

K

Kevin Kleinholter

I was wondering if there was a way to allow Access to automatically
update links.
The problem is that some of our computers are being changed out and
going from two drives(C:,D:) to only one drive(C:). When this happens
the users with no D: drive will have databases that are looking for
information on the D: drive.

What I am looking for is a way to have access look and see if there is a
D: drive available. If there is, I don't want it to do anything. If
there is not, I need it to delete the tables that are coming from the D:
drive and import the table from the C: drive.

If anyone knows a way to do this, it would save us a lot of time!

Thanks in advance,

Kevin
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top