Re: MS Access

On Tue, 6 Aug 2024 00:26:09 -0000 (UTC), Lawrence D'Oliveiro
<ldo@nz.invalid> wrote in <v8rqj1$16a8l$2@dont-email.me>:

On 6 Aug 2024 08:47:36 +1000, Computer Nerd Kev wrote:
 

In comp.os.linux.misc vallor <vallor@cultnix.org> wrote:
>

As I said, I'd like to try Access on Linux using WINE or proton.

 
Some hints here for WINE, in case you haven't already seen:
https://appdb.winehq.org/objectManager.php?sClass=application&iId=12
 
Seems you might need to use the "Winetricks" system to separately
install the database engine for the database system that you're using
with Access.

Thank you Kev, I will check into that.

 
Should stay up long enough, at least, so you can extract all the data
and convert the system to LibreOffice Base with your choice of DBMS
backends.

I've heard that LO Base has no where near the capabilities
of MS Access.  Not sure how well their Access files would transfer
over to LO Base.

An alternative might be to import their Access data into Kexi:
 _ _ _ _ _ _ _
 KEXI is a visual database applications builder. It can be used for
 designing database applications, inserting and editing data,
 performing queries, and processing data. Forms can be created to
 provide a custom interface to your data. All database objects -
 tables, queries, forms, reports - are stored in the database, making
 it easy to share data and design.
 .
 KEXI is considered as a long awaited Open Source competitor for MS Access,
 Filemaker and Oracle Forms. Its development is motivated by the lack of
 Rapid Application Development (RAD) tools for database systems that are
 sufficiently powerful, inexpensive, open standards driven and portable
 across many operating systems and hardware platforms.
_ _ _ _ _ _ _

Kexi can import .mdb files.  If the Access route doesn't yield fruit, that's
another option.

--
-v System76 Thelio Mega v1.1 x86_64 NVIDIA RTX 3090 Ti
   OS: Linux 6.11.0-rc2 Release: Mint 21.3 Mem: 258G