Linked Tables

[Guest]

I have a Front End (forms etc) linked to a Back End (Tables). I hav just
added a new Table but the Linked Table Manager does not seem to know it is
there. When i look in "Objects - Tables" all the other tables are there with
a little right arrow pointing to them and the New Table is there but does not
have an arrow at the side of it. Is this something to do with it?

Thanks for any help
RayC

 

[Rick Brandt]

I have a Front End (forms etc) linked to a Back End (Tables). I hav
just added a new Table but the Linked Table Manager does not seem to
know it is there. When i look in "Objects - Tables" all the other
tables are there with a little right arrow pointing to them and the
New Table is there but does not have an arrow at the side of it. Is
this something to do with it?

Thanks for any help
RayC

The linked table manager is for working with EXISTING links, not for creating
new ones.

Use...

File
- Get External Data
- Link Tables

....from the main menu.

 

[John Spencer]

It sounds as if you created the new table in the front end instead of in
the back end.

Find and open the backend and create the new table there. (or import it
from the front end: File: Get External Date: Import ...).

Close the back end

Open the front end and
-- Rename the new table (just in case)
-- use File: Get Exernal Data: Link tables ... from the menu
-- Find the backend in the dialog and open it and select the new table

Once you have a link set up to the new table and have tested it. Delete
the renamed New table that you had created in the front end.


'====================================================
John Spencer
Access MVP 2002-2005, 2007
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================