Hello to everyone.
I have a vb6 application that uses a Database MS Access in read-only method.

I want to change this database with another, centralized and server side like SQL Server or MySQL.

Actually, into vb6 I use DAO for the connection (I know is an older method and there are better like ADO)

I don't know if is better to create my own API and connect to the data by vb6 or buy a SQL SERVER Cloud (Ex: azure) and connect them by ODBC Connection.
I'm afraid that this connection might be too slow...


What do you advise me to do?

The DB is 5MB of dimension with 500/600 connection every day