Date: prev next · Thread: first prev next last
2012 Archives by date, by thread · List index


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

Context


Privacy Policy | Impressum (Legal Info) | Copyright information: Unless otherwise specified, all text and images on this website are licensed under the Creative Commons Attribution-Share Alike 3.0 License. This does not include the source code of LibreOffice, which is licensed under the Mozilla Public License (MPLv2). "LibreOffice" and "The Document Foundation" are registered trademarks of their corresponding registered owners or are in actual use as trademarks in one or more countries. Their respective logos and icons are also subject to international copyright laws. Use thereof is explained in our trademark policy.