Refreshing Data in Linked Tables

[Guest]

I am working on taking four databases that use the same information from two
tables and trying to create a back end db with the tables and three front
ends with the forms and reports. However, when I made a change in my back
end, how do I get the change to cascade through the rest. I linked the
tables, but the new info is not there.

I tried to refresh, but I do not have some of the wizards installed on my
computer, and do no have access to the actual set up discs. Is there a way
to manually refresh so that I can create a macro?

 

[John W. Vinson]

I am working on taking four databases that use the same information from two
tables and trying to create a back end db with the tables and three front
ends with the forms and reports. However, when I made a change in my back
end, how do I get the change to cascade through the rest. I linked the
tables, but the new info is not there.

Then there's something wrong with the linking. There is no "cascading" going
on - the data should exist in the backend, and ONLY in the backend; the
frontend shouldn't actually conatain ANY data, just pointers to the backend
tables.

If you look at the Tables window in the frontend, does each table have a small
arrow to the left of the tablename? If you hover the mouse over a tablename,
you should see the Connect string listing the backend database; do you?

I tried to refresh, but I do not have some of the wizards installed on my
computer, and do no have access to the actual set up discs. Is there a way
to manually refresh so that I can create a macro?

You can simply delete the table from the frontend (just deleting the link, not
the data) - *once you're sure it's a link not the table!!* - and use File...
Get External Data... Link to relink to it; or you can use VBA code to do so.
There are lots of examples on the web.

John W. Vinson [MVP]

 

[Guest]

Yes, there is an arrow, but it tells me it can not find the table. I split
is like the article you refered me to said to do.

 

[John W. Vinson]

Yes, there is an arrow, but it tells me it can not find the table. I split
is like the article you refered me to said to do.

Sounds like the frontend or the backend have been moved, and it can't find the
backend database. If you haven't already done so, try using Tools... Database
Utilities... Linked Table Manager. Select all the tables and click OK.

Navigate to the current location of the backend database; it's best to do so
using Network Neighborhood (or My Network Places or however your machine has
it).

Note that the backend must be in a folder to which you have full
read/write/create/delete privileges.

John W. Vinson [MVP]