Saturday, November 22, 2014

Backup Parts Database



Excel tables can be Exported to backup an Access or MySQL databases.

Compacting only applies to Access databases.

When the Parts Frontend is closed a Daily Backup is created in the selected Backup folder if Create Daily Backups is enabled.

To avoid corruption do not Compact a Backend Database while other users have the Access database open.  

The Parts Tables can be Backed up by Exporting the Data to Excel.

Use Tools > Import to Restore or Compare the Parts Table with Backup Data.

Related Links: 

The Bloated Size Database Alert can be modified in the Config Table or User.ini File.

click on image to view











Tips: 

For corrupted or locked Access databases, close all Parts Frontend Connections and all Altium sessions that are connected to the database, then Compact the Access database.

Microsoft Access was designed for LAN.  MySQL was designed for LAN and WAN.

Using a Cloud Hosted MySQL Database is Recommended for Remote Multi-User Libraries.

Contact Parts to request technical support or a Free online demonstration.

That's It !