Key fields?

J

Jason Gyetko

I have a few MySQL tables that do not have key fields associated with them.
I am linking to this MySQL database from Microsoft Access 2000 using the
DoCmd.TransferDatabase acLink method. When the link is created, I get
prompted with a "Select Unique Record Identifier". Here are my questions:

1. Is there a way to make this message not appear (or programatically
repsond to it) other than by adding a key field to the table?

2. If I select no Unique Record Identifier, the table becomes Read Only.
Is there a way to make this table link updatable without assigning a key
field to it?

I'm trying to get past this without make any structural modifications to the
MySQL database. Any suggestions would be greatly appreciated. Thank you.
 
D

Douglas J. Steele

The answer to both questeions is No.

Note, though, that if you indicate a unique record identifier in step 1,
you're not changing your MySQL database: you're strictly giving Access
additional information.
 
Top