Sharing Access database with web application

[alexander medwedew]

I'm encountering a problem when my MS Access database is opened
simultaneously with by Access and an ASP based intranet application. Even
though the database is set for shared use, any use of MS Access forms closes
all web connections to tables and sets the permissions to exclusive use
until the form is closed. Is there something I may be missing?

 

[Douglas J. Steele]

Does the security context that ASP is running under (usually
IUSR_<MachineName>) have the appropriate permissions to the folder where the
MDB file exists? How is the database being opened?

 

[alexander medwedew]

The database permissions are set to "Everyone". The ASP code is connecting
to a linked database located under wwwroot. The MS Access application is
also linked to the master database located in the same application directory
in Program Files. ASP routines are only being used for viewing data on the
LAN. The server computer is running Win XP Pro SP2 and the MS Access
version is 2003. This problem occurs on all similarly configured
applications on other computers.

ASP code:

DIM objConn
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &
Server.MapPath ("../database/streetfairs.mdb") & ";"
objConn.Open

DIM mySQL, objRS
mySQL = "SELECT [fairs].* FROM [fairs]"

Set objRS = Server.CreateObject("ADODB.Recordset")
objRS.CursorType = 1
objRS.Open mySQL, objConn