Solved

Adding Table to Access Split Database

Posted on 2014-04-10
8
558 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 - Microsoft MVP, Access and Data Platform) 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
Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

 
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

Online Training Solution

Drastically shorten your training time with WalkMe's advanced online training solution that Guides your trainees to action. Forget about retraining and skyrocket knowledge retention rates.

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…
Get people started with the utilization of class modules. Class modules can be a powerful tool in Microsoft Access. They allow you to create self-contained objects that encapsulate functionality. They can easily hide the complexity of a process from…
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

730 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