Problems of migrating from Access to MySql or MariaDB

[Etxezarreta]

Hello all,
I had a general question: compared to a Access FE-SqlServer BE model, what are the mains challenges of using MsSql or MariaDB as a BE?
For exemple, are there any functions that need to be adapted ?
Many thanks in advance.
Etxe.

 

[theDBguy]

Hi. At least with MSSQL, you will have to learn T-SQL. Some VBA functions are transferrable, but there are some you'll have to convert. Probably the same with MariaDB and others too.

 

[Isaac]

Don't take this as encouraging people not to utilize t-sql, as I think it's a very good idea to utilize it, once you have sql server as a BE.

But there are certainly people out there who use SQL Server as a back end and have never written a single line of T-SQL. They just keep writing queries (using Access functions, Access SQL, and Access VBA functions) against their ODBC table links and never go beyond that.

 

[Minty]

There is core "functionality" in most versions of SQL, however each DBMS has subtle variations on the same theme.

I suspect

SELECT Field1 From Table1

would work in most though.

 

[NoLongerSet]

Ben Clothier wrote about some of the important technical differences between a MySQL backend and an MS SQL Server backend here: How does Access talk to ODBC data sources? Part 4.