General discussion
Thread display: Collapse - |
All Comments
Start or search
Create a new discussion
If you're asking for technical help, please be sure to include all your system info, including operating system, model number, and any other specifics related to the problem. Also please exercise your best judgment when posting in the forums--revealing personal information such as your e-mail address, telephone number, and address is not recommended.
ACCESS shortcut in XP peer-to-peer ntwrk
My questions are several:
When the last user closes the database, it is set to autmatically repair and compact. Unfortunately, compacting seems to do something to the file structure of the DB file so that the "client" workstation shortcuts can no longer find the file. We have turned off auto compacting as a workaround but the database is now starting to grow. The only other solution I have found is to copy the database on the master machine to another location on the C: drive and either re-point the client shortcuts or copy it back to its original location for the shortcuts to work again. Is this a browser problem with XP? Any thoughts?
Since Access is a flat database and all ofit is pulled through the wire on opening, things are slowing down more and more as we add features. We tried splitting the DB into a front end and a back end via one of the Access Utilities and it works fine on the master but when we connect via shortcuts pointed at the front end file from the clients, we get the error that the program cannot find the backend file on the master. Any suggestions?