Delphi ODBC and MS Access 2.0

[Bill Harback]

I have connected to an MS Access 2.0 database and am having trouble posting
updates to any of the tables.

I keep getting the following error:
General SQL Error.[Microsoft][ODBC Access Driver].Jet Error - 1003 Returned

This message only occurs when attempting to post a change. All other operations
appear to work fine.

What is strange is that when I connect to the sample database NWIND.MDB that
ships with ACCESS I have no problems?

The only information on the error message that I've been able to find is
it indicates an "Invalid API Parameter".

Has anyone else experienced this problem? Any help would be greatly appreciated.

Thanks

[Richard Vowles]

Bill Harback (bhar...@delphi.com) wrote:
: I have connected to an MS Access 2.0 database and am having trouble posting

: updates to any of the tables.
:
: I keep getting the following error:
: General SQL Error.[Microsoft][ODBC Access Driver].Jet Error - 1003 Returned
:
: This message only occurs when attempting to post a change. All other operations
: appear to work fine.

What version of the drivers are you using? The original one only
worked with VB, and VB data types and was not sophisticated enough to
talk to C (when I was talking C to MS ACCESS 2.0 I got EXACTLY the
same error) or Delphi. The new one was released around January I understand
so if your driver is from a package released before then, you have
to upgrade.

Richard
--
-------------------------------------------
FIDO: Richard Vowles 3:772/110.0,199:310/1.0,77:100/75.0,160:1313/69.0
INTERNET: ric...@nacjack.gen.nz, r.vo...@auckland.ac.nz
WWW: http://www.hmu.auckland.ac.nz/CRichard_Vowles

[Ebbe Jonsson]

Bill Harback (bhar...@delphi.com) wrote:
> I have connected to an MS Access 2.0 database and am having trouble posting
> updates to any of the tables.
>
> I keep getting the following error:
> General SQL Error.[Microsoft][ODBC Access Driver].Jet Error - 1003 Returned

The MS Access ODBC driver that ships with MS Office is intended for use
within Office only; if you try to do inserts or updates with just about
anything else, you'll get this error.

Solution: Upgrade your Access driver to a newer version (the one in
the 2.10 version of the ODBC SDK should work, for one).
--
Ebbe Jonsson, Systems Mangler eb...@dbm.fi
DBM Database Marketing Oy, Helsinki, FINLAND " Q: What is the opposite
Tel: +358 0 605 900, Fax: +358 0 605 991 of information? "