LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: rpcwong

Just wondering if anyone has experience of bringing these files into lavastorm. Am I supposed to get an odbc driver to connect to these files using DB Query? I'm a bit confused..

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

To read data from a MS Access database you will need an ODBC driver for MS Access installed and a Data Source configured in the Windows "ODBC Data Source Administrator" application.

Once you have the Data Source configured you should then be able to use the DB Query node to query the data from the Access tables. Make sure you have the DbInterface parameters in the DB Query node set to "ODBC". The DbService parameter should contain the name of the Data Source you created.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: stonysmith

One small note.. this can only be done with the Lavastorm Desktop software running on Windows. There are no drivers for Unix that read MS-Access.

Plus, even if the MDB file is stored on some shared folder, each PC that you want to use to read from the database will have to have the "Data Source" built on/for that machine specifically.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: awilliams

EasySoft produces a MDB/ACCDB ODBC driver for *nix systems:

http://www.easysoft.com/products/dat...access-driver/