In Access 2K, I am creating tables in code. The tables reside in the 'back end' database. I have no trouble creating or attaching the tables. I am having trouble creating the primary indexes. The error I get is "Can't create index in linked tables."
I am creating the fields using the .createFields construct. Two questions: How do I specify an autonumber type (there is no dbAutoNumber constant), and how do I create a two field primary key in a remote db?