I have a custom Access program connecting to SQL 2008, and the SQL is on a Win7.
I also had a Brother network printer HL2270DW, and the Access program was crashing here and there, with ODBC--Call failed. With investigation, I had concluded that I need to upgrade the SQL OS to a real server OS.
However, I just changed the printer above to another network printer HP LaserJet pro 400MFP M425dn, and the software in Access has increased in crashing to every 5 min.
Can the new printer have any influence on this (ie-taking up more network resources)? As well, if I did connect the Ethernet cable from the printer to test the Access software, will it be enough, or will I also need to remove the HP software and driver?
Can it also be by coincidence the router? How can I test this?