Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss

Delphi 5, ADO and Access

9 views
Skip to first unread message

Ger Otten

unread,
Apr 23, 2001, 6:34:37 AM4/23/01
to
Hello,

I have a problem with Delphi 5 professional, Delphi ADO installed and Acces
2000. When I set up a datalink to an Access Database with an TADOConnection
object
and I open an Query using a TADOQuery object, I get the following message
when I add or update a
record:

Project Project2.exe raised exception Class EoleException with message
‘Operation must ben an updateable query’. Process stopped. Use step or Run
to continue.

In this situation the connection to the database is: Mode = Share Deny
Write.

If I use an TADOTable object instead of the TADOQuery object all works fine.

I have this problem on a Access 97 or Access 2000 database under Windows NT
2000 and Windows 98 , with MDAC 2.6 installed.

When the mode is Share Exclusive or Share Read Write all works fine. To me
this looks like an Delphi problem and not and Microsoft problem?

Questions:

1. Am I doing something wrong?
2. If not, any solutions?

Please respond to this list or directly to me: g.m.j...@dnb.nl

Ger Otten

Rudy Kappert

unread,
Apr 25, 2001, 8:29:44 AM4/25/01
to
A Query is an Read only object. You can't edit the field..

If you want to update field use a SQL statement.


On Mon, 23 Apr 2001 12:34:37 +0200, "Ger Otten" <g.m.j...@dnb.nl>
wrote:

0 new messages