MDB on IIS - permission denied

[dickinso]

I have an asp form that submits data to an mdb. The users trying to directly access data in the mdb (not via the web) receive the message that the database is read-only. Usually the data will be accessed via a second mdb on another server (linked tables). While the two users can view the data from the second mdb, they are unable to edit it. To top it all off, every once in awhile a submit to the database from the asp form never reaches the db. Thankfully, the asp provides a printout for the submitter.

I have checked permissions on the shares and the database -"everyone" has full access. Is this a permissions issue on the IIS? Should I move the data to a SQL database?

Any help would be greatly appreciated.

 

[mrdenny]

I would definetly move the data to a SQL database. If cost is an issue you can use MSDE as the back end. SQL Server is a much more robust database and will handle being a web backend much better than access.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

(My very old site)

 

[dickinso]

So you believe the problems I'm having are related to Access? It will take me some time to move the data over, simply because I'm just not that familiar with SQL.

Thanks much for the response!

 

[dickinso]

RESOLUTION: For anyone who may have this problem after me, There are separate share permissions when you access the share from the IIS server. Although we thought we had checked all permissions on the folders and the shares, we had not thought to terminal service into the server itself. If you right click on the shared folder from the server, go to properties you will find another permissions button on the "Sharing" tab. My users did not have permissions to change, which was the problem.

Hope this helps someone!