Access 2013 DB Move

teksolgreg
teksolgreg used Ask the Experts™
on
Having issue opening database after copying database files and moving to new server.  Upon attempting to open database, error message indicates file cannot be found with old data location in the error.  For example:
Old Data location: \\old_server_name\shared_folder_name\123.mdb
New Data location: \\new_server_name\shared_folder_name\123.mdb

Tried to open two ways:
1. Browsed to new server and location (\\new_server_name\shared_folder_name\123.mdb) and attempting to open file, received error message that old server ( \\old_server_name\shared_folder_name\123.mdb) is not available.
2. Opened Access and browsed to location on new server and received the same message relating to old server location.

Stuck in mud ...
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Author

Commented:
I should also note, the database is not a sql database.
MIS Liason
Most Valuable Expert 2012
Commented:
Lets be clear,...
This database is split, and you are moving the "back end" to another sever?

If so then you may have to re-link the backend tables to the new location...
(Using the Linked table Manager)
linked table Manager

Author

Commented:
Jeffrey,
Thank you so much for the response - I am totally not an Access user, the company I do maintenance for had us install a new server.  Along with that, came moving data.  Now that I've drawn the picture a little clearer on my input.  I can't even open the mdb file due to the error, so using the linked table manager is unclear to me and hence leaving me at a stand still.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
I can't even open the mdb file due to the error,
Can't open the front end?, ...or can't open the back end?
...or neither?

Author

Commented:
Not to backtrack too much, but, we have a db file that when chosen on the old server, a user interface would open in Access.  There are several files in and around that file in that location, but, I couldn't tell you the front end from the back end or how to manipulate either of them being all I get is error messages when trying to open any of the db files that used to open on the old server.
I suspect from your comments, that this is a split db and the file I am clicking on is the front end and the front end is merely asking where is the back end located.  After it is not found, or the location is not found, the error message pops up.
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Commented:
@teksolgreg,

A well implemented Access database application has two components.  The Front End (FE) contains all of the user interface, queries, reports, and code.  The Back End (BE) is where all of the data resides.  Each user should have their own copy of the FE (on their PC) and these FE applications should be linked to the tables in the BE.  If the BE file exists on the server, you may not be able to open it if you are logged into the server, and don't have Office Pro installed on the server.

Many organizations will have a process in place which automatically updates the copy of the FE that resides on the users computers by copying the latest copy of the FE from the network to their PC, before actually running the file.  If your organization has this, then someone (ideally the developer) should refresh the links from the FE to the BE tables and publish this new version of the FE on the server so that all users can copy it to their computers.

HTH
Dale
Jeffrey CoachmanMIS Liason
Most Valuable Expert 2012

Commented:
There may be an easier answer.... so lets see what other experts post.

Can you simply put the db back on the old server and open it?
See if you get any errors, ...then try to figure out which are front end and which are back end files...

Also, ...is the original developer still around?
Can you contact them to get info on the database(es)?
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010
Commented:
Per your most recent post.

Try holding down the shift key when you open the access database file.  This may (depending on your developer) bypass any Autoexec macro or Startup form which is attempting to open when the file is opened.

I would highly recommend you try to locate the database applications developer for further assistance.

Author

Commented:
Developer long gone, maybe even passed.
Database opens with no issue when our last remaining user, still part of old domain, opens file.  File is opened by opening Access and browsing to the location and no issue or error occurs.
There never was any update to a front end at all, on any desktop, by any user, ever.  Each user had a copy of the latest MS Access installed locally, the database files were always located on a shared drive on the server, were accessible by all users on the domain, at all times.  Granted, there are only three users, but, each user could edit a record, save it and the next user would see the result of the edit.
Now we have a new server and accessing the file in the same manner errors out looking for the old server location.  Based on this, I suspect the FE requires a "re-linking" to the new BE?  This is just a stab in the dark though.

Author

Commented:
I'll totally try the holding down of the shift key - shoot, at this point, I will press shift with one hand, do a cartwheel on the other and cross my fingers with my toes to get this to work :)
Most Valuable Expert 2012
Top Expert 2014

Commented:
Note that once you bypass the startup stuff (if you can), then you'll still need some basic Access skills in order to troubleshoot this. Like the others, I'd believe a relink is in order, but if the application has hard-coded paths to certain things (and that's not unusual with novice-built systems), you may find yourself in deep waters.

Author

Commented:
@Scott, I appreciate the comment, but have not been able to bypass anything.
Most Valuable Expert 2012
Top Expert 2014

Commented:
If you can't get to the design mode of the system, you may also find that you're dealing with a .mde/.accde format. Those formats don't allow design changes, although you can relink (assuming you can get to the point where you relink).

You can always do it via code, of course, but you'd have to write the code to do it. That's assuming the relink is your trouble, obviously.

At some point you might consider hiring this out to an Access dev to manage.
We have a free J Street Access Relinker, but as Scott says you need to be able to get into the code in order to incorporate it.  I agree that if you're having trouble, it might be best to use a consultant to figure this out.

http://www.JStreetTech.com/downloads

Cheers,
Armen Stein, Access MVP
J Street Technology

Author

Commented:
Checking with one consultant now, they are not very responsive.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial