Good morning everyone.
I developed an application for my work. I switched from Visual Basic 6 to Xojo and I use a Microsoft Access database on Windows. Everything works. However, I would like to use this application in Linux. Can anyone help me on how to connect an Access database on Linux? I tried but I can’t. They also gave me a link but for me, who am not a professional programmer, it is very difficult to understand what to do. Help!! (this is the link MSAccesOnLinux that could help me: , but if there are other easier ways help me). Thanks.
Is it a remote or local database. If it’s remote, you’re better off switching to something different, one of the SQL’s.
If it’s local, can you convert the database to a sqllite or other type for the linux version?
Access is Windows only as far as I know
Convert the MS Access Database to SQLITE then it works everywhere
Not sure what tools you have to deal with the Access database but if you have one that can export it as SQL statements to create the tables & insert the data that would be ideal
Then you have a script that can he tweaked for creating everything in SQLITE
The link provided uses a JDBC driver to connect to MS Access on Linux
While that may work it might also me more complex than simply converting the database to sqlite
+1 for converting to SQLite. The only other option I can think of trying is whether the application you developed will run under Wine with the access database?
Why riding a dead horse (MSAccess)… you really should switch to MariaDB, Postgres or SQLite. No Linux guy wants proprietary scam on his systems.
have no problems to access even under Linux. I gues Xojo has no Plugin for it. Ask MBS if he has a Plugin,
The link posted IS an MBS one to use a JDBC adapter from within Xojo
Should Work while is definitely working on Linux with java
its a database file. they aren’t forcing their users to install Access, they just need access to the access file.
ja i know, but with what technical debts? Using 3rd Party Database with 4th Party Addon (MBS) and 5th Party Technology (Java Bridge)!!! Come on… Seriously?
Who is even using Access as Database today? The rare cases I know use it for creating forms and reports against MSSQL Server… stop riding dead horses…
Hello @Fede,
If your goal remains facilitating access to a Microsoft Access database on Linux from Xojo then an alternative may be:
For “free” you can install PowerShell for Linux.
PowerShell has libraries for Microsoft Access (and just about everything else). Over the last few years most (but not all) have become cross platform.
From Xojo you can access PowerShell by executing shell commands to access data objects.
You can query the database to write reports, or create forms in Xojo to add, edit or update the Microsoft Access data (as per usual).
I think it’s worth killing an hour or two exploring it.
Kind regards, Andrew
Should
I’d just remove the dependency on Java if it was me having to port a Xojo app
@Fede your situation reminds me of some projects of mine I started to reject. In the end of the day these technical debts only causes friction and in the worst case even disputes between you and the customer. Because no matter how often you say “This is not good what you want to do” it always falls on your feet and in the end it’s all your fault.
It’s like hiring a plumber. He also tells you directly without any nice words: “I don’t do that kind of crap” when you confront him with strange ideas.
If today somebodys business depending on MSAccess, then really something is going south…
Also, the frequency of “I don’t do that kind of crap” increases with the amount they charge (for good reason).
Related, I got bad things to say about our healthcare system.
Hi @Fede,
Microsoft Access seems to work fine on Linux. Running MS Access and SQLite locally seem to have the same response time for me.
Were you able to get it working with any of the above information?
Warm regards.
t’s local for now, but I’d like it to be accessible from the local network.
I have this access database for years, there is a lot of data in it (since 2008) and I don’t want to lose even a comma. The database has about 10-12 tables, but I don’t know how to convert it to SQlite. I would like to understand if there is a software dedicated to this conversion and how it works. With access I have a .mdb file, and with sqlite?
Too complex, I would like to make the end user’s task easier. From everything I’ve read, the ideal would be to convert my access database (which has been working on windows with my VB6 software without any problems since 2008) to SQlite, and then make the sqlite database accessible from every workstation on the network (for example from 1 pc with windows and from a pc with Linux). But I don’t know how to convert the access ion sqlite database