I'm trying to use ASP to return records from an MS Access 97 database



 The following code is from page 202 of "beginning ASP Databases", WROX 

Press...



set oConn=Server.CreateObject("ADODB.connection")

set oRS=Server.CreateObject("ADODB.Recordset")

strSource = "Provider=Microsoft.Jet.OLEDB.3.51"

strSource = strSource & "; Data Source=C:\My Documents\ASPADO.mdb"

oConn.ConnectionString = strSource

oConn.Open



sqltext = "SELECT name FROM People;"

oRS.Open sqltext, oConn



This works absolutely fine except for when the database is open in MS 

Access.  In that case I get the following error...



Microsoft JET Database Engine error '80004005'

Could not use ''; file already in use.

?



I've never had this problem using DAO and I don't think it is an ADO 

problem either.  So does it have something to do with the ASP model?



I need to be able to accesss the database from a WebPage(with ASP/ADO) and 

also allow people to have the database open in MS Access simultaneously.  

Are there any suggestions about how to do this?

Thanks

This is a know problem, and is usually permissions related. When

accessing data from ASP pages, it's ASP that is the user. That means the

IUSR_ account, and this user might not have permission on the

appropriate directory, so check your permissions.



Also, check out the following:



http://support.microsoft.com/support/kb/articles/Q174/9/43.ASP

http://support.microsoft.com/support/kb/articles/Q183/0/60.ASP



Dave







"jon" wrote in message

news:<6553BCF3E25DD2118F0A00AA00AE6AAA21DF09@t...>...

> I'm trying to use ASP to return records from an MS Access 97 database

> 

>  The following code is from page 202 of "beginning ASP Databases",

WROX 

> Press...

> 

> set oConn=Server.CreateObject("ADODB.connection")

> set oRS=Server.CreateObject("ADODB.Recordset")

> strSource = "Provider=Microsoft.Jet.OLEDB.3.51"

> strSource = strSource & "; Data Source=C:\My Documents\ASPADO.mdb"

> oConn.ConnectionString = strSource

> oConn.Open

> 

> sqltext = "SELECT name FROM People;"

> oRS.Open sqltext, oConn

> 

> This works absolutely fine except for when the database is open in MS 

> Access.  In that case I get the following error...

> 

> Microsoft JET Database Engine error '80004005'

> Could not use ''; file already in use.

> ?

> 

> I've never had this problem using DAO and I don't think it is an ADO 

> problem either.  So does it have something to do with the ASP model?

> 

> I need to be able to accesss the database from a WebPage(with ASP/ADO)

and 

> also allow people to have the database open in MS Access

simultaneously.  

> Are there any suggestions about how to do this?

> Thanks

> 




$subst('Email.Unsub')

David,

Thank you for your help on this.  The links you gave had detailed 

instructions that cleared up this problem right away.  Thanks, again!

John