Hello all,
I will soon (hopefully) be implementing an Access database to replace the existing mess of Excel spreadsheets that are used in the my office to manage our work hours, client info, invoicing, etc.
The database is intended to be used by less than 10 people (realistically only 2 or 3 at any one time), all within the same office network (with hard-wired Ethernet connections)
Some users will have access to only certain parts of the database through a split system for the back end tables and front end queries, forms, reports, etc.
My question is:
Do i need anything specific as a 'server' to store the database back end?
I was thinking of getting a simple Intel NUC or similar with a Core i5, 32Gb Ram, 512GB SSD, Windows 10 Pro, powered from a UPS.
Is this overkill?
Is this not enough?
Is Windows 10 Pro OK?
Any advice is much appreciated
I will soon (hopefully) be implementing an Access database to replace the existing mess of Excel spreadsheets that are used in the my office to manage our work hours, client info, invoicing, etc.
The database is intended to be used by less than 10 people (realistically only 2 or 3 at any one time), all within the same office network (with hard-wired Ethernet connections)
Some users will have access to only certain parts of the database through a split system for the back end tables and front end queries, forms, reports, etc.
My question is:
Do i need anything specific as a 'server' to store the database back end?
I was thinking of getting a simple Intel NUC or similar with a Core i5, 32Gb Ram, 512GB SSD, Windows 10 Pro, powered from a UPS.
Is this overkill?
Is this not enough?
Is Windows 10 Pro OK?
Any advice is much appreciated