When a second user opens an AYS Microsoft Access database that is already open by another user, they get a “File already in use” error message. This problem can be resolved by the following steps:
When starting AYS software I see a message similar to the following:
Why does this happen, and what should I do?
If you are using Microsoft Access AYS database files, multiple users at your location can open and work with the same database across your network. You will need a multiple seat license to open the database with multiple users concurrently. Please contact us if you would like to upgrade to obtain this ability.
Microsoft Access databases have a tendency to bloat in size with use over time and should therefore be periodically compacted to maintain the best possible performance. The compacting process may also repair minor database corruption and related issues.
The physical Microsoft Access AYS database file is protected with a Jet Database password. In order to access the database from a third-party tool (e.g. Microsoft Access, Crystal Reports, etc.) you will be prompted for the user name and password. The user name and password are available as part of the AYS data dictionary which documents all of the tables, fields, and queries within the database and their relationships.
When running AYS, a message similar to the following randomly appears:
Error: -2147467259 – Disk or network error.
Microsoft Access databases have a tendency to bloat in size over time and should therefore be periodically compacted to maintain the best possible performance. In order to compact the database, all users must be logged out of the database, including the AYS Internet Utility.
A Microsoft Access database may be hosted on an Apple desktop computer running a Mac OS X operating system if it is configured with Server Message Block (SMB) file sharing.
For instructions on configuring and troubleshooting SMB file sharing on Mac OS X, please see the Apple Support article: How to connect with File Sharing using SMB.
When running AYS, a message similar to the following randomly appears:
Error: -2147217865 – The Microsoft Jet database engine cannot find the input table or query ‘xxx‘. Make sure it exists and that its name is spelled correctly.
When manually importing data from any import module into a Microsoft Access database, the following message appears:
There are too many records to support rollback protection.
Please disable rollback protection and try importing again.
When manually importing records into an AYS database, clicking the Test button imports all of the data but keeps track of all changes made so that those changes can be undone or rolled back at the end of the test. Warnings or errors that are logged during this test may be used to clean up the data set being imported before any live data in the target database is affected. Clicking the Import button still keeps track of all changes made so that if there is a critical error during the import then any changes can still be undone or rolled back.
When importing data into Microsoft Access databases, there is a limit as to how much data can be recorded in the list of changes. The above error indicates that the limit has been reached and a decision must be made to either undo the changes now, or continue without the ability to undo any changes.
Option 1: If you are satisfied that the import data set is good then within the import module select the Options tab, and check the box next to Disable Rollback Protection. Once this option is checked then the Test button will no longer be available. Click the Import button to proceed with the import.
Option 2: If you are not satisfied that the import data set is good then break the data set into smaller chunks and test importing each chunk of data individually. Once you are satisfied that the import data set is good then you may either import each chunk of data individually, or import the entire data set. Follow the steps in Option 1 above to disable rollback protection before importing.