Discussion Locked

ASP.NET SQL Problem: Read/Write?

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

I got ASP.NET SDK and tried my first database script. Accessing the data went fine, but trying to update or make any changes to the database gave me errors. After opening up my database (in Access), I received a message box saying that the database was now read-only. I tried the following (hints from other posts, etc.):

1. Turned replication off in the Access database
2. Checked if IUSRL_ANDREWPERSONAL had write permission to both the directory and the file (in IIS)
3. Checked the database file's properties in windows explorer to see if it was read-only.
4. Checked the System DNS under the ODBC data source administrator to see if THAT was read-only.

I can't seem to figure out why the database was turned read-only AFTER I designed and saved it initially. I even tried all over again to see if it was just a fluke and re-copied the database into my wwwroot/db/

Any help on this would be greatly appreciated

1 reply

by nikki96

Have you opened the Access DB in Access and checked your permissions in the Tools->Options menu? Look on the Advanced tab and see what the locks are set to and such. Make sure it isn't set to lock all the records. Also check the Tools->Security menufor all the permissions. Make sure everyone is in group or admin. Don't forget - ASP runs anonymous (or whatever admin set it to run as) for DB queries, so you have to either set ASP to run as a specific user (you need to be the system admin for this) and give that user permissions for the DB or allow everyone to modify AccessDB.

Just a few thoughts...
nikki

This discussion is closed to new replies.