Key fields?

  • Thread starter Thread starter Jason Gyetko
  • Start date Start date
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.
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Access for MySQL data reports only 5
primary key - concatenated or autonumber? 6
Setting the primary key when using DoCmd.TransferDatabase acLink 3
Linking Files and Select Unique Record Identifier 2
Setting Primary Key on a Linked SQL Table 4
'ss' and 'ß' 14
Select Unique Record Identifier 2

Back
Top