Hi all,
I have a strange problem I hope you might help me with. The situation is that I have developed a database application for a client. They run it on a Server 2003 machine via remote desktop. It is multi user so there is one back-end database with tables in it and multiple copies of the front end with forms etc.
So... I recently made a couple of small changes, and when it was deployed reports came back that using some features caused the user to be dumped out of Access and the app. terminated, with no error message. One example is using the search function - it is just the built-in Access function but I put a button for it on the form for ease of use. This was working fine, and I hadn't changed it, but in the new version clicking the button caused the user to be dumped out of Access.
On investigation, I could cure the problem by opening the form in design mode, going to change something but not actually doing so, then saving the form. It now worked.
However... if I copy the database file to a user's folder it then does not work!
Finally, if I download a non-working copy of the database file back to my own PC it then does work!!
Any ideas? I admit to being a little baffled so any help greatly appreciated.
If it's relevant, the clients server is seriously overloaded and very slow. (They are on with sorting out an upgrade but haven't done it yet - bureaucracy!)
I have a strange problem I hope you might help me with. The situation is that I have developed a database application for a client. They run it on a Server 2003 machine via remote desktop. It is multi user so there is one back-end database with tables in it and multiple copies of the front end with forms etc.
So... I recently made a couple of small changes, and when it was deployed reports came back that using some features caused the user to be dumped out of Access and the app. terminated, with no error message. One example is using the search function - it is just the built-in Access function but I put a button for it on the form for ease of use. This was working fine, and I hadn't changed it, but in the new version clicking the button caused the user to be dumped out of Access.
On investigation, I could cure the problem by opening the form in design mode, going to change something but not actually doing so, then saving the form. It now worked.
However... if I copy the database file to a user's folder it then does not work!
Finally, if I download a non-working copy of the database file back to my own PC it then does work!!
Any ideas? I admit to being a little baffled so any help greatly appreciated.
If it's relevant, the clients server is seriously overloaded and very slow. (They are on with sorting out an upgrade but haven't done it yet - bureaucracy!)