Access 2007 can't link to backed

I added a new hard drive and all my Access files moved to a new location.  Now when I try to open a frontend it states it can't find the backend.  However, it doesn't open the frontend and give me the option to link it.  This is a fresh installation of Access.
J.R. SitmanIT DirectorAsked:
Who is Participating?
 
Rey Obrero (Capricorn1)Connect With a Mentor Commented:
try holding the SHIFT key until the FE is opened
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
One you do get the db opened, you can use the Linked Table Manager to relink - see images.


Capture1.gif
Capture2.gif
0
 
J.R. SitmanIT DirectorAuthor Commented:
Have you ever had one of those days where your brain is worthless.  This particular DB had a shortcut to open it.  All I had to do was change the path.  DUH!.

How do I get this DB to open without the shortcut?  I have several others that open in 2007 without a shortcut but this one won't.  I'm sure it's something I did.  Can you help or do I need to open another question?
0
Cloud Class® Course: C++ 11 Fundamentals

This course will introduce you to C++ 11 and teach you about syntax fundamentals.

 
Rey Obrero (Capricorn1)Commented:
did you try Holding the Shift key while opening the db?

what is the message you are getting?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
"How do I get this DB to open without the shortcut? "

Probably by holding down the Shift Key as noted in the first post.

That bypasses any start up form and/or AutoExec macro.

mx
0
 
J.R. SitmanIT DirectorAuthor Commented:
Is there no way to eliminate the .MDW or should I change it to the System.MDW
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
MDW must exist.  Do these dbs have User Level Security ? If so, then of course you will need the correct secured MDW file.  Otherwise, you should not have to worry about the MDW file.

mx
0
 
J.R. SitmanIT DirectorAuthor Commented:
OK, I understand there must be an MDW, but what I don't understand is why some of my databases open by just clicking the frontend, while others (.MDB) require the shortcut?  It's not a big deal, just annoying that I have to take an extra step for some.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Not sure I can answer that ... Seems you could create a shortcut for all that need to be opened - once they are all relinked (if necessary) ...?

mx
0
 
J.R. SitmanIT DirectorAuthor Commented:
Thanks.  I know I've gone beyond the scope of the original question.
0
 
J.R. SitmanIT DirectorAuthor Commented:
Even though this idn't solve my problem, I know it is the correct answer.  I don't want to confuse anyone looking for this answer.

Thanks
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Huh?
0
 
J.R. SitmanIT DirectorAuthor Commented:
My problem was the shortcut needed editing.  I solved it myself.  See my post 36994679
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Then you should Accept your own Answer.  Plus I answered several other questions for you.

mx
0
 
J.R. SitmanIT DirectorAuthor Commented:
Sorry didn't mean to upset you.  I truly appreciate your help.  You're correct, I chose the wrong award method.
0
 
Rey Obrero (Capricorn1)Commented:
does holding the shift key when opening the db did not get you where you want to change the path of the linked table?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I'm not upset ... I was just sayin' ...

mx
0
 
J.R. SitmanIT DirectorAuthor Commented:
@Capricorn1, yes it did.
@databaseMX, good to know
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.