[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; f

[matttoby]

I am running IIS 5 on a win 2000 machine and I’m making a connection to access 97 database using the following code.

set RSsections = server.createobject("adodb.recordset&quot
SQl = "SELECT * FROM news_section WHERE live_flag Is Null ORDER BY section_id DESC"
RSsections.open SQL,"DSN=xxxx",3,3

This works fine until I try to run it while I have the database open on the same machine, I receive the following error.

Microsoft OLE DB Provider for ODBC Drivers (0x80004005)
[Microsoft][ODBC Microsoft Access Driver] Could not use '(unknown)'; file already in use.

The when I close the database and try to run the page again I receive a different error.

Error Type:
Provider (0x80004005)
Unspecified error

I then need to reboot before the page will run correctly again.

When using PWS I was able to run the page with Access open and it is proving a pain having to close the database every time I need to run the page.

Any Suggestions would be much appreciated.

Thanks

Matt

 

[FesterSXS]

The Unspecified error seems to be related to the permissions assigned to the database folder. Make sure the IUSR account has got write permissions to this folder. You may need to restart IE before noticing a change. This one creeps up on me every now and again and can sometimes bother me for ages before finally going away.


Tony

http://www.SpiraxSarco.com/cad

 

[matttoby]

Many Thanks Tony,

I have added the IUSR account and I'm still getting the same problem at the moment.

Has anyone has any other suggestion I can try??