Moving a split database

[Guest]

Hi,

We've got a split database stored on the H drive of our server. But we need
to access it from multiple sites and the Tech team have told me that inorder
to that we'll need to move it to the X drive (I have no idea way).

I gather it can not just be cut and paste so how would I go about this? Is
this going to be a nightmare???

Ian

 

[Kevin3NF]

Nope. Get everyone out of the db. Copy the file to the new location. Take
your copy of the front-end and re-link the tables using UNC (not mapped
drive letters). Distribute the FE to the users the same way you always do.
Piece of cake

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

 

[Guest]

What do you mean using a UNC?

Nope. Get everyone out of the db. Copy the file to the new location. Take
your copy of the front-end and re-link the tables using UNC (not mapped
drive letters). Distribute the FE to the users the same way you always do.
Piece of cake

--
Kevin Hill
President
3NF Consulting

www.3nf-inc.com/NewsGroups.htm

www.DallasDBAs.com/forum - new DB forum for Dallas/Ft. Worth area DBAs.

www.experts-exchange.com - experts compete for points to answer your
questions

 

[Douglas J Steele]

Universal Naming Convention: using \\server\share\folder\file.mdb instead of
F:\folder\file.mdb