fmb
|
| Posted: 03/30/2003, 4:47 PM |
|
This is weird - I've changed laptops, configured my new box almost identical to the old. I use CC with PHP & MS Access. Databases are read OK, but no updates, deletes, inserts are working. Any ideas?
|
|
|
 |
chank
|
| Posted: 03/31/2003, 2:52 AM |
|
I found the same problem on CC2. Anyone can help me?
|
|
|
|
chank
|
| Posted: 03/31/2003, 3:14 AM |
|
The error you are getting indicates that the database access permissions are not set correctly. For starters, if you are using Windows NT or 2000, please set the security on the .mdb file and its parent directory to "full-access". If you use Windows 95/98/Me, right-click on the .mdb file and make sure that "read-only" is unchecked, then do the same on the directory where your .mdb file is located. Also, note the following:
1) This error may occur if the account being used by Internet Information Server (IIS), (usually IUSR), does not have the correct Windows NT permissions for a file-based database or for the folder containing the file.
2) Use the Windows NT File Monitor to check for file access failures. Windows NT File Monitor is available from the following Web site: <http://www.sysinternals.com>.
3) If you use a network path to the database (UNC or mapped drive), check the permissions on the share, the file, and the folder.
4) Check to make sure that the file and the data source name (DSN) are not marked as Exclusive.
5) Make sure no other process uses this mdb file.
6) This error may also occur when accessing a local Microsoft Access database linked to a table where the table is in an Access database on a network server. In this situation, please refer to the following article in the Microsoft Knowledge Base for a workaround.
This error is attributed to the design of Microsoft products and you can read more about it at:
PRB: ASP Returns 'Operation Must Use an Updateable Query' Error
http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP
**************************************************************
Any ideas on permission setting?
|
|
|
|
fmb
|
| Posted: 03/31/2003, 4:53 AM |
|
Thanks - all good suggestions. I forgot to mention I'm using apache 1.3, and everything is running on my local Win XP box. I don't have any security set up on the mdb at this point, and the ODBC setting seems standard.
|
|
|
|
|
