linked table not updating ..what to check ?

[Steve]

Hi,
I have a table (call it Tbl_storage) in one database (call it DB1) holding
storage box numbers and contents details. Entries are via a form.
In another database (call it DB2) I have Tbl_storage linked in on table
view and entries are also made via a form.
I open DB1, with DB2 closed, and make entries into Tbl_storage via form,
save and close DB1 and open DB2 but form for linked Tbl_storage does not
update to show those additions.

If I try to make entries to that table via this form in DB2, they dont
appear in Tbl_storage in DB1.

Tbl_storage has 105 records in DB1 and DB2 form showing 103.
If I double-click the linked Tbl_storage in table view DB2 it shows 103
records and the last entry I made to it in DB2, but that entry is not
visible in Tbl_storage in DB1.

What can I click on and check for where the system has broken down as up to
now its worked fine and I dont recall doing anything today to upset it, just
entered a few records.

Thanks
Steve

 

[John W. Vinson]

Hi,
I have a table (call it Tbl_storage) in one database (call it DB1) holding
storage box numbers and contents details. Entries are via a form.
In another database (call it DB2) I have Tbl_storage linked in on table
view and entries are also made via a form.
I open DB1, with DB2 closed, and make entries into Tbl_storage via form,
save and close DB1 and open DB2 but form for linked Tbl_storage does not
update to show those additions.

Sounds like you have two independent local tables, not linked. If you
look at the Tables window in DB2, is there an arrow by TBL_Storage? If
you right mouseclick on the tablename, do you see the path to DB1?

John W. Vinson [MVP]

 

[Steve]

Hi,
in DB2 it has an arrow beside the table in table view, and right click on
that table name, guess you wish me to look at properties (as nothing else
shows except a list of 'open' design view', print etc etc) ....so choose
properties, it says type: Table:Linked Access and above that is the table
name as seen in DB1.
Steve

 

[John W. Vinson]

Hi,
in DB2 it has an arrow beside the table in table view, and right click on
that table name, guess you wish me to look at properties (as nothing else
shows except a list of 'open' design view', print etc etc) ....so choose
properties, it says type: Table:Linked Access and above that is the table
name as seen in DB1.

Hrm. That should be OK. Try this:

- Open DB2, and DELETE the link to DB1
- Compact the database
- Use File... Get External Data... Link to re-link to DB1

I've often found that this step is necessary if you make changes to
the design of anything in the backend.

John W. Vinson [MVP]

 

[Steve]

Hi,
Thanks,
I guessed this may be the only way, did this and now it updates,
Odd though why it tripped up as not altered anything anywhere in fact to
cause it !
One thing I recall is I entered V for a storage code into the window where
the drop down list should then prompt me for that entry, saves scrolling
down and it said data not found, but thats a chicken and egg case as
what came first situation I guess.
Steve