Solved

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

Posted on 2015-01-26
4
76 Views
Last Modified: 2015-01-27
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
Comment
Question by:Angelia1
  • 3
4 Comments
 
LVL 75
ID: 40571393
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
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 40571398
Link Tables
0
 
LVL 75
ID: 40571400
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
 

Author Closing Comment

by:Angelia1
ID: 40573276
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

The Eight Noble Truths of Backup and Recovery

How can IT departments tackle the challenges of a Big Data world? This white paper provides a roadmap to success and helps companies ensure that all their data is safe and secure, no matter if it resides on-premise with physical or virtual machines or in the cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
I see at least one EE question a week that pertains to using temporary tables in MS Access.  But surprisingly, I was unable to find a single article devoted solely to this topic. I don’t intend to describe all of the uses of temporary tables in t…
Familiarize people with the process of utilizing SQL Server stored procedures from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Micr…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…

813 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now