Board index » delphi » ACCESS "native driver" Primary Keys

ACCESS "native driver" Primary Keys

Both the create table and the localSQL DDL commands allow you to make
paradox primary keys. On the other hand the MS-Access native driver does
not create ACCESS primary keys. (either with ttable.Addindex (,[ixprimary],
or with the DDL CREATE TABLE query), nor does the ODBC driver for that
matter.

What gives?

Tjeerd Jellema
Rotterdam

 

Re:ACCESS "native driver" Primary Keys


dbiAddIndex does not work if you try to add a key-violation index in MSAccess.

See
http://www.borland.com/devsupport/delphi/qanda/database.html#MSACCESS...

Quote
Tjeerd Jellema wrote:

> Both the create table and the localSQL DDL commands allow you to make
> paradox primary keys. On the other hand the MS-Access native driver does
> not create ACCESS primary keys. (either with ttable.Addindex (,[ixprimary],
> or with the DDL CREATE TABLE query), nor does the ODBC driver for that
> matter.

> What gives?

> Tjeerd Jellema
> Rotterdam

--
+--------------------------------------------------------------------+
| Juan E. Jimenez, San Juan, Puerto Rico, jjime...@caribe.net        |
| Building Bede Aircraft BD-5B Pocket Rocket, Serial #2544           |
| Visit Juan's BD-5 Home Page at http://netdial.caribe.net/~jjimenez |
+--------------------------------------------------------------------+

Other Threads