Remote access to a server

[George R]

I want to create a database where separate users can interact with a
relational database on a server I don't know whether to use Access or MySQL.
I want the users to be able to work with a common database, run jobs to see
how data flows, and also to be able to modify it with SQL and VBA. I would
appreciat any ideas or suggestions.
Thank you for your consideration.

 

[Matt]

If your users are in a LAN (local area network) environment you can use an MS
Access database. If the user are in w WAN (wide area network) environment,
you can create a MS frontend application to a SQL Server or mySQL backend
database server. Other factors include total # of users, # of records and
security. I generally start with an MS Access backend database - I can
always upsize in the future if the application grows.