Link from SQL server

M

Mike

I am linking to a table on an SQL server that I have no control over. I am
trying to automate my database. I can link to the table with this code:
DoCmd.TransferDatabase acLink, "ODBC Database", "ODBC;DRIVER=SQL
Server;SERVER=rssms2-7333-861;APP=Microsoft Access
Components;DATABASE=dbMARS;Trusted_Connection=Yes", acTable,
"dbo.ext_pln_007_02_ddg_data", "dbo_ext_pln_007_02_ddg_data", True
Every time I do this the next box that pops ud is the "Select Unique Record
Identifier". Does anyone know of a way to programmaticly select any or none
of the records so as the automation will not hang when it reaches this point?
 
J

Jinjer

Hi, Mike.

Do you need to edit or add to the table data? If the purpose is only to see
the data, a pass-thru query would do the job.
 

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

Code hang 2
Setting Primary Key on a Linked SQL Table 4
Select Unique Record Identifier 2
Linking Files and Select Unique Record Identifier 2
DoCmd.TransferDatabase acExport to SQL server 2005 2
Creating a table link via ODBC in another ACCESS database 1
TransferDatabase command, link DBF from DBC to Access 2003 0
Importing Tales and Columns 3

Top