Forums
This topic is locked
updatable query
Posted 20 Feb 2003 03:07:59
1
has voted
20 Feb 2003 03:07:59 John Bowden posted:
Hi, I'm having a problem with my insert statements. Whenever I try to insert a record into my database (access2000) I keep getting a "statement must be an updatable query" error. I have absolutely no idea about what's wrong with it (code generated by DMX). I have a select statement up and running. But this just doesn't seem to want to work. I'm running DMX on an XP system. I've previously had the same kind of set up and had no problem.
If anyway can help me, I will be eternally grateful.
Cheers
Replies
Replied 20 Feb 2003 04:25:35
20 Feb 2003 04:25:35 John Bowden replied:
Here's the actual message
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/cbmsite/CBMPages/addClient2.asp, line 115
Error Type:
Microsoft JET Database Engine (0x80004005)
Operation must use an updateable query.
/cbmsite/CBMPages/addClient2.asp, line 115
Replied 20 Feb 2003 16:31:21
20 Feb 2003 16:31:21 Brent Colflesh replied:
Dear JJB,
Take a look here:
www.macromedia.com/support/ultradev/ts/documents/80004005update.htm
Regards,
Brent
Take a look here:
www.macromedia.com/support/ultradev/ts/documents/80004005update.htm
Regards,
Brent