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

How do I link tables from an existing db to a new blank db when Linked Table Manager is grayed out in the blank db MS Access 2013

I am creating a new db in MC Access 2013.  I want to split it into a Front End Back End but when I open the new blank db the Linked Table Manager is gray.  What do I do to link the tales from the existing db to the blank one?
0
Angelia1
Asked:
Angelia1
  • 3
1 Solution
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
The Linked Table Manager only applies once you have actually linked the tables the first time, and is used to typically 're-link'.

So ... on the Ribbon >> External Data >> Access ... and go from there do Link initially.
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Link Tables
0
 
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform)Commented:
Once you have linked initially, you can use the LTM to relink - should you for example move the back end database to a different location ... or chose to link to a local test copy, etc.

mx
0
 
Angelia1Author Commented:
Well that was easy... Thank you so much.  I'm sure I will be asking many  more questions.  2013 is brand new to me and I have a lot to do in it so thanks again.
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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