move database to another server

[RACING5312001]

Hi,

My database is about to be moved to a new server. What do i have to do ?
Do i need to alter the workgroup information file in anyway
e.g re-create permissions again or leave them as they are ?

Do i need to go into the linked table manager and point to the new location
so that the tables will be updated ?
I will also need to change the shortcut to point to new location.

thanks

 

[HiTechCoach]

Hi,

My database is about to be moved to a new server. What do i have to do ?
Do i need to alter the workgroup information file in anyway
e.g re-create permissions again or leave them as they are ?

Do i need to go into the linked table manager and point to the new location
so that the tables will be updated ?
I will also need to change the shortcut to point to new location.

thanks

The same work group file should work just fine without any changes. You will need to make sure it gets copied also.

If you are using a mapped drive letter and your remap the same drive letter to the new location, then once the droive letter is remapped, everything should work.

If you are using UNC paths, then you will need to relink your tables. Oncew the tables have been relinked, then you can have all the users make a new copy of the front end to their local hard drive. I normally store my work group file in the same folder as the back end so the UNC path will have to be updated in the short cut.

I like to to something like the Auto FE Updater ( http://www.autofeupdater.com ) so that transition is very transparent.

Hope this helps ...

 

[boblarson]

One thing to note (IF you are using mapped drive letters instead of UNC paths) -

If you are using any references to helper mdb/mde files, you will need to relink them. When setting references, Access automatically converts those to UNC paths (we found out the hard way when we had a couple of server moves and our PDF Pro Plus Library (frm ACG Software) gave a bad reference error. The rest of the linking was okay because we have standard drive letter mappings but that one we had to go track down and fix in several databases that used that mde/dll.

 

[RACING5312001]

Hi,

My database is on a server called \\it-store\apps
and is being moved to another server called \\cpm01\apps
My current backend and .mdw file are in same folder in the \\it-store\apps
folder.

So do i just copy both i.e the backend and the .mdw file to the new location \\cpm01\apps\
Do i go into the front end and then into Linked Tabled Manager
and alter the path to point to \\cpm01\apps instead of \\it-store\apps
I guess i need to be logged in as Administrator to to this ?
As long as i don't have to alter permissions or start modifying the
workgroup information file i should be ok !

 

[HiTechCoach]

I would also recommend doing a test run of the migration. This way you can be sure that the front end gets updated to a few test workstations