How to link new table

[Susan]

I posted this question 2 wks ago and responded to my
replies but now can't find the post -- I know it was in
the Programming area. Anyway....

I am using Access2000 and have a split db with the backend
on the server and the mdb application on my pc. I created
a new table and need to link it (as all of the others are,
before I did the split). I linked it in the Relationships
option (on the Main Menu bar under Tools) but when I look
at all of the tables, the new table does not have
the 'pointer' as the others do. I need to be able to
copy the mdb application to a zip disk to bring to another
location (office). Thank you.

 

[John Vinson]

I posted this question 2 wks ago and responded to my
replies but now can't find the post -- I know it was in
the Programming area. Anyway....

I am using Access2000 and have a split db with the backend
on the server and the mdb application on my pc. I created
a new table and need to link it (as all of the others are,
before I did the split). I linked it in the Relationships
option (on the Main Menu bar under Tools) but when I look
at all of the tables, the new table does not have
the 'pointer' as the others do. I need to be able to
copy the mdb application to a zip disk to bring to another
location (office). Thank you.

You should have created the new table *IN THE BACKEND DATABASE*, not
in the frontend. What you can do now is:

- open the Backend database
- Use File... Get External Data... Import to import the table from the
frontend
- Close the backend and open the frontend
- Delete the table (you *did* make backups of both databases...
right!?)
- Use File... Get External Data... Link to link to the table in the
backend

It will now be available in the Linked Table Manager.

 

[Susan]

Thanks, I will try this over the weekend -- and yes, I do
many backups!!