Deleting Microsoft access database

[Michael Wieher]

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 <shahmed at sfwmd.gov>:
>
> 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
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mail.python.org/pipermail/python-list/attachments/20080320/8e6ed604/attachment-0001.html>