tracing open table links

  • Thread starter Thread starter perryclisbee via AccessMonster.com
  • Start date Start date
P

perryclisbee via AccessMonster.com

I have a source table in one database. I have alot of other databases that
have a link to this table. Each week I need to recreate this table
(maketable) with updated information, but I cannot as long as any one of
those other databases are open. Is there a solution to this that I'm not
thinking of? I need to find out which databases are open and by which users,
so I can get them closed. Is there also a way to find all access databases
that have that specific link in them?

Thanks,

Perry
 
The quick answer is No.
You would be able to accomplish your objective if you change the maketable
to an append and leave the table in place. Just delete the data from the
table before creating the new data in it.
 
Back
Top