Errors when loading Pantrysoft
The vast majority of our support calls fall into two categories; Windows networking errors, and Microsoft Access Connection Errors.
A little background:
Pantrysoft desktop is built with the Microsoft Access database system. To facilitate multi-user access, the program is split into a front end with the various program code, and a back end with the data tables. These files are named as follows:
Pantrysoft.accde (Front End)
Pantrysoft Tables.accdb (Back End)
Each desktop that is running pantrysoft loads the pantrysoft.accde program file. The first thing it does is look for a file in the same directory called pantrysoft.cfg. This is a text file that tells Pantrysoft where to find the back end data file. It will have a line something like this:
This tells the program it can find the tables in the Z drive.
Windows Networking Problems:
In the example above, if the program starts and it can’t find the Z drive, pantrysoft will give an error indicating that it can not locate the tables. This can happen for a number of reasons:
- The computer that is sharing the Z drive is turned off
- The computer sharing the Z drive is not connecting to the network
- The computer in question is not connecting to the network
- For some reason windows has forgotten that you set up a Z drive. Usually you just need to open the file browser and navigate to the Z drive and then magically everything works again.
- What to do if you get the error that Pantrysoft can not find the tables:
- Open your file browser and make sure you can navigate to the address pantrysoft says it is looking for. If you can’t get there in Windows Explorer, neither can pantrysoft.
- If you are having an equipment or networking error, call your network person. If everything is accessible and it still does not work, call us for help.
- What to do if Pantrysoft tells you the database is corrupted or unrecognizable:
- This error is not as scary as it sounds.
- MS Access has a process for managing the locking of the database to prevent two users from editing the same thing at the same time. If for some reason a user disconnects from the database, while the program is open, Access can get confused. The next time you try to connect, you see this error.
- Navigate in the windows file manager to the location of the Pantrysoft Tables file. Double click on the tables file. It will try to open in MS Access. It will tell you that it is broken and will try to fix itself. Once it finishes opening, close it and try running Pantrysoft again.
- This almost always works. If not, give us a call.
- This problem can be prevented by making sure everyone closes pantrysoft before turning off their computer, putting it to sleep, logging out, or otherwise disconnecting from the network.