We have a fairly large access data base and are planing to move it over to a new terminal server machine. The data base has a front end and a seperate back end.
As always we had to make sure we have all the referances, which we do.
We are coping the front end to the new C drive and the back end to a new F drive. When the front end opens it will crash on a line code that is checking for any possible appointments for the particular user. If I remove the code then it will run as expected.
This is a 2003 access database and we are moving from a 2003 server to a 2008 R2 server.
What I don't understand is why this will run without any problems on the 2003 server and
fail on the 2008 server. Is there something different with the referances etc. etc.