Back to Top

Client Server

Q: How do I distribute a new update to my AeriesCS users without visiting each Aeries workstation?  

A: The update process can be setup to automatically check a public file location that the extracted files reside in. Typically, this location is on a server and all users need full control to the folder. It can be setup as a drive mapping or a UNC, or a share. On each instance of Aeries workstation, you can go to View All forms and select the form "Aeries Variables For Current User". The form contains location that the update location is placed (Updates Path). Once an update that is newer than what is on the workstation is in the location, the update process is started automatically, copying down the necessary files to the local workstation. This works for both the Aeries School Access interface (SCH) as well as the District Access Interface (DST). One thing that MUST be accomplished by the database administrator (dba) is to update the SQL databases by using the AdminCS from the update that is being distributed. This is done by accessing all Aeries databases on the SQL server with the AdminCS and the file is updated automatically upon authentication. NOTE: Because AdminCS changes the database structure (Updates the database with new fields, table/index changes, etc), AdminCS MUST be the first thing run when implementing a new version of AeriesCS!


Q: I uploaded my data from AeriesXP to AeriesCS and the supplemental data from my AeriesXP files is not there. What do I do?  

A: When uploading the data to AeriesCS from AeriesXP, if there are custom fields to upload, the process for redefining the SUP table in the CS database needs to be done by clicking on the "ReDefine SUP" button and selecting a database that contains the customized layout. This step will modify the SQL database to mirror the layout of the traditional Aeries SUP table.

Q: What procedures do I need to follow to optimize my MS SQL server for use with AeriesCS?  

A: You should perform these modifications on your MS SQL server to maximize performance for AeriesCS. If you have implemented ABI on another server other than the SQL server, these modifications should be performed on the ABI server as well. Note: Modifications to a server and registry should only be handled by a System Administrator or Technician that is proficient with server maintenance and registry modifications.

  • Install all operating system (O/S) service packs and patches that are available from the Microsoft Updates website.
  • Make sure that your MS SQL Server has been updated with the latest service pack. There have been issues with both Standard and Enterprise versions of MS SQL Server when the latest service pack has not been applied.
  • Insert the following registry entries on the MS SQL server. The registry entries shown below have helped to make "timeout" or "dropped connection" errors stop on a MS SQL server: [HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters] "TcpTimedWaitDelay"=dword:0000000f "MaxUserPort"=dword:00009c40
  • Update the MDAC to version 2.8 from the Microsoft Downloads website.
  • Restart all servers (SQL and ABI) after the modifications have been completed.

Q: My users want to be able to practice procedures on a test SQL database. How would I set one up for AeriesCS?   

A: The usage of a test SQL database is recommended by Eagle Software and pretty common with AeriesCS users. The setup of a test database is a little different than with the traditional MS Access Aeries. The process involves backing up the live database with Enterprise Manager and then restoring the backed up data to a new database with a different suffix name. The most common suffix used is to give the same suffix as the live database with the addition of the word "Test" at the end (e.g. DST13000DistrictNameTest for the 2013-2014 school year).

When a user wishes to use the test database, on the login screen, the new suffix of "DistrictNameTest" would be inserted in lieu of the live "DistrictName" suffix. This gives the user a test area to work in. You can further enhance this feature and also help users to avoid confusion between databases by changing the district and school names in the LOC table of the test database to something that would prompt the user to visually realize that he/she is not working in the live database. This is important to do so that the user does not inadvertently work in the test database by mistake inserting or updating live data.

Q: How do I copy my feeder school information from an AeriesXP database into my AeriesCS database?  

A: Place Holder

Q: How do I create a new school in my AerieCS database.  

A: Open the AeriesCS DST interface for the desired year and suffix. Go to School Options. Click on Add to add a new school. Use a school number currently not in use. Once the basic info has been entered, press the key to save the new school. Log out of AeriesCS DST interface. Login into AeriesCS SCH interface for the desired year and suffix. Select the new school number created in earlier step. Got to Teacher Data. Click on Add to add a teacher. Type "Unassigned" in the Teacher name and any other info you feel needs to be entered on the default teacher record. Save the new record by pushing on the key. Immediately go the "Teacher Number" (ID) field by clicking on it with your mouse and change the number from "1" to "0" Hit the key The new school is ready for use.


Q: When my users of Aeries start the interface, they get an error that states "Item Not Found In This Collection". How can I solve this issue?   

A: "Item Not Found In This Collection" refers to the database being accessed by Aeries as having an object (table) that is not part of the Aeries database model structure. When Aeries loads data, it downloads the table data necessary and also the structure. When a table has been created by the district to import data or perhaps store data outside of Aeries, and the table name is less than 5 characters in length, Aeries produces the "Item Not Found in the Collection" error. The easiest method to find the offending table is to go to the database table view in the Management Studio for SQL interface and sort the tables by date in descending order. Most likely the offending table will be in the top two or three tables listed. Rename the table with a name longer than 5 characters in length (6 recommended i.e. FARxxx) or delete the table if not needed, and Aeries will ignore the table when loading data.


Q: AeriesCS is taking a long time to start up each time my users login. What can I check to see if there are problems?  

A: There are four (4) common possibilities. 

  1. Not knowing what version of Access you are using, the problem suggests an unpatched MS Access 2007/2010.  If that is the case, there is a fix for the flashing screen / slow painting of forms listed in the "Microsoft Access and Aeries" section of this page.
  2. If you had a previous version of Aeries on the workstations, you may have residual data paths in the old eagle1.ini.  Verify that the Eagle1.ini is NOT in the c:\windows folder.  Delete all instances of eagle1.ini and allow Aeries to create a new one in the default Aeries folder (usually c:\eagle).  Additionally, delete all extra copies of Aeries.mde that are not in the default Aeries folder as well.
  3. You have an incorrect path specified for the update, photo, or PAC path.  Aeries will try to connect to the invalid path before giving up.
  4. You have orphan records in the system that are not taken care of by the AdminCS functions OR you have not run the AdminCS cleanup functions in a while (Force Delete Cascade Records and Database cleanup).  You should be running those two functions a minimum of once every two weeks.

If none of these rectify the issue, please contact Eagle Support for additional help.