Using File Databases in Applications

Label templates and Solutions in your shared Applications are often connected to a database. Your connected database works as a dynamic data source for objects on your label templates.

You can choose where to store your database. To ensure your file database (Microsoft Access or Excel) is accessible from your shared Application, choose one of the following options to store your database:

  • Store your database in Control Center > Documents. We recommend storing your label files in the same folder as your database.

    Loftware automatically simplifies your database URL in the database connection window:

    CC20193_Designer_CC_database_connect.png

  • Store your database locally on the computer that runs your Application Loftware Web client (Web Printing) can use your local database.

    [Note] Note

    In case your ​Control Center​ can't connect your database (either file database or SQL), you can access your database directly with Web Client​​. In this case, start your local database names with the "​LOCAL_​​" prefix.
    CC20193_Local_database_prefix.png
[Important] Important

You can also store your file database in Loftware Cloud, but you can use your database in read-only mode. You can update your file database locally and then re-upload it to Loftware Cloud.

If you use actions to update your file database in your web applications, use your local or network-shared copy of the Access database.

When you store your database, connect your label templates or Solutions to your database. Go to LoftwareDesigner > Dynamic Data Manager > Database Connections to browse and connect to your database.