# Web server ASP SQL help please.
**URL:** https://boards.straightdope.com/t/web-server-asp-sql-help-please/426867
**Category:** Factual Questions
**Created:** [November 17, 2007, 10:28pm UTC](https://boards.straightdope.com/t/web-server-asp-sql-help-please/426867 "2007-11-17T22:28:50Z")
**Posts on this page:** 4
**Page:** 1
### Author:  [@Lobsang](https://boards.straightdope.com/u/Lobsang)
#### Post date: [November 17, 2007, 10:28pm UTC](https://boards.straightdope.com/t/web-server-asp-sql-help-please/426867/1 "2007-11-17T22:28:50Z")
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
---
### Author:  [@ZipperJJ](https://boards.straightdope.com/u/ZipperJJ)
#### Post date: [November 18, 2007, 3:59am UTC](https://boards.straightdope.com/t/web-server-asp-sql-help-please/426867/2 "2007-11-18T03:59:47Z")
Are you closing/destroying your recordsets and connections properly?
---
### Author:  [@Lobsang](https://boards.straightdope.com/u/Lobsang)
#### Post date: [November 18, 2007, 5:17am UTC](https://boards.straightdope.com/t/web-server-asp-sql-help-please/426867/3 "2007-11-18T05:17:07Z")
[QUOTE=ZipperJJ]
Are you closing/destroying your recordsets and connections properly?
[/QUOTE]
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
---
### Author:  [@ZipperJJ](https://boards.straightdope.com/u/ZipperJJ)
#### Post date: [November 18, 2007, 10:10pm UTC](https://boards.straightdope.com/t/web-server-asp-sql-help-please/426867/4 "2007-11-18T22:10:14Z")
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.