Problems opening a MS Access Database...

[Michel]

Hi,
I need to know if there is anyway of opening a database only for reading
data, is an Access database, the problem is that if the file is open, the
connection fails, saying that the file is already in use.
Can I open the database in a read only mode, or something like that???

Thanxs in advanced.
Michel

 

[AMDRIT]

Usually, when I am first creating an access database the file is flagged as
open and single use. What I have to do is, close the file, and Open it
again in two instances of Access. Now the file is shareable.

Once you have that you should not fail accessing the file from .Net. As
soon as you attempt to modify the schema though, Access will attempt to mark
it single use again. Lesson learned; don't develop against production copy
of the database until you can take it offline.

If the database is marked single use "exclusive", then only the person
editing the file can work with it until the file is closed.

 

[Michel]

Thanks..

Usually, when I am first creating an access database the file is flagged
as open and single use. What I have to do is, close the file, and Open it
again in two instances of Access. Now the file is shareable.

Once you have that you should not fail accessing the file from .Net. As
soon as you attempt to modify the schema though, Access will attempt to
mark it single use again. Lesson learned; don't develop against
production copy of the database until you can take it offline.

If the database is marked single use "exclusive", then only the person
editing the file can work with it until the file is closed.