database locked - but no users!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David Gartrell - 10 May 2006 14:45 GMT

Hi Again,

Don't know if you can help with this but here goes. I've got an Access 2000
database that several users access. What I'm trying to do is to amend one
of its reports but it won't let as it says i don't have exclusive access to
the database. The thing is, I know for sure that no-one else is in it (i've
checked every computer on our network). I've tried to delete the ldb file
but it wont let me as it says its "being used by another person or program".

Does anyone have any suggestions as to how I can get back control of the
database?

many thanks

David.

Reply to this Message

Keith Wilby - 10 May 2006 15:22 GMT

> Hi Again,
>
[quoted text clipped - 12 lines]
>
> David.

Do *you* have the db closed when you attempt to delete the record locking
file? To open in exclusive mode you need to use the 'exclusive' command
line switch, but having said that you should really split your database into
front/back ends and modify only your development copy. Only when you're
happy with your changes should you then make it available to your users (one
copy per user on a local drive).

Regards,
Keith.

Reply to this Message

david@epsomdotcomdotau - 11 May 2006 00:57 GMT

After you disconnect from your server, Windows will eventually
time out and disconnect any orphaned connections.

You get orphaned connections when you switch the power off
or kill open applications.

If you turn the power off at night on all your workstations, the
next morning when you come in you will find that the server
has released any orphaned connections.

Or you can just go to your server and tell it to disconnect all
users from the file. But that assumes you are really sure that
no user is using the file.

(david)

> Hi Again,
>
[quoted text clipped - 11 lines]
>
> David.

Reply to this Message