Warning - File Locking

Problem: Altium Warning - You will not be able to save your changes









Fix: Disable the File Locking Option in DXP Preferences

Tools > DXP > Preferences File Locking

click on image to view



That's It !

EOleException error executing

Provider cannot be found . . .

EOleException error raised in Altium DBLIB or SVNDBLIB when connecting to an Access Database.

Provider cannot be found. It may not be properly installed.





For AD17 and older 32bit versions of Altium DXP.

To fix this connection error install a 32 bit AccessDatabaseEngine.exe

Download 2010 AccessDatabaseEngine.exe
or
Download 2016 Access DatabaseEngine.exe

Read:

The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine - ConnectionStrings.com

That's It !

User Defined Fields

The Parts Frontend supports up to 15 user defined text fields. 

YouTube Video User Defined Fields

Close all connections to the Database (Parts Backend) !

A database should not be re-designed while users are connected to the database.

If users are connected to Parts Database ask them to close their Parts Frontend applications and Altium connections while you modify the Parts Database.

To add a user defined field Select Configuration > User Defined Fields, enter the user defined fields and select Apply in the Configuration form.

Note for For MySQL databases User Defined Fields can be added using the Parts Frontend if the user named in the connection string has been given privileges and permissions to alter the MySQL database. 

If the named user does NOT have permissions and privileges an ADO Error Handler message will pop up if the user attempts to alter (add fields) to the database.

Example. . .  to add a field Named Package_Size to the Parts database.




Close the form and select the Apply button in the Configuration dialog to create the fields.

Unbound fields are fields that are not linked to the main form.

To remove unbound fields use Tools > Configuration > Unbound Fields. Or edit the Parts Backend database.

Notes:
Parts configurations can be saved and loaded on local or shared drives.

See Configuration > User Defined Fields > Part Status . . .

 Parts Status choices may be defined in the Configuration options.

New;Released;Production;Deprecated;End of Life;Obsolete;

Related Link: 

Guidelines for naming fields, controls, and objects - Microsoft

That's it !