loc files

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Peter Bailey - 28 Aug 2004 07:00 GMT

I have an update query that can only be run if the database is not being
used (well apart from myself of course to do the update on the table
(converting fields in a table to propercase))

Is their a way to only run the query if the table or database is not being
accessed. They have no security set up, historically they do a search on the
user areas of the network to look for loc files on the back end.

It would be nice for access to run the query in the front end if no users
apart from myself were accessing it.

Regards in advance for advice

Reply to this Message

Pieter Linden - 31 Aug 2004 02:02 GMT

> I have an update query that can only be run if the database is not being
> used (well apart from myself of course to do the update on the table
[quoted text clipped - 3 lines]
> accessed. They have no security set up, historically they do a search on the
> user areas of the network to look for loc files on the back end.

If you're using Access 2000 or later, you can use this article to get
you started:

http://support.microsoft.com/?id=198755

You could modify the code to return a number of users from the
UserRoster. Or you could run KickEmOut from www.datastrat.com and then
run your code...

Reply to this Message