Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
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
Medium Priority
?
84 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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 - Microsoft MVP, Access and Data Platform) earned 2000 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

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

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

This article describes two methods for creating a combo box that can be used to add new items to the row source -- one for simple lookup tables, and one for a more complex row source where the new item needs data for several fields.
This article describes a method of delivering Word templates for use in merging Access data to Word documents, that requires no computer knowledge on the part of the recipient -- the templates are saved in table fields, and are extracted and install…
In Microsoft Access, when working with VBA, learn some techniques for writing readable and easily maintained code.
Do you want to know how to make a graph with Microsoft Access? First, create a query with the data for the chart. Then make a blank form and add a chart control. This video also shows how to change what data is displayed on the graph as well as form…

688 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