Refreshing linked tables

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In my split database new records to my main table are not coming up in
subsequent queries until the linked tables are refreshed. Can i write a
macro that refreshes tables whenever a user opens his front end? The users
are not able or will not go through the extra step on their own.
 
Dan,

This doesn't sound right... if the tables are indeed linked, any change
in the back end should be available to the front ends instantly, without
the need to do anything. Any chance your tables are imported rather than
linked? Or, maybe, you are using replication?

Nikos
 
Nikos, They are linked, but i think i found my problem - bad design. Getting
better at it as i go though. Thanks
Dan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

linked view from database, Can append but not refresh- help? 1
Prevent Query Update until I press refresh button 2
Refreshing Data Daily From a Linked Excel Spreadsheet 4
Refresh Table 3
automated transfer of data between tables 6
Link Queries? 5
Help updating a table 5
Refresh Query Table causing debug error with Background Refresh pr 2

Back
Top