Win7/Access 2003 Backend link problems
I have a very strange scenario. I recently implemented some changes on a clients network where there are 4 users. Now, on only two of the four computers, the link to the back end database is lost overnight. They shutdown their stations overnight but not the server. Each morning these two users have to relink to the back end.
They are all running the same version of software. The database changes included compressing the back end on close; un-checking "Ignore DDE requests" to try and solve a problem with the msg 'There was a problem sending...'; and moving some temporary tables to the front end. The changes to the front end included solving some of the issues raised by FMS Total Access Analyzer (option explicit etc)
Does anyone have any ideas?