Linking Access 2003 to Oracle VBA loosing Primary keys

I have a series of about 10 test databases with about 34 linked table each. I need to create an Access 2003 database front end for each of these.

I am currently trying to write a script that will allow me to link Access 2003 tables to Oracle tables. The problem is that the Oracle table that I am linking to does not have primary keys. This is a problem because when I write the VBA to link the tables, the linkes tables do not end up with primary keys.

I am trying to write the code to allow me to create the keys with VBA. This is not working. Also, if I try copy a database and use the linked table manager the keys get dropped as well.

Any ideas (with the exception of createing PKs in the Oracel databases?) I want to do this with VBA, I can get it to work fine through the standard UI.

re: Linking Access 2003 to Oracle VBA loosing Primary keys

Hmm, nasty problem. I've never tried to add primary keys to linked tables as the key(s) will be guarded by the original database engine.
Personally I use the File/Get external data/Link tables menu to select all tables from an Oracle database and just keep [Enter] pressed to pass the key definition popup.

You could however try to issue a DDL query with "CREATE INDEX" on such a table to get an additional index, but not sure what the effect will be...

Nic;o)