snowboardr
|
Posted: 01/20/2002, 9:45 AM |
|
Operation must use an updateable query. (Microsoft JET Database Engine)
What does this mean? I set it up in the database so it could ReadWrite..I have had this problem for a while now..
|
|
|
Brent
|
Posted: 01/20/2002, 10:37 AM |
|
You didn't say where this error occurs. It's like telling a doctor,
"I've got this pain, can you fix it?" and you don't tell the doctor where
the pain is or when it occurs. :)
I suspect your SQL statement is causing the problem. There are 2 types of
queries, updateable where you can modify the rows that are returned, and
non-updateable which means the result set is readonly.
Non-updateable queries are usually caused when the SQL statement is retrieving
columns from 2 or more tables, as in a View. You are probably using a View
on an updateable form. You should be using a table.
If you want an updateable Select statement that has data from another table,
then you need to base the Select on only 1 table and then lookup the data
from the secondary table.
I hope this helps. And "take two aspirin and call me in the morning". :)
|
|
|
Nicole
|
Posted: 01/21/2002, 1:51 AM |
|
The error you are getting has to do with permissions on your server. Refer to the following articles:
http://support.codecharge.com/files/CodeChargeFAQ.html#_Toc517263837 http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP
|
|
|
Nicole
|
Posted: 01/21/2002, 1:51 AM |
|
The error you are getting has to do with permissions on your server. Refer to the following articles:
http://support.codecharge.com/files/CodeChargeFAQ.html#_Toc517263837 http://support.microsoft.com/support/kb/articles/Q175/1/68.ASP
|
|
|
|