[Libreoffice-bugs] [Bug 91190] Import from Access-Databases: only tables imported

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Mon Oct 23 15:29:18 UTC 2017


https://bugs.documentfoundation.org/show_bug.cgi?id=91190

--- Comment #6 from Alex Thurgood <iplaw67 at tuta.io> ---
(In reply to Henri from comment #5)
> (1)
> I use MS Access 2010 ×64 and have no problem to use any .accdb or .mdb
> database. Both formats are fully supported !
>

Yes, Access 2010 allowed users to read both mdb and accdb (2007) formats, with
the recommendation by Microsoft to convert at least the mdb formats to 2010
accdb:

https://support.office.com/en-us/article/Convert-a-database-to-the-accdb-file-format-098DDD31-5F84-4E89-8F44-DB0CF7C11ACD

See also the note at this link:

https://support.office.com/en-us/article/Convert-a-database-to-the-accdb-file-format-098DDD31-5F84-4E89-8F44-DB0CF7C11ACD#__use_access_2007


Access 2010 by default was 32 bit :

https://msdn.microsoft.com/en-us/library/office/ee691831(v=office.14).aspx

The user/admin needed to specifically activate the 64bit installation.


As regards the DatabaseAccessEngine components and the problems of 32/64 bit:

https://techblog.aimms.com/2014/10/27/installing-32-bit-and-64-bit-microsoft-access-drivers-next-to-each-other/

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20171023/d75f20a2/attachment.html>


More information about the Libreoffice-bugs mailing list