We are transferring from an inhouse ACCESS database into an SQL database called CAREWARE (issued by HRSA). After the transfer is done, we find that there is more data that the auto-conversion they provide will not handle. We have defined custom tables and fields. Rather than hand enter all the info, it would be much easier to query the info over. I am trying to link the ACCESS tabels in a DB called dbLFCP into the SQL2005 database so I can query directly into the SQL2005 tables. In the SQL2005 database, under SERVER OBJECTS, LINKED SERVERS, I can right-click and add a new linked server. Can anyone point out the correct entries to put in for a ODBC defined server (defined in control panel) named LEDS_ODBC, in a database called dbLFCP, on the network server LEDS01 with ID "BESTBUY" and pw = "reserved". I tried both the JET provider and SQL_ODBC providers to no avail. HELP !!!! (THANX !!)