eRAMP - Improve Access database performance and correct errors

Improve Access database performance and correct errors

eRAMP Standard has a built-in utility for users with an Access database to compact and repair your database. Database files can grow quickly as you use them, sometimes impeding performance. They can also occasionally become corrupt or damaged. You can use the Compact menu option to improve database performance and to fix potential and current problems. The compact process does not compress your data — it makes your database file smaller by eliminating unused space. The Compact command can also help improve performance of your database.

Inside of eRAMP there is a menu option to compact your database. With all eRAMP users out of eRAMP try selecting the Compact Database option.



Follow the directions that pop up and make sure you have all your eRAMP screens like 102 Registration or 207 Transfer of Rights closed.



 When you are ready to start the compact database program click Yes.



 After eRAMP compacts your database a message will display confirming the database has been compacted. Be sure the path to the database is the correct location of your eRAMP database. If it is the correct path open eRAMP and try repeating some of the steps you were taking when things seemed to be running slow. If it is not the correct path contact customer support for assistance.




    • Related Articles

    • Why SQL over Access

      Why SQL over Access: Access utilizes a File Server design while SQL Server employs a Client/Server approach. This is a fundamentally different architecture which has many, many implications. When we refer to Access in this discussion we are really ...

    • eRAMP SQL Error [DBNETLIB][ConnectionOpen(Connect(),]SQL Server does not exist or access is denied

      Problem: eRAMP v10 was installed and when the program is opened for the first time an error message displays:       "[DBNETLIB][ConnectionOpen(Connect(),]SQL Server does not exist or access is denied." Cause: With eRAMP version 10 a new folder called ...

    • File Access Denied or File Transmission is Failed

      Problem: Error message “File Access Denied” displays after clicking Send button from any eRAMP screen. Error message “File Transmission is Failed” when clicking OK from Confirmation>Retrieve Report dialogue box. Cause: User does not have full rights ...

    • Correct Batch Status or Correct status of MIN

      Problem 1: a MIN is in eRAMP as rejected but MERS shows the MIN as accepted. I want to change the status and make the MIN move to the Transfer of Rights screen. Problem 2: a MIN is in eRAMP as rejected but MERS shows the MIN as accepted. I want to ...

    • How to script a SQL Database

      To open the Generate and Publish Scripts Wizard In Object Explorer, expand Databases, right-click a database, point to Tasks, and then click Generate Scripts. ... On the Choose Objects page, select the objects to be included in the script. ... On the ...