Hi All,
Can anyone tell me if there are any known Limitations with linked tables in
Access from SQL server 7.0. The ODBC connection fails when a couple of large
queries are run. I know I'm not giving you much but any help would be
greatly appreciated.

NAME REMOVED


**************************************************************************
The information contained in this e-mail is confidential,
may be privileged and is intended only for the use of the
recipient named above. If you are not the intended
recipient or a representative of the intended recipient,
you have received this e-mail in error and must not copy,
use or disclose the contents of this email to anybody
else. If you have received this e-mail in error, please
notify the sender immediately by return e-mail and
permanently delete the copy you received. This email has
been swept for computer viruses. However, you should
carry out your own virus checks.


Registered in Ireland, No. 205721. http://www.FINEOS.com
**************************************************************************

 
hi NAME REMOVED
    Thre are a lot of limitation on this method one of the problem your query fail is the SQL server locking your large based or
query. I have previously use this method and totally screw up the project implmentation..besided this problem the connection
tretrieve data is extreme slow ..i sugeess you to used the OLE DB instead it will solve all yyour problem or try use the MSDE

regards
tl wong



_____________________________________________________________
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus

if your running pass thru queries, i suggerst you change your ODBC timeout 
property to 0

mik


_____________________________________________________________
Get 25MB, POP3, Spam Filtering with LYCOS MAIL PLUS for $19.95/year.
http://login.mail.lycos.com/brandPage.shtml?pageId=plus&ref=lmtplus