Peter
|
| Posted: 09/29/2002, 7:07 AM |
|
Hi,
I'm using your sample application "bugtrack" with MS-ACCESS 2000
When i try to update or to insert one row in any table (like a bug or an employee), i get the followed error message :
Operation must use an updateable query. (Microsoft OLE DB Provider for ODBC Drivers)
Besides, i caught the generated query and i executed it directly in ACCESS.
it works fine
Can u help ?
thanks
|
|
|
 |
Eladesor
|
| Posted: 09/29/2002, 7:53 AM |
|
If you do a search on this forum / the help files and the newsgroup you’ll find loads of solutions.
Regards
Eladesor
|
|
|
 |
Nicole
|
| Posted: 10/02/2002, 1:54 AM |
|
Peter,
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
XP's folder properties are quite a bit different. Here is a MS KB article
with screen shots on how to access the permissions in XP. http://www.microsoft.com/windowsxp/pro/using/itpro/managing/filesharing.asp
|
|
|
 |
jgmoreira
|
| Posted: 10/03/2002, 12:41 PM |
|
Try this: with the right button of the mouse, check your database file — (*).mdb — "properties". You have to give permission to the user of the web site to change the recordsets in the table.
|
|
|
 |
|