471,049 Members | 1,488 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,049 software developers and data experts.

Key fields?

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.
Jul 20 '05 #1
1 2175
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.

Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Tim Cowan | last post: by
reply views Thread by bill mahoney | last post: by
reply views Thread by Proteus | last post: by
4 posts views Thread by Vigneshwar Pilli via DotNetMonster.com | last post: by
9 posts views Thread by sean.scanlon | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.