Make sure that the file you are selecting is a. And then click on the select option to make a selection of the Access database you wish to access using Open Office. In the appearing dialogue box enter the name of the Data Source, along with a description.This would lead to ODBC Microsoft Setup screen for Access showing up. From this dialogue box go on to choose ‘Microsoft Access Driver’ and then click on the Finish button.This will display the dialogue box for ‘Create New Data Source’. From the appearing Data Source Admin Window, click on the Add option.This will begin operation in the Data Source Admin.

In MS Windows click on Start, go to Settings and in the Control Panel and then double click on the icon of ODBC Data Source.

Creating ODBC data source for using Access databases in Open Officeįollow these steps for creating ODBC data source in Open Office Once this is done, you then need to proceed towards developing an ODBC data source for your Access databases. This step also needs to be done just once.

Opt for creating an ODBC data source inside for all databases.

Opt for creating an ODBC data source for all databases that you wish to make use of.

Using ODBC to link MS Access and Open Officeīefore you can opt for creating an ODBC data source for using MS Access database on Open Office, you first need to link these two applications. MS Access provides you support for ODBC, meaning to use an Access database with Open Office, you will have to create an ODBC data source.

Open Office allows users to access multiple types of databases, provided they have support for standard interface specifications like the ODBC or the JDBC. The answer to this question is very simple. Imagine a situation where an user operating on Linux machine, using Open Office needs to Access MS Access files. In such a situation, not everyone will be operating on Windows and using only MS applications. There can be situations when people working in a single organization are making use of different operating software. In this article, we look at how we can use an Access database in MS Office and the steps involved in it like creating an ODBC data source.

Openoffice base vs ms access