This forum has been archived. All content is frozen. Please use KDE Discuss instead.

How to open up MS Access Db on Kde Linux

Tags: None
(comma "," separated)
jgompert
Registered Member
Posts
8
Karma
0
OS
Is there a program that can open up MS Access Databases in Kde Linux.


Joshua Gompert
Joshnet.org
User avatar
bcooksley
Administrator
Posts
19765
Karma
87
OS
Kexi, which is part of the KOffice suite, appears to have some support for Access databases. How complete this support is I do not know.


KDE Sysadmin
[img]content/bcooksley_sig.png[/img]
User avatar
vbatts
Registered Member
Posts
102
Karma
0
OS
on a simple scenario i have had success using kexi for importing/converting an access database, but if the database was too[1] large/complex it would bomb out.

[1] the files i was attempting to work with were drastically different, so i'm not sure where the division line of "too" large. sorry.


vbatts, proud to be a member of KDE forums since 2008-Sep.

http://hashbangbash.com/
john_hudson
Registered Member
Posts
549
Karma
2
OS
It isn't really practical to use Access databases in Linux; however, if you convert them to mysql, Access can still access them and they are accessible in Linux.

This may not get you far if the relationships between the tables are complex because you will have to rebuild those relationships in Linux.


John Hudson, proud to be a member of KDE forums since 2008-Oct.
User avatar
jstaniek
Moderator
Posts
1027
Karma
2
OS
bcooksley wrote:Kexi, which is part of the KOffice suite, appears to have some support for Access databases. How complete this support is I do not know.


Tables are imported (their design and data).

Other object types are not reverse-engineered, so no FOSS project can access them, unless windows DLLs are used.


Best regards,
Jarosław Staniek
• Qt Certified Specialist
KEXI - Open Source Visual DB Apps Builder
• Request a feature or fix for KEXI here
May I help you? Please mention your app's version and OS when asking for help


Bookmarks



Who is online

Registered users: Bing [Bot], Google [Bot], Sogou [Bot]