question

Solidguy01 avatar image
0 Votes"
Solidguy01 asked pituach answered

trying to make a cost assesment but i'm stuck with what licenses to buy

Maybe it's easiest if i give some background info.

i have an Office Access application running on a Azure vm Server.
i want multiple people (+-10) to be able to work on the server at the same time.
what i already found out that i need is:

  • Azure vm running Server 2019 datacenter

  • 8 RDS user licenses and for that a Domain Controller is also needed

  • since it is an office app i'll need to make sure each user minimum has a Office 365 E3 license.

  • the Acces also makes a connection to an SQL-Express, which i think is free but limited to 10Gb.

what other things should i buy or do?

thanks in advance



azure-virtual-machines
· 2
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

Not clear to me if want to use MS ACCESS from your application as database, or you want to use MS ACCESS GUI by 8 users at the same time on the same database.

0 Votes 0 ·

Let's say the 2nd option is more in line for what i'm doing with it.
Each user should be able to use the access to its full content.
One of the databases is used by all the users at the same time.
.

0 Votes 0 ·
DSPatrick avatar image
1 Vote"
DSPatrick answered
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

pituach avatar image
0 Votes"
pituach answered

Sorry for the late response @Solidguy01 . It is hard to follow the threads here.

So, you want to use MS ACCESS GUI by 8 users at the same time and work on the same database, but MS ACCESS is not a server (application which design to serve multiple users) but an office application which designed to work with files directly.

For example think about SQL Server. SQL Server is a set of services and not a client application. There is no GUI to SQL Server and we connect to it from external applications (the most common is the "SQL Server Management Studio". The server is optimized to manage multiple users and sometimes for a single user it is better NOT to use SQL Server. For example the server include complex and advanced algorithm based on Locks and Waits in order to allow multiple users to work on the same table.

According to your description here is is pretty clear (in the limitation of the short description you gave us) that You want to enjoy both worlds.

On the one hand you want to have the visual ability (GUI) of MS_Access to manage the information, but on the other hand you need the power of a server to manage multiple users' work. This is very common scenario and this is exactly the solution Microsoft provide you; a combination of a single SQL Server database which is manages using MS ACCESS which each user can have his file locally.

The basic architecture is to use Access front-end and SQL Server back-end...
https://youtu.be/uNGqKE0jSDM

what licenses to buy?!?

For this architecture you will need a licence for MS ACCESS for each user, since the user uses the application. and One licence for SQL Server (which can be free if you use EXPRESS edition)





5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.