Page 1 of 1

Unable to edit data in Table from MSAccess .mdb

Posted: Wed Nov 16, 2011 3:29 pm
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.

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

Posted: Wed Nov 16, 2011 3:55 pm
by r4zoli

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

Posted: Tue Jan 03, 2012 6:19 am
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.

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

Posted: Tue Jan 03, 2012 7:49 am
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.