Unanswered: Error accessing file. Network connection may have been lost
Hi all out there
I am receiving the above error in my Access database. i am using Access 2007 and can find nothing on the web to give me a clue as to what is causing it. (plenty relating to 2000 and 2003)
I have had the client / server database running for over 6 months without trouble and all of a sudden 2 users (out of 4) cannot open the client and I cannot compile the VBA code (on my computer) without this stupid mesage.
I and the users can "see" the network and can open the mdb file directly.
I use the accdb file, the users use a accde file.
i have compaced it, recovered an archived version and recompiled it, all to no avail. This has been happening for around 2 weeks. I have not installed or uninstalled anything around that time nor tampered with any XP settings.
The only thing I am trying is an update for Office and at present it is downloading a service pack for the .Net framework. I did have some issues with this before (about 9 months ago).
Check the connection string(s) used to connect the front end application to the database. Also, what does happen if you copy the application file from a pc where it works to another one where it does not?