• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 215
  • Last Modified:

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.
0
J.R. Sitman
Asked:
J.R. Sitman
  • 8
  • 7
  • 3
1 Solution
 
Rey Obrero (Capricorn1)Commented:
try holding the SHIFT key until the FE is opened
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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. SitmanAuthor 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
Free recovery tool for Microsoft Active Directory

Veeam Explorer for Microsoft Active Directory provides fast and reliable object-level recovery for Active Directory from a single-pass, agentless backup or storage snapshot — without the need to restore an entire virtual machine or use third-party tools.

 
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 MVP, Access and Data Platform)Commented:
"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. SitmanAuthor Commented:
Is there no way to eliminate the .MDW or should I change it to the System.MDW
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
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. SitmanAuthor 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 MVP, Access and Data Platform)Commented:
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. SitmanAuthor Commented:
Thanks.  I know I've gone beyond the scope of the original question.
0
 
J.R. SitmanAuthor 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 MVP, Access and Data Platform)Commented:
Huh?
0
 
J.R. SitmanAuthor Commented:
My problem was the shortcut needed editing.  I solved it myself.  See my post 36994679
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Then you should Accept your own Answer.  Plus I answered several other questions for you.

mx
0
 
J.R. SitmanAuthor 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 MVP, Access and Data Platform)Commented:
I'm not upset ... I was just sayin' ...

mx
0
 
J.R. SitmanAuthor Commented:
@Capricorn1, yes it did.
@databaseMX, good to know
0

Featured Post

Veeam and MySQL: How to Perform Backup & Recovery

MySQL and the MariaDB variant are among the most used databases in Linux environments, and many critical applications support their data on them. Watch this recorded webinar to find out how Veeam Backup & Replication allows you to get consistent backups of MySQL databases.

  • 8
  • 7
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now