Apache OpenOffice Community Forum

Hi all,

I am having trouble editing the data imported from my MS Access database. The database was loaded via "Connect to an existing database: MS Access 2007." The database has the following tables: Customers, Customers Extended, Employees, Employees Extended, Filters, Forecast Chart Source, Opportunities, Opportunities Extended, and Open Opportunities Extended. No queries, forms or reports. Each of the tables that are not extended have a primary key. I only have column names imported from Access in the tables, such as Customer ID, Last Name, First Name, etc. It will not let me put any data under the column headers when I open any table.

Thanks for any help.

Acess 2007 driver has limited feature set in OOo, use instead ODBC or ADO connection.

More in [Tutorial] MS Access and OOo Base, and related links.