Re: MS Access

On 8/7/24 8:59 AM, Just Me wrote:

On 06/08/2024 01:26, Lawrence D'Oliveiro wrote:

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.

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.

Users can import Access database in MS-SQL and access the data using
Excel with appropriate connector that is available from Microsoft.
 MS-SQL Express edition is free for users. It is available for Windows,
Linux and Docker container. There is a learning curve for people who are
new to industry class databases but once this is passed, the user would
be quite happy to use it assuming he has mastery of creating Forms in
Excel. With forms you can post new entries and also retrieve the entries
like any databases including Access. There are many tutorials available
online and on YouTube.
 <https://www.microsoft.com/en-gb/sql-server/sql-server-downloads>

   The handy default WYSIWYG form builder in Access
   was the superior way - and ideal for most small
   and medium biz/org needs and their humans.
   Thick SQL/JS is NOT 'employee friendly'. Means
   orgs have to employ their own expensive smelly
   annoying jargon-spewing code jocks who appear to
   just sit in a big plush chair with cookie-crumbs
   on their bellies and you can't tell if they're
   DOING anything or not  :-)
   MAYbe tomorrow's WYSIWYG is "AI"-driven DB/Forms
   creation. Just EXPLAIN what you kinda want and
   then AI-Dumbledore waves his wand and .....
   But you'll NEVER figure out how it works - or
   how it fails ....