Have any questions? Email: info@flynet.email. US: +1 617-778-7259. UK: +44 (0)3333-110-370. ES/PT: +351-300-500-441.

Microsoft Access

Warning for Working with Microsoft Access in a Server Environment

While Microsoft Access does support multiple users, we do not recommend using Access in a production environment where it is avoidable. It will not scale up with many users accessing via a web service.

There are some important set-up details for using Access databases with DataConnect. You must make sure you follow these steps or you will have problems.

Configuring a Microsoft Access Connection in DataConnect

Flynet DataConnect can connect to both Microsoft Access file formats, mdb and accdb. If you have Microsoft Access installed on your desktop, you will have the necessary drivers installed to access Access databases.

For more information about Access data drivers, see our Access guide. DataConnect can connect to Access using ODBC or OLEDB (dependent on having the drivers installed).

Create a New Connection

Flynet DataConnect offers the Full Experience for Microsoft Access. This means you can create queries using a tile-based drag and drop interface.

To create a connection to a Microsoft Access database, make sure you are on the Connections tab. Then press the (+) icon at the very left hand side of the window.

Give your Connection a Name and Type

You then need to give your connection a name, and optionally a description.

You now have the option to use OLEDB or ODBC for your Connection Type. If you are unsure which to use, make sure you read our Access guide.

Select the Driver Type and Locate the File on Your Computer

Select the connection technology and the file type you wish to use:

Access Connections

Select the Connection type ODBC and the Odbc Driver Type 'Microsoft Access connection'.

Press the [...] button next to Dbq and locate the Access database you wish to access.

Testing and Saving

Once you have entered your values, you need to press the Test Connection button. This will indicate whether or not DataConnect can connect to your Access database. Common problems are incorrect file name, inaccessable location and incorrect password.

Once you have a succesfully tested your connection, you must press the Save button to store your connection.

Select the Connection type ODBC and the Odbc Driver Type 'Microsoft Access 2010 connection'.

Press the [...] button next to Dbq and locate the Access database you wish to access.

Testing and Saving

Once you have entered your values, you need to press the Test Connection button. This will indicate whether or not DataConnect can connect to your Access database. Common problems are incorrect file name, inaccessable location and incorrect password.

Once you have a succesfully tested your connection, you must press the Save button to store your connection.

Select the Connection Type OLEDB and the OleDb Driver Type 'Microsoft Access Standard Security'.

Press the [...] button next to Data Source and locate the Access database you wish to access.

Testing and Saving

Once you have entered your values, you need to press the Test Connection button. This will indicate whether or not DataConnect can connect to your Access database. Common problems are incorrect file name, inaccessable location and incorrect password.

Once you have a succesfully tested your connection, you must press the Save button to store your connection.

Select the Connection Type OLEDB and the Oledb Driver Type 'Microsoft Access 2007\2010 Standard Security'.

Press the [...] button next to Data Source and locate the Access database you wish to access.

Testing and Saving

Once you have entered your values, you need to press the Test Connection button. This will indicate whether or not DataConnect can connect to your Access database. Common problems are incorrect file name, inaccessable location and incorrect password.

Once you have a succesfully tested your connection, you must press the Save button to store your connection.