Board index » delphi » Updating Access 2.0 DB from Delphi 1.02

hors...@portsmouth.uk.ibm.com

Delphi Developer
Tue, 05 Jan 1999 03:00:00 GMT

Updating Access 2.0 DB from Delphi 1.02

We're trying to connect to an Access V2.0 database from Delphi using a DBGrid
connected to Datasource/Table/Database. No problem reading data, but any go
at updating gives a general sql error rc -1003 from the MSoft Jet engine. Anyone
know what the RC means?

We're using the ODBC driver for "Access from Office applications" that ships
with Access, and aren't sure if that's the correct driver or we need to
get another?

Ideas??

Thx, John H

 
WmThomps

Delphi Developer
Wed, 06 Jan 1999 03:00:00 GMT

Re:Updating Access 2.0 DB from Delphi 1.02


I am having a similar problem, but get error number 1018.

Mel Meltz

Delphi Developer
Sat, 09 Jan 1999 03:00:00 GMT

Re:Updating Access 2.0 DB from Delphi 1.02


Quote
hors...@portsmouth.uk.ibm.com wrote:
>We're trying to connect to an Access V2.0 database from Delphi using a DBGrid
>connected to Datasource/Table/Database. No problem reading data, but any go
>at updating gives a general sql error rc -1003 from the MSoft Jet engine. Anyone
>know what the RC means?
>We're using the ODBC driver for "Access from Office applications" that ships
>with Access, and aren't sure if that's the correct driver or we need to
>get another?
>Ideas??
>Thx, John H

You are right - wrong ODBC driver.  If you have vb4 you will find
ODBCJT16.DLL for Delphi 16  and ODBCJT32.DLL for Delphi 32.

HTH

________________________________
m...@cris.com
Mel Meltzer
Take One
Zephyrhills, FL

Other Threads

1. Delphi 1.02 and Access 2.0

2. Delphi 2.0 - BDE under Win3.11 - Delphi 1.02

3. Read/Update MS Access 7.0 db from Delphi Developer 2.0 (PLEASE HELP)

4. Multi-user access to Paradox tables in Delphi 1.02

5. Access to Sybase from Delphi 1.02?

6. Access to registry base under W95 with Delphi 1.02 and 2

7. MS Word 6 accessing Delphi 1.02 DLL (strings)

8. How to go from 2.0 to 1.02 ?

9. Accessing Access 2.0 MDBs from Delphi 2.0

10. How to update 1.0 -> 1.02