TransferDatabase

[vr]

I use the following to link Access97 to an Oracle database via ODBC:

DoCmd.TransferDatabase acLink, "ODBC", "ODBC;DSN=XXXX;UID=XXXX;PWD=XXXX;LANGUAGE=us_english; & DATABASE = C:\PROGRAM FILES\XXXX\XXXX.mdb", acTable, "MYTBLE", "LinkTest"

A dialog box opens and requests the user to select the Unique Identifier.

Does anyone know a way to include the Unique Identifier in the DoCmd statement so the users will not have to select it?

Please advise.

Thanks!

 

[ssecca]

If you put a primary index on the Oracle database table the problem will go away. I'm a firm beleiver that all tables should have a unique primary index. I am always amazed when they don't.

Good Luck
ssecca

 

[vr]

The primary index is on the Oracle table, but the ODBC connection still brings up the dialog to select it.