Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 85
  • 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

Vote for the Most Valuable Expert

It’s time to recognize experts that go above and beyond with helpful solutions and engagement on site. Choose from the top experts in the Hall of Fame or on the right rail of your favorite topic page. Look for the blue “Nominate” button on their profile to vote.

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