Linked Tables

  • Thread starter Thread starter brian
  • Start date Start date
B

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
 
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
 
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.
Click to expand...

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
 
Back
Top