Web server ASP SQL help please.

Factual Questions
1

I’m porting a simple cms (content management system) from one web server to another. It uses an MS access database to store the content.

The problem I’m getting is every second asp query attempt fails because the first attempt seems to have locked the file or left it open.

The first try always works. The second try causes the following error…

Provider error ‘80004005’
Unspecified error
Sometimes it causes a different error such as file (unknown) is already open.

I have the permissions for IUSER set to read write and execute

2

Are you closing/destroying your recordsets and connections properly?

3

yes. with the .close function

And then setting it to ‘nothing’

It’s the same code as was on the other server. But for some reason it behaves differently with the access db

4

Try giving IUSR_ALPHA (which usually has a friendly name of “Internet Guest Account” or something “Full Control” NTFS permissions.

IIRC the “Read/Write/Execute” is just IIS perms. You need NTFS which has perms like Read, Write, Delete, Modify…and you might be getting caught up on Modify.

Browse to the directory using Explorer (not IIS) and right-click on the DB or the DB’s folder, choose the “Security” tab and you’ll see the perms there.