Unable to edit data in Table from MSAccess .mdb

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER
Post Reply
skc
Posts: 10
Joined: Wed Apr 27, 2011 11:24 am

Unable to edit data in Table from MSAccess .mdb

Post by skc »

I opened my MSAccess (2003) Database by going to Open-All Files & then opened the .mdb
The Table with all the data appears in the table view but I am unable to edit or add to any of the data. Right click only gives a copy command . It as if it is Read Only.
Is there any way around this? :(
I am really keen to go over to Base and remove the last remaing M$ software.
Thanks in advance.
User avatar
r4zoli
Volunteer
Posts: 2882
Joined: Mon Nov 19, 2007 8:23 pm
Location: Budapest, Hungary

Re: Unable to edit data in Table from MSAccess .mdb

Post by r4zoli »

AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
arnotsmith
Posts: 1
Joined: Tue Jan 03, 2012 6:08 am

Re: Unable to edit data in Table from MSAccess .mdb

Post by arnotsmith »

Note that OO Base requires that a table has a Primary Key defined before it can de edited. MS Access does not require this.
OpenOffice 3.3
Ubuntu 10.4
skc
Posts: 10
Joined: Wed Apr 27, 2011 11:24 am

Re: Unable to edit data in Table from MSAccess .mdb

Post by skc »

Thanks guys,
Does this mean I must try and designate one of the fields as primary key in the imported mdb and if so how do I do this?
Thanks in advance.
Open Office 3.2.0 on Windows 7 64bit
Post Reply