Linked Tables

[brian]

I created a salesman quoting database using 4 Access 2000
databases. I 3 of the database linked to a master. I
did this for easier maintenance and updating.

My problem comes with deleting and updating. During
testing- I deleted 30 records in the linked DB. I
checked the source DB and all the records were still
there. I refreshed the link in the linked DB and non of
the records appeared yet. I closed out of the Linked DB
and reopened it and yet found no records. It's like the
DB is not linked but yet it is.

Is it trickier to update linked DB's and are there
procedures I should know about when wanting to update a
linked DB's source DB?

Thanks

 

[ELF]

There are no issues with having to refresh links in the situation you
describe (happens sometimes if the tables are SQL, but not in pure Access).

But...your description is a little confusing (at least to me<g>). I can't
follow what you mean by "linked" vs "source" db. Standard terminology is
"Front End" for the database containing forms, queries, etc, and "Back End"
for the database containing the actual tables.

Perhaps you could re-post using this terminology and un-confuse me.

Eric

 

[Tim Ferguson]

I deleted 30 records in the linked DB. I
checked the source DB and all the records were still
there. I refreshed the link in the linked DB and non of
the records appeared yet.

My bet is that the tables were imported not linked. What do you see if you
right-click on the table in the database window and choose Properties?

Tim F