Linked tables to Open databases

[Smudger]

I have a db that runs call stats (Master) this exports to several Department (Slave) Databses. The Slave db's can be accessed by any of number of Managers.

My problems (Amongst others!) is that I run the master every 15 mins and the slaves are linked to the master tables. How can I set this up so that these slaves can be updated whilst they are logged into?

 

[KeithG]

Do you have a startup form/Switchboard? If so you could use the Open event and create a TableDef object for the table you want to refrest the link.


Dim myDef as Dao.TableDef


set myDef=currentdb.tableDef("NameOfTable")

myDef.RefreshLink

 

[Smudger]

Thanks for this - I don't really understand what you mean. I have a form that is full of Run Macro boxes on each of the Secondary databases if that is what you mean.?!?!?