Kelly
|
| Posted: 03/08/2002, 8:05 AM |
|
I'm adapting the portal base for an intranet and everything works fine from my computer with all of the files on our intranet, but when someone on another computer tries to REGISTER I get the following error:
"Operation must use an updateable query. (Microsoft JET Database Engine)"
Even when I give a login that is definitely in the database, I get an error:
Microsoft JET Database Engine error '80004005'
Operation must use an updateable query.
Any ideas? or is this too general?
|
|
|
 |
Petr
|
| Posted: 03/08/2002, 9:13 AM |
|
This is very simple. You have uploded/copied the Access database to the
Win2000 server but did not set its permission to write by Everyone.
This has to be done on the server by the administrator.
|
|
|
|
Marty
|
| Posted: 03/09/2002, 7:28 AM |
|
Actually you'll not want “Everyone”. To be safer you should add the “modify” and “write” access by right clicking on the file (the database file) (properties, security) and select the IUSER_SERVERNAME account NOT the Everyone account.
|
|
|
|
Petr
|
| Posted: 03/09/2002, 3:57 PM |
|
For a small group that uses my DB "everyone" setting is of no concern. For a larger fllowing do what Marty wrote.
Basically you need to set he database file for "write" & "modify" on the server. Your error msg translates into not-able to write to the database.
|
|
|
|
Raed
|
| Posted: 03/10/2002, 1:27 PM |
|
I hope u understood the previous replies but if u right click on the folder on Win XP Pro using an NTFS partition u might not find the SECURITY TAB to set ur permissions.
So here is what u do go to Tools->Folder Options->View->Advanced Settings->Uncheck USE SIMPLE FILE SHARING .
Now u can right click on the databse folder and find the SECURITY TAB and set a Read / Write permission.
Believe me it's a slight option but took some time to solve it
|
|
|
|
CodeCharge Support
|
| Posted: 03/11/2002, 6:59 AM |
|
Kelly,
The error you are getting has to do with permissions on your server. Please refer to the following articles:
http://support.codecharge.com/files/CodeChargeFAQ.html#_Toc517263837
http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP
|
|
|
|
