redfrost
|
| Posted: 01/13/2003, 9:42 PM |
|
g'day there
wonder if you could help out a rookie.... everytime i try to add/edit the database i get the following error...
Source: Record articles / Update Operation
Command Text: UPDATE [articles] SET [article_title]='Monthly Meetings', [category_id]=10, [article_desc]=?, [date_end]=#2010-12-31 00:00:00#, [date_add]=#2000-12-26 00:00:00# WHERE [article_id] = 14
Error description: Operation must use an updateable query. (Microsoft JET Database Engine)
UPDATE [articles] SET [article_title]='Monthly Meetings', [category_id]=10, [article_desc]=?, [date_end]=#2010-12-31 00:00:00#, [date_add]=#2000-12-26 00:00:00# WHERE [article_id] = 14
any help please
|
|
|
 |
jiggypoo
|
| Posted: 01/16/2003, 11:08 AM |
|
What database engine are you using? Jet usually refers to Access Jat engine.
Please let us know;
|
|
|
|
redfrost
|
| Posted: 01/16/2003, 3:47 PM |
|
hi there
sorry for that i am using an ms access database .. it is just the demo in ccs the portal. all i did was put it on the server just like i found it.. and it displays everything but can not edit or update anything
|
|
|
|
mars
|
| Posted: 01/17/2003, 8:54 AM |
|
you must give proper access to the database and folder database. security permissions for the IUSR_localmachine
|
|
|
|
redfrost
|
| Posted: 01/17/2003, 4:53 PM |
|
thanks for that you all... problem solved.... really appreciated
|
|
|
|
|
