Solved

Table added to back end, not showing on front end

Posted on 2013-12-23
2
3,598 Views
1 Endorsement
Last Modified: 2013-12-23
I am new the whole idea of back end tables.

I have added a table to my back end database. I can't seem to find it on my front end. I tried re-linking the front end and it still doesn't appear. Is there something else I need to do?

Thanks!
1
Comment
Question by:cansevin
2 Comments
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
Comment Utility
Yes.  You will need add the link to that table.

1.  Click on the External Data tab above the Access Ribbon
2.  Select "Access" from the "Import" portion of the ribbon
3.  Browse to and select the file that your backend data is in
4.  Select the "Link to the datasource by creating a linked table" radio button
5.  Click "OK"

This will add your backend table to your front-end as a linked table (the datasplitter does this for you automatically when you split the application).
1
 

Author Closing Comment

by:cansevin
Comment Utility
Thanks... you are awesome. Have a Merry Christmas!
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

When you are entering numbers in a speadsheet, and don't remember what 6×7 is, you just type “=6*7" instead. It works in every cell! This is not so in Access. To enter the elusive 42 in a text box, you have to find a calculator, and then copy the re…
A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
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…

744 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