How to suppress select unique record identifier?

[daftKev]

Hi, I'm new to the group, and I have a problem that is causing me to go prematurely grey. I have created links to an external Oracle database using ODBC, however 2 tables I've connected to have no primary key and therefore get the select unique record identifier dialogue, how can I suppress this? I only use the links for reporting and not updating therefore the uniqueness is not an issue, and the connected database is not controlled by myself.
Thanks for any assistance. Kev

 

[dhookom]

Just click cancel when prompted for the unique key. Otherwise, use pass-through queries to connect to your Oracle tables.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[daftKev]

Thanks for your reply dhookom, however I would prefer to use the table link method, is there a way to suppress the prompt? I have tried using the Sendkeys {esc} to automatically do this but cant get it to work.

 

[dhookom]

I didn't think relinking with code would prompt for the unique key. I recall some code I wrote years ago that linked to SQL Server tables and views. The views didn't have a unique key that Access knew about so if I wanted them to be editable, I ran some data def queries to identify the unique fields after linking.

I don't recall users getting any prompts when setting the connection strings of the SQL tables.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]

 

[daftKev]

I guess that would be the easiest method, I'll give it a go with an additional def query.dhookom thanks for your help

 

[daftKev]

To close this thread to overcome the message I actually used the Send Keys method as per the following:-

'Connect to the MOUT_PO_INTERFACE table
SendKeys ("{ESC}")
strTableName = "LocalMOUT_PO_INTERFACE"
DoCmd.TransferDatabase acLink, "ODBC", _
"ODBC;DSN=MAXIMO;", acTable, "MAXIMO.MOUT_PO_INTERFACE", _
strTableName

I guess its basic, but it drove an Access newbie like me crazy...