Calling all UKb computer
geeks ... experts
got an problem that I've been struggling to find a satisfactory solution for.
At work we use a bit of software that uses a Microsoft Access database backend.
Its multi user - i.e. 2 or 3 of us may be using the software at the same time and updating it (updates are not high frequency - e.g. one of us hitting save every half hour)
Up until last week - the DB was stored on a network hard drive and accessed purely across the network. (no web connectivity)
This was working OK barring concerns over backup and dataloss.
All our other stuff has been transferred over to google drive so we have the security of cloud based backup.
Last week I was away and the drive failed - we lost a bit of data but most of it got recovered from some 'disc doctor' guy apparently.
I'm aware that using an access DB on the cloud will be fraught with issues (conflict resolution etc etc).
Does anyone have any ideas for workable solutions. Cloud would be great if it will work.
Ideally we need
- multi user access to the database from several computers across a wireless network in the office.
- conflict free
- fit and forget backup
- internet access to it would be a nice to have.
The database it not large at all - 30mb at the moment - but there are older versions too so we are looking a couple 100mb tops.
NAS ?? (dont think we need terabytes of storage though)
Someone will possibly mention Microsoft 365 - which may or may not work - not sure that our software will like talking to something 'through' something like 365.
At the end of the day - we just want it to be simple (and cheap), we're not that techie here and don't have an IT department (there are 4 of us - and I'm the IT guy)
Cheers in advance