Key fields?

[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.

[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.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(No private e-mails, please)
"Jason Gyetko" <jg*****@epower-inc.com> wrote in message
news:e%******************@newssvr15.news.prodigy.c om...

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.