Phil
|
Posted: 03/01/2004, 8:40 AM |
|
Hello,
I put the CSS sample project (Intranet) on my PC, but when I try to insert or update records, I got error message like :
"Source: Record users / Update Operation
Command Text: UPDATE employees SET emp_name='Stane Knight', email='stanek@company.com', emp_login='stanek', emp_password='stank', group_id=2 WHERE emp_id = 34
Error description: L'opération doit utiliser une requête qui peut être mise à jour. (Microsoft JET Database Engine)<br>UPDATE employees SET emp_name='Stane Knight', email='stanek@company.com', emp_login='stanek', emp_password='stank', group_id=2 WHERE emp_id = 34<br><br>"
I verifies the access rights, and the attributs on directory ... It s OK.
I get Access2003 on my computer...
I don't understand why the MS JET database engine raised an issue.
could you help me ?
Regards,
Phil
|
|
|
DonB
|
Posted: 03/01/2004, 8:46 AM |
|
This surely is the recurring issue with Access databases - where the
webserver account (IUSR_machinename) is not granted write permission to the
folder where you stored the Access database file. Your "machinename" should
be substituted in this username.
The web service does not run under your userid, it has it's own. So if you
verified YOU have write access then that is not sufficient. Look for this
other account and grant it access, too.
--
DonB
http://www.gotodon.com/ccbth
"Phil" <Phil@forum.codecharge> wrote in message
news:64043678920e28@news.codecharge.com...
> Hello,
> I put the CSS sample project (Intranet) on my PC, but when I try to insert
or update records, I got error message like :
> "Source: Record users / Update Operation
> Command Text: UPDATE employees SET emp_name='Stane Knight',
email='stanek@company.com', emp_login='stanek', emp_password='stank',
group_id=2 WHERE emp_id = 34
> Error description: L'opération doit utiliser une requête qui peut être
mise à jour. (Microsoft JET Database Engine)<br>UPDATE employees SET
emp_name='Stane Knight', email='stanek@company.com', emp_login='stanek',
emp_password='stank', group_id=2 WHERE emp_id = 34<br><br>"
> I verifies the access rights, and the attributs on directory ... It s OK.
> I get Access2003 on my computer...
> I don't understand why the MS JET database engine raised an issue.
> could you help me ?
>
> Regards,
> Phil
>
> ---------------------------------------
> Sent from YesSoftware forum
> http://forums.codecharge.com/
>
|
|
|
peterr
Posts: 5971
|
Posted: 03/02/2004, 3:19 AM |
|
Also see: http://groups.google.com/groups?hl=en&lr=&ie=UTF-8&oe=U...%22&sa=N&tab=wg
_________________
Peter R.
YesSoftware Forums Moderator
For product support please visit http://support.yessoftware.com |
|
|
Philippe
|
Posted: 03/02/2004, 1:59 PM |
|
The problem was Access rights incorrect...
Many thanks
Phil
|
|
|
|