Close Open tables

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

Guest

I have a database that updates nightly through a macro. Sometimes in the morning there is an error. This error is from people who forget to close the table or are in editing a record in the table. Is there a way to close the table before running the macro. I know there is the close macro that close the table but it just works on the machine you are on. Is there code that will also shut everybody out of the table taht needs updateing?

Thanks,
Wes Paul
 
On my website are two sample databases: LogUsersOff2k.zip and
LogUsersOffNonUse2k.zip, which might be of some use to you. These
illustrate how to 1) log everybody off remotely or 2) log a user off after a
certain time of non use.

--Roger Carlson
www.rogersaccesslibrary.com

Wes said:
I have a database that updates nightly through a macro. Sometimes in the
Click to expand...
morning there is an error. This error is from people who forget to close
the table or are in editing a record in the table. Is there a way to close
the table before running the macro. I know there is the close macro that
close the table but it just works on the machine you are on. Is there code
that will also shut everybody out of the table taht needs updateing?
 
Back
Top