Re: Problems opening a MS Access Database...

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks..

"AMDRIT" <amdrit@xxxxxxxxxxx> wrote in message
news:O0PI9IZWGHA.1192@xxxxxxxxxxxxxxxxxxxxxxx
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" <NoSp@xxxxx> wrote in message
news:uNLQqWYWGHA.5012@xxxxxxxxxxxxxxxxxxxxxxx
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





.

Relevant Pages

  • Re: boot up
    ... You can try connecting and reconnecting if the connection fails or/and wait for a minute or so before the application tries to connect, ... Microsoft.Win32.RegistryKey rkApp = ... Express Edition database on the local machine. ...
    (microsoft.public.dotnet.framework.adonet)
  • Robust Method For Testing Database Handles
    ... Trying to determine a reliable, rock-solid, low-cost method of testing ... If the database is down or the connection fails or anything that will ...
    (comp.lang.perl.misc)
  • Re: Reporting Failure to SCM from Windows Service developed in VB.NET
    ... Web interface: ... > counter and updates a table in a database. ... > connection to the database fails. ... Also, if the connection fails, I would ...
    (microsoft.public.dotnet.general)
  • Re: Try Catch and close the form
    ... Saved to the database that you could not connect to in the catch statement? ... If that code fails, you could have wierd ... attempting to open a connection, and if this connection fails, I want ... Me.Close in the Catch part is not closing the ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Problems opening a MS Access Database...
    ... when I am first creating an access database the file is flagged as ... If the database is marked single use "exclusive", ... connection fails, saying that the file is already in use. ...
    (microsoft.public.dotnet.general)