Mervin Pearce
|
Posted: 06/05/2002, 2:15 PM |
|
Source: Record users / Update Operation
Command Text: UPDATE [employees] SET [emp_name]='John Smith',
[email]='johns@company.com', [emp_login]='johns', [emp_password]='johns',
[group_id]=2 WHERE [emp_id] = 1
Error description: Operation must use an updateable query. (Microsoft JET
Database Engine)
UPDATE [employees] SET [emp_name]='John Smith', [email]='johns@company.com',
[emp_login]='johns', [emp_password]='johns', [group_id]=2 WHERE [emp_id] = 1
Any ideas. I had it working once but the next project nothing seem ot
update now. Using default settings and the database is OK. I can update
using Access normally.
|
|
|
Alexey Alexapolsky
|
Posted: 06/12/2002, 2:43 AM |
|
Refer to http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP
--
Alex
CodeCharge Developer
"Mervin Pearce" <mervin@nospam.sacs.co.za> wrote in message
news:adlv0s$c4d$1@news.codecharge.com...
> Source: Record users / Update Operation
> Command Text: UPDATE [employees] SET [emp_name]='John Smith',
> [email]='johns@company.com', [emp_login]='johns', [emp_password]='johns',
> [group_id]=2 WHERE [emp_id] = 1
> Error description: Operation must use an updateable query. (Microsoft JET
> Database Engine)
> UPDATE [employees] SET [emp_name]='John Smith',
[email]='johns@company.com',
> [emp_login]='johns', [emp_password]='johns', [group_id]=2 WHERE [emp_id] =
1
>
> Any ideas. I had it working once but the next project nothing seem ot
> update now. Using default settings and the database is OK. I can update
> using Access normally.
>
>
|
|
|
|