By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,461 Members | 2,184 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,461 IT Pros & Developers. It's quick & easy.

loc files

P: n/a
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
Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
"Peter Bailey" <pe*********@andaluz.fsbusiness.co.uk> wrote in message news:<cg**********@news7.svr.pol.co.uk>...
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.


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...
Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.