in ASP you may encounter this kind of error:
“Operation must use an updatable query”
Description
(Error 3073)
This is a file permissions issue, it occurs when user wants to modify the Microsoft Access database.
Cause
The Internet account user does not have permission to modify the Access database.
It will not occur when user access the database with SELECT statement(reading data only), except for user using SELECT statement to modify database.
for example:
SELECT * INTO [CityBackup] FROM [city]
The statement will trigger error.
Solution
- Change folder security settings for database contained folder
Steps
- First of all, you must change the folder properties view to advanced view if you are using the simple one that recommended by some Windows versions.
Steps: in explorer window -> tools -> folder properties -> view tab -> uncheck the “use simple file sharing” item. - And then open up properties window for the folder which has the database and configure the security settings.
Steps: security tab -> check allow read and write for your log on account
