[Webinar] Streamline your web hosting managementRegister Today

x
?
Solved

Adding Table to Access Split Database

Posted on 2014-04-10
8
Medium Priority
?
639 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
6 Comments
 
LVL 75

Accepted Solution

by:
DatabaseMX (Joe Anderson - Microsoft MVP, Access and Data Platform) earned 2000 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
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
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

The new generation of project management tools

With monday.com’s project management tool, you can see what everyone on your team is working in a single glance. Its intuitive dashboards are customizable, so you can create systems that work for you.

Question has a verified solution.

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

I have had my own IT business for a very long time. I started mostly with hardware and after about a year started to notice a common theme. I had shelves with software boxes -- Peachtree, Quicken, Sage, Ouickbooks -- and yet most of my clients were…
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
Add bar graphs to Access queries using Unicode block characters. Graphs appear on every record in the color you want. Give life to numbers. Hopes this gives you ideas on visualizing your data in new ways ~ Create a calculated field in a query: …
Suggested Courses
Course of the Month7 days, 22 hours left to enroll

607 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