Access 2013 DB Move

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 ...
LVL 1
teksolgregAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

teksolgregAuthor Commented:
I should also note, the database is not a sql database.
Jeffrey CoachmanMIS LiasonCommented:
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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
teksolgregAuthor 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.
Protecting & Securing Your Critical Data

Considering 93 percent of companies file for bankruptcy within 12 months of a disaster that blocked access to their data for 10 days or more, planning for the worst is just smart business. Learn how Acronis Backup integrates security at every stage

Jeffrey CoachmanMIS LiasonCommented:
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?
teksolgregAuthor 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, Developing Solutions LLCCommented:
@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 LiasonCommented:
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, Developing Solutions LLCCommented:
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.
teksolgregAuthor 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.
teksolgregAuthor 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 :)
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
teksolgregAuthor Commented:
@Scott, I appreciate the comment, but have not been able to bypass anything.
Scott McDaniel (Microsoft Access MVP - EE MVE )Infotrakker SoftwareCommented:
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.
Armen Stein - Microsoft Access MVP since 2006President, J Street TechnologyCommented:
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
teksolgregAuthor Commented:
Checking with one consultant now, they are not very responsive.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.