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.
Unable to edit data in Table from MSAccess .mdb
Re: Unable to edit data in Table from MSAccess .mdb
See these tutorials, and linked pages:
[Tutorial] MS Access and OOo Base
[Tutorial] Read-Only in Base
[Tutorial] MS Access and OOo Base
[Tutorial] Read-Only in Base
AOO 4.0 and LibO 4 on Win 8
Hungarian forum co-admin
Hungarian forum co-admin
-
- Posts: 1
- Joined: Tue Jan 03, 2012 6:08 am
Re: Unable to edit data in Table from MSAccess .mdb
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
Ubuntu 10.4
Re: Unable to edit data in Table from MSAccess .mdb
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.
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