Saturday, July 18, 2015

When and How to Upsize Microsoft Access Databases to SQL Server

This article by FMS discusses Microsoft Access and SQL databases.

When and How to Upsize Microsoft Access Databases to SQL Server:


As pointed out in the article 85% of all Access databases do not need to be up sized.

Most companies only have a few seats (licenses) for their CAD tools, so the number of concurrent users is limited.

An Access database is an excellent choice for small groups with 20 or fewer users.  

Access can be used with Altium's DBLIB or SVNDBLIB to create a database solution for CAD libraries.


Database libraries have several benefits compared to primitive *.SCHLIB and *.PCBLIB libraries. New parts can be rapidly added to the database and existing parts are easy to maintain.


Using the link below you can download a turnkey Access / Altium DBLIB CAD library. 


The download includes a optional Access Frontend application.

A Frontend application is not required to use a DBLib database. Parametric data, symbols and footprints can be added, deleted or edited using Altium's DBLIB interface. 


However, a well designed Frontend application like the one found in Parts can greatly simplify maintaining your database library.

Link to Parts: Altium DBLib library created using Microsoft Access

No comments:

Post a Comment