.NET Newbie : Read-Only Access DB

[Homer J. Simpson]

Hi ,
My ASP.net web page uses an ACCESS 2000 DB.
Everything works fine, except if i try to open this DB within MS ACCESS.
It always tell me "DB Access is read-only".

My web page works fine, I open and close my connexion, and i'm the only user
working with it.
I was wonderig if this was due to Connection Pooling, so i've added an
OleDbConnection.ReleaseObjectPool().
But i still can't open my DB within ACCESS...

Any ideas ?
Thx in advance.
J.Philippe

 

[Cowboy \(Gregory A. Beamer\)]

You should not open a web database directly with Access. Having said that, a
way around this is to create a second Access database and link the tables in
the web database. You can then run queries, et al, without locking the web
database.

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

**********************************************************************
Think Outside the Box!
**********************************************************************

 

[Paul Clement]

¤ Hi ,
¤ My ASP.net web page uses an ACCESS 2000 DB.
¤ Everything works fine, except if i try to open this DB within MS ACCESS.
¤ It always tell me "DB Access is read-only".
¤
¤ My web page works fine, I open and close my connexion, and i'm the only user
¤ working with it.
¤ I was wonderig if this was due to Connection Pooling, so i've added an
¤ OleDbConnection.ReleaseObjectPool().
¤ But i still can't open my DB within ACCESS...

Sounds like a permissions issue on the folder where the database is located. If Access can't create
an .LDB file then it's opened for read-only access.

I would check to see if you have an .LDB file after opening the database.


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Homer J. Simpson]

Paul,
Thanks for your answer,

I do have necessary permissions to write to the database folder, and I can
see the .ldb file being created !
The problem seems to appear randomly.
It sounds like if the DB was exclusively hold by another process, but wich
one ?
I was thinking about Session duration, but SessionTimeout is set to 1 in my
global.asax.

Any other idea ?

 

[Paul Clement]

¤ Paul,
¤ Thanks for your answer,
¤
¤ I do have necessary permissions to write to the database folder, and I can
¤ see the .ldb file being created !
¤ The problem seems to appear randomly.
¤ It sounds like if the DB was exclusively hold by another process, but wich
¤ one ?
¤ I was thinking about Session duration, but SessionTimeout is set to 1 in my
¤ global.asax.
¤
¤ Any other idea ?

Try using the Process Explorer utility to see if you can identify which applications have the
database open:

http://www.sysinternals.com/ntw2k/freeware/procexp.shtml


Paul ~~~ (e-mail address removed)
Microsoft MVP (Visual Basic)

 

[Homer J. Simpson]

I've found a workaround :

By installing Acess on the server, and opening the DB with it, the problem
seems to disappear.

Anyway, thanks to u all for your help.
Regards,
J.Philippe