RE: [libreoffice-users] Re: Can't edit database connected to Access 2010 database?

Yes, I have a test file.  When I connect using the "Microsoft Access 2007" option, I can open the 
table, but not edit it.

-Douglas Pope

-----Original Message-----
From: NoOp [mailto:glgxg@sbcglobal.net] 
Sent: Wednesday, May 30, 2012 8:07 PM
To: users@global.libreoffice.org
Subject: [libreoffice-users] Re: Can't edit database connected to Access 2010 database?

On 05/30/2012 11:53 AM, Douglas Pope wrote:
> Hello everyone.
>
>  
>
> I have a Microsoft Access 2010 database that I would like to share 
> with a co-worker that is new to database software and does not use 
> Access.  I thought LibreOffice Base would be the free database 
> software that would be easiest for him to use, but I am having some 
> trouble with it myself.  I created a database file in Base and 
> connected it to the Access file, but I can't seem to edit the data in 
> the tables in Base.  I can edit those data just fine in Access, and 
> the edits cascade into Base.  I just can't edit the data in Base.
...
I'm not sure about an Access 2010 file, but I can easily edit the NWind.mdb file in LO 3.5.3. Note: 
to edit the date in the table, you use 'Open' rather then 'Edit'. 'Edit' allows you to edit the 
Field names etc. Also note that LO 3.5.3 (Windows version) has dropdown selections for 'Microsoft 
Access' and 'Microsoft Access 2007'. I do not know if 'Microsoft Access 2007' includes Access 2010. 
Do you have a test file?

When you right click on the table & select 'Open' what occurs? Does the table open for you?


--
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org Problems? 
http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted


-- 
For unsubscribe instructions e-mail to: users+help@global.libreoffice.org
Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/
Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette
List archive: http://listarchives.libreoffice.org/global/users/
All messages sent to this list will be publicly archived and cannot be deleted