Moving the backend of the database.

[darkhat01]

I would like to move the backend of our Access DB. However there are MANY links for the tables that will need to be reestablished. Is there a way to point the front-end database to the new location for the backend and all the links will be reestablished? Or do I have to go through each one individually? What would be the quickest way?

Thanks,

darkhat01

 

[traingamer]

There are several ways. One relatively simple way is:
Tools->Database Utilities -> Linked Table Manager

Check 'always prompt for new location', hit 'select all', hit 'ok', select new location. All of the links should be updated.

This can be automated, but if you're only doing it once, I'd do it this way.

Greg
"Personally, I am always ready to learn, although I do not always like being taught." - Winston Churchill

 

[darkhat01]

This is great, Thanks i will try it here in a little bit.

DH...

 

[Remou]

traingamer, I have found that if Always Prompt is ticked, it will ask for each table, which may or may not suit. Select All, followed by OK will just prompt once.

 

[PHV]

Have a look here:

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

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[johnherman]

For better answers, see thread700-1348789

-------------------------
The trouble with doing something right the first time is that nobody appreciates how difficult it was - Steven Wright

 

[Remou]

johnherman
You are referencing this thread!

 

[darkhat01]

This worked great...

traingamer what are some otehr ways?

Thanks