We are running ACT 2010; MS ACCESS 2007 on Win 7 PC's. ACCESS has been programed using ACCESS and Visual Basic to link to data from ACT. ACT is resident database; ACCESS is the reporting tool for Data.
ACT/ACCESS marriage worked perfectly on a Win 2003 server environment. We recently upgraded PDC to Win 2008. All converted perfectly but ACT/ACCESS. Took some time to get SQL happy. ACT is now working OK (although much slower than previously). ACCESS is issue. We cannot get ACCESS to stay connected to the ODBC. Connection is inconsistent from user to user / desktop to desktop. Error msg: cannot connect to ODBC. Sometimes you get error - other times you don't. If you click OK (once or numerous time) you may evenutally connect. Sometimes you can connect to the application ok, but when you navigate to a different section of the application, the connection fails.
IT have given up and say it is NOT server related. The ACCESS programmer cannot find anyting correct or wrong with the coding.
All are frustrated and at a loss. Help