Help with TransferDatabase, asking for KEY

[nashman]

Hi,

I am using the TransferDatabase command to reconnect to an ODBC database ( Sybase ) from Access. I have no problem at all with the code to connect however, I want to perform the database update through my scheduler on WINXP. Each time I reconnect to the database, I get asked to "Select Unique Record Identifyer". I usually select cancel and the table links properly. But doing this using SendKeys has worked only if the screensaver is disabled obviously since Access must be the active APP. However, this is done at work and the screensaver cannot be disabled. Since Access is no longer the active APP, the SendKeys wont work. Here is my connection string...

DoCmd.TransferDatabase acLink, "ODBC Database",_ "ODBC;DSN=DSN_Name;SRVR=Server_Name;UID=UserID;PWD=Password;DATABASE=dB_Name", acTable,_ Table_Name,Table_Name_Once_Connected

Am I missing something in the connection string or can I use another command instead of TransferDatabase that will not ask me to "Select Unique Record Identifyer"?

Any help is greatly appreciated...