Trouble posting to Access table via ODBC 
Author Message
 Trouble posting to Access table via ODBC

   I'm trying to manipulate existing tables in an access 95 database
with some code written in Delphi 2.0. I'm able to view the table and
move around, no problem. But whenever I do a post, either via pascal
or using a component, I get a "General SQL error." associated with an
EDBEngineError. This happens even if the code is as simple as

table1.edit;
table1.post;

  Again, viewing and moving around the table are no problem. Does
anyone have any ideas what this could be about? Thanks.

                                                   --Rick



Tue, 19 Oct 1999 03:00:00 GMT
 Trouble posting to Access table via ODBC

Roderic,
Exist Delphi 3.0 now !
Delphi 3.0 incorporate native access to "Microsoft Access" database. No
more problems about it. New Dephi 3.0 solve problem for you.

I hope this notice help you

Charlie Market



Quote:

>    I'm trying to manipulate existing tables in an access 95 database
> with some code written in Delphi 2.0. I'm able to view the table and
> move around, no problem. But whenever I do a post, either via pascal
> or using a component, I get a "General SQL error." associated with an
> EDBEngineError. This happens even if the code is as simple as

> table1.edit;
> table1.post;

>   Again, viewing and moving around the table are no problem. Does
> anyone have any ideas what this could be about? Thanks.

>                                                    --Rick



Fri, 22 Oct 1999 03:00:00 GMT
 
 [ 2 post ] 

 Relevant Pages 

1. troubles with access via jdbc-odbc-bridge

2. Linking to Access table via BDE via ODBC

3. Problem accessing System table in Microsoft Access via ODBC

4. ACCESSING TEMP TABLES VIA ODBC FROM ACCESS?

5. Preventing table update when linking oracle database table to access via ODBC

6. Password required when accessing Pdox tables via ODBC

7. Howto Make or Copy SQLServer Table to Access db via ODBC

8. Is BDE needed when accessing tables via ODBC?

9. Problems Accessing Pervasive/Btrieve Tables via ODBC

10. Access Linked Tables via ODBC Performance??

11. Can't access table in SQL Server via ODBC


 
Powered by phpBB® Forum Software