ASP.NET with Access: concurrent users?

[Steven Spits]

Hi group,

My ASP.NET application connects to an Access database using OleDb. This is
my connection string:

Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\xxx\yyy\zzz.mdb;

From time to time I'm getting an [OleDbException (0x80004005): Unspecified
error] when trying to open the connection to this database.

Using Google, this seems to be a read/write security thing. However, my
application works 90% of the time, so read/write access should be okay.

I'm suspecting it has something to do with concurrent users. How does Access
handle this? Can two users open the same MDB at the same time? My
application only executes SELECT-statements.

Steven

- - -

 

[Paul Clement]

¤ Hi group,
¤
¤ My ASP.NET application connects to an Access database using OleDb. This is
¤ my connection string:
¤
¤ Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\\xxx\yyy\zzz.mdb;
¤
¤ From time to time I'm getting an [OleDbException (0x80004005): Unspecified
¤ error] when trying to open the connection to this database.
¤
¤ Using Google, this seems to be a read/write security thing. However, my
¤ application works 90% of the time, so read/write access should be okay.
¤
¤ I'm suspecting it has something to do with concurrent users. How does Access
¤ handle this? Can two users open the same MDB at the same time? My
¤ application only executes SELECT-statements.

See if the following helps:

PRB: "Disk or Network Error" or "Unspecified Error" Returned when Using Jet
http://support.microsoft.com/default.aspx?kbid=251254


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