Server for VBA Access application

Question

Server for VBA Access application

Navigation

#1 by (1 votes)

-1

A friend has a business and has a system made in VBA .. He uses Access for the tables obviously, forms and reports, and encodes with VBA.

I had proposed a client server system: Delphi + MySQL. But I do not accept.

And you want to create a server to not pass data by means of pendrive from one machine to another. Would it be a shared disk on the Internet or am I wrong? Since access is not a database engine that is accessed with IP and Port. Should the disc be shared?

If it were like this: if there is no internet, it can be saved locally, or Access is "stuck" to that disk on the Internet.?

web ms-access

asked by Caruso 01.06.2018 в 15:42

source

1 answer

Is there a way to change the color of the button in android studio? help with php and database

score 1 · Answer 1

Access is not a DBMS, it is a local database and you can not access it directly through the internet.

Within a local network you can access through a shared directory. Through internet you will have to think of something like Terminal Server or similar.