Unable to edit data in Table from MSAccess .mdb

dBase, Calc, CSV, MS ACCESS, MySQL, PostgrSQL, OTHER

Unable to edit data in Table from MSAccess .mdb

Postby skc » Wed Nov 16, 2011 3:29 pm

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.
skc
 
Posts: 6
Joined: Wed Apr 27, 2011 11:24 am

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

Postby r4zoli » Wed Nov 16, 2011 3:55 pm

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

Postby arnotsmith » Tue Jan 03, 2012 6:19 am

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
arnotsmith
 
Posts: 1
Joined: Tue Jan 03, 2012 6:08 am

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

Postby skc » Tue Jan 03, 2012 7:49 am

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
skc
 
Posts: 6
Joined: Wed Apr 27, 2011 11:24 am


Return to External Data Sources

Who is online

Users browsing this forum: No registered users and 4 guests