Are you going to be replacing it with a new database? Problem: Users are accessing the file. (as you said, users are opening in read-only) Solution: (assuming you will be using a new, better... anything is better than M$, database) --- put the new database online, redirect your users to hit the new database, once all connections are closed, delete the Access database. Alternate Solution: (if you aren't replacing it) Just turn the database server off (that will kill any connections) and delete the database, or at least disable that database from within the server itself (thus closing all connections) and delete it.
Read only or not, the DB is still open, and can't be deleted while people are connected. 2008/3/20, Ahmed, Shakir <[EMAIL PROTECTED]>: > > I have a Microsoft Access database that I want to delete whether anyone > is using that file. > > The database is already read only mode residing in a server, users are > opening in read only mode. I want to delete that file, I remove read > only check but could not delete that file. > > Getting error message: > Cannot delete xxx : It is being used by another person or program. > > Any help is highly appreciated. > > Thanks > sa > > > > -- > http://mail.python.org/mailman/listinfo/python-list >
-- http://mail.python.org/mailman/listinfo/python-list
