Remote Access

The Part Frontend application supports connections to Microsoft Access and MySQL.

Suggested reading: MS Access on a WAN? - Albert D. Kallal

MySQL is designed to work on a Wide Area Network (WAN).

Microsoft Access was designed to be used on a Local Area Network (LAN).
Microsoft Access should not be used across a Wide Area Network (WAN).

Remote MySQL

You can put a MySQL database on a remote server and connect the Parts Frontend to the remote database.

Related Link: See How to Create a Shared MySQL Database

Video Remote MySQL Database for Altium

Migrate to MySQL if you need to work remotely.

That's it.

Parts - Supplier Data

The Parts database was optimized for performance and speed. However if you can tolerate the reduced performance and have a fast internet connection you may want enable the supplier data options in Altium. See Bug Crunch #388: BOM Generation Takes Eternity

Note that using Supplier Solutions in the Bill of Materials and displaying Supplier Data in the Libraries Panel degrades performance as Altium searches the web for supplier data.

To view Supplier Details open the Part Backend and rename these two fields:

Supplier to Supplier 1 
Supplier Part Number to Supplier Part Number 1

See the Video:  YouTube (8 min)

Screen shot for database library with Supplier 1 and Supplier Part Number 1 fields.

click on images to view

Note, you may need to enable Parts Providers in DXP Preferences > Data Management.

That's it !

Parts - Temperature Coeff or Dielectric ?

Regarding: Temperature Coefficient and Dielectric

Take a P/N like GRM033R60J223KE01D

Go to Mouser and Digi-Key and look for Temperature Coeff and Dielectric 

Next, let's look at Murata's datasheet.

This is a case were either Mouser or Digi-key is wrong, so a choice has to be made.

So who is wrong, Digi-Key or Mouser ?  I think Mouser got it right. 

However I have also seen Temp Coefficients, like NPO, COG. 

Parts adopted the terminology found in Murata's datasheets.

That's it !

How to Create a Shared MySQL Database

You can deploy an Access or MySQL database on your company network behind a firewall and use the Parts Frontend to simplify your library maintenance.

Or you can use a an internet hosted solution, like Amazon RDS.

Parts is a scalable turnkey database library. You can start by using Microsoft Access for your backend database and migrate to MySQL if you need an enterprise solution.

You can install and setup MySQL on your own server or use an online hosting service, like A2 Hosting. or Amazon.

Related Links:

The Parts download includes scripts to create schemas and tables for MySQL.

How to make MySQL table name case insensitive in Ubuntu? - Stack Exchange

That's it !