Forum Discussion
Constant database conflicts
We operate a small law office. We have used Access for our client database for many years and it worked well for us until Covid lockdowns started. The primary data file is saved as .accdb file and ...
Hi brainstrust. (I'm not sure why I had to register again but somehow I now have a new account). I thought that SharePoint was going to be our solution but our database has around 17,000 records in the primary table with 2 child tables, one with around 30,000 records and the other with around 9,000 records. It will continue to grow. From what I have seen on the youtube linked below that is going to be unworkable with SharePoint. (pity as it seems a good process). What cloud based systems will work for a database of that size?
Hi JasonC777 ,
you have to setup a vpn at office. This will allow you to connect to your back end at the office from your front end at home.
of course it work as well as how fast is your connection at home and at office (look at both connection speed, download and upload to chose)
The second solution is a remote connection (anydesk, teamviewer or similar) to connect to your pc at the office from your pc at home. This solution il better for performance of the database (because data don't traver over the internet) but you have to have PCs always on at the office for every user.
Well, actually anydesk (and I think other) allow to swich on your pc remotely, so you can suthdown your pc and start it remotely when needed.
Ciao
- Thanks David. I am going to give remote desktop a try as we already have desktops for each user in the office. Thanks
