Depending on your OLEDB privider, try using the Four Part Naming Convention. 

LinkedServer.RDBSName.LibraryName.FileName

Example:

INSERT INTO LinkedServer.RDBSName.LibraryName.FileName

SELECT Column1, Column2, Column2, etc.

FROM SQLTable

You may want to use the CreateTableDef Method.  There is a good example in ACCESS Help. 

The answer:  "Go to the Results tab under Tools and Options and set the Maximum Characters Per Column"  is correct for MSSQL 7.0.  If the question refers to a...

Check the following:

http://support.microsoft.com/default.aspx?scid=kb;en-us;309103

http://support.microsoft.com/default.aspx?scid=kb;en-us;310422

MMC V2.0 tends to loose SQL Server registrations when a network password is changed.

The SQL 7.0 msc is a V1 type so I have created a...

I use different DSN names for Dev, Tst, and Prod.  For example: myDSN_Dev, myDSN_Tst, and myDSN_Prod.  When an ACCESS.mdb is moved from one environment to the next, we have VBA...

Try using the InStr function. 

Try using the CDate («date»)  function.

 rst.Open "SELECT * FROM tblDeposits WHERE " _

                & "CDate (uDate) BETWEEN '" & StartDate & "' AND '" & EndDate & "' " _

               ...