smartmedia:
I still can't create a key field on Database Access...
Create a primary key and an AutoInc field is now working.
a) Is there such a thing as a
key field for an Access database ... i.e. a
non-primary-key field ... skimming some articles in response to Google searches shows no reference to any kind of key fields other than the
primary keyb) Have you tried to use the
dbpCreateIndex command to add an index with
PrimaryIndex=No and
Unique=No properties ?
c) Have you tried to create a MS Access Table using
dbpExecSQL command ? ... which would pass your
CREATE TABLE table ( field defs ) type content directly to the ODBC driver
@Dave:1) While reading up on MS Access Primary keys, I came across the requirement that ...
Primary keys ...
- uniquely identify each record (no duplicate values);
- are never null;
... which brings up the question ...
If a primary key is assigned to anything other than an "AutoInc" type field, how do you then do a "dbpAddRecord" command ... which according to the Help file "Adds a new empty record to a table" ... wouldn't the "never null" part clash with the "empty record/field" part ?
2) Also read about composite keys ... i.e. keys made up of combination of fields ... presumably to make the record uniquely identifiable ... am I right in thinking that in order to do this with NeoBookDBPro, you should use the "dbpCreateIndex" command ? ... if I try to attribute "Primary Key" to more than one field, I get a run time error that the "Primary Key already exists"