Hi there!!
Havin a right mare of a problem with a linked table (generated through vba code in Access).
When I run this code it opens a form with data retrieved from a view in sql server. There is a button on this form that when clicked is used a search form and uses the same view (which is using the linked table generated earlier). However when this search form is run I get the following error
"[Microsoft][TCP/IP Sockets] ConnectionRead(rec()). [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] General network error. Check your network documentation. | ODBC --call failed. |"
If before I open the search form, I go to the tables and manually open the linked table, then go and run the search form, it runs fine.
Also, if i use another database (UAT) database which has all the same views tables etc the forms run fine.
Could this be an issue with resetting/ reinstalling the ODBC sql driver. This is also happening to other users.
Can anyone help????
Havin a right mare of a problem with a linked table (generated through vba code in Access).
When I run this code it opens a form with data retrieved from a view in sql server. There is a button on this form that when clicked is used a search form and uses the same view (which is using the linked table generated earlier). However when this search form is run I get the following error
"[Microsoft][TCP/IP Sockets] ConnectionRead(rec()). [Microsoft][ODBC SQL Server Driver][TCP/IP Sockets] General network error. Check your network documentation. | ODBC --call failed. |"
If before I open the search form, I go to the tables and manually open the linked table, then go and run the search form, it runs fine.
Also, if i use another database (UAT) database which has all the same views tables etc the forms run fine.
Could this be an issue with resetting/ reinstalling the ODBC sql driver. This is also happening to other users.
Can anyone help????
