Editing Data Imported From MS Access 2007

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
Joker99
Posts: 1
Joined: Fri Jun 10, 2011 9:17 pm

Editing Data Imported From MS Access 2007

Post by Joker99 »

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.
OpenOffice 3.3 Windows 7
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Editing Data Imported From MS Access 2007

Post by r4zoli »

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.
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Post Reply