Update of tables in linked databases

  • Thread starter Thread starter Gabe
  • Start date Start date
G

Gabe

I made a read only copy of my database to share with
people and placed it on a public folder. I would like
for the tables (in the copy) to be updated automatically
whenever the original is edited. I see in the HELP
facility there is a way to do this "acOLEUpdateAutomatic"
in the "update options OLE/DDE" command but it is blacked
out on my menu. Does anyone have any clarification on
this? I'm not all that familiar with VB and I'm not
clear on where to put this command. Thanks, Gabe
 
Sorry, acOLEUpdateAutomatic is nothing to do with what you want here.

You understand that you will not be able to update the copy if it is marked
"read only"? You will probably have to get all users out of it, then change
it to read/write, then update the tables, then change it back to read-only &
let the users back in. It would not make sense for Windows to let any
process update a "read only" file!

As for >how< to update the tables, your choices are:

(1) Replication; but that's a complex topic that I know nothing about;

(2) Writing code to keep track of changes to the original tables, then
repeat those changes to the copy; but that would take waaaay more
programming experience than you admit to having; or,

(3) The easy way: tell the users that the data is only updated once per day.
At the end of the day, when no-one is in the copy, just replace it with a
new copy of the original.

HTH,
TC
 
Back
Top