Solved

Adding Table to Access Split Database

Posted on 2014-04-10
8
536 Views
Last Modified: 2014-04-11
I have an Access 2007 database that is split into a front / back end.  I needed to add another table to the back end, and make the table available to a drop-down list box on a form on the front end.  I've added the table to the back end, but I cannot seem to get it to show up through the linked table manager.  I've tried several approaches, but to no avail.

Thanks for the help..

Tom
0
Comment
Question by:tpigielski
  • 4
  • 2
8 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Access MVP) earned 500 total points
ID: 39992921
You have to Link the table first ... before it will show up in the Linked Table Manager ... which only shows tables already linked.

mx
0
 

Author Comment

by:tpigielski
ID: 39993701
I've requested that this question be deleted for the following reason:

solved the problem myself
0
 
LVL 75
ID: 39992925
1
2
0
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.

 
LVL 75
ID: 39992943
I've already answered the question. Others may have the same (common) question in the future. Please PAQ.

mx
0
 

Author Comment

by:tpigielski
ID: 39993924
Closing the question myself and getting a solution from another member at pretty much the same time was purely coincidental.  It appears that the two events happened at about the same time.  Didn't mean to be unfair to a member...
0
 
LVL 75
ID: 39994659
thx.all.mx :-)
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Introduction When developing Access applications, often we need to know whether an object exists.  This article presents a quick and reliable routine to determine if an object exists without that object being opened. If you wanted to inspect/ite…
Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
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…

947 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

22 Experts available now in Live!

Get 1:1 Help Now