March 24, 2009 at 3:15 pm
Everything works in my access 2000 database if I have the tables linked to another access database.
But, If I take those same tables and link them directly to the sql server 2005 express, I have a multitude of problems.
I have a VB6 front end, which calls up Access. Access then runs certain queries depending on the switch provided by VB6. Some queries work. Some don't. The ones with the biggest problems seem to be nestled queries three or more deep. I.E. Query 5 uses query 3 and query 4 for input. Query 3 uses query 2 for input.
I have also seen the problem where if I simply click on a linked table (linked from access to sql server) while in access, I get ERROR ERROR ERROR in each field. If I delete the link, and re-add, everything looks fine.
I have already compiled the mdb to mde code ... and the same results. I have also increased the timeouts everywhere I could find (server properties, odbc properties, etc.).
Any ideas?
Thanks,
Michael.
April 10, 2009 at 8:28 am
Where is the Query being executed, in the access database side or in SQL Express? and do you have the tables linked via ODBC CODE using VBA or VB6 or using ODBCAD32. this will help me in giving you an answer.
😉
"We never plan to Fail, We just fail to plan":)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply