Access Linked Table: Select Unique Record Identifier

[dmassey]

Hi

I am creating a linked table to an odbc datasource in access vba. When I create the link, access shows a windows with the title "Select Unique Record Identifier" and it gives a list of all the fields in the table to select from with OK and Cancel. All I need to do is click cancel and the table will link properly.
How can I keep this message from coming up using Code?

The code to link the database table is as follows:

DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DSN=AS400 AMFLIB;", acTable, "SLDATAL0", "AMFLIB_SLDATAL0", False


Thanks, Derek

 

[PHV]

Have you tried this ?
DoCmd.SetWarnings False

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[BNPMike]

Remember to SetWarnings back to True.

 

[dmassey]

I was already doing that.(docmd.setwarnings false)

It's more than just a warning because it asks for information.

Derek

 

[Crowley16]

what information is it asking?

you can probably specify that in the code, then the msgbox won't come up...