I need some help with a small business set-up that's worked okay until now but is in danger of causing some big problems for us as we continue to expand.
The business effectively 'runs' from an Access database that contains all the information for our customers, orders, etc. That database is held on a desktop PC in the office and shared on the local network to a laptop. Presently those are the only two PCs in the office but we're thinking of adding a third as we grow.
The problem we face lies with the fact that we've recently added an 'extra' person to helps us process orders that come in at the weekends and some of the evenings. They need to be able to access the database from a remote location and to 'solve' that we're currently using GoToMyPC to allow access to the desktop machine whilst it's not being used.
But that's sort of knackers us if someone needs access to the finance package which is also on the desktop PC and our extra person is 'using' it. What we need is a solution that will allow us to share the Access database locally as well as remotely but free up the desktop PC for someone to GoToMyPC into in case they need to get to anything on there during out of office hours.
Any bright ideas? I'm sure there's something simple but my brain is drained form trying to manage the day-to-day running of the business and doesn't have the spare capacity to think about anything else!
The business effectively 'runs' from an Access database that contains all the information for our customers, orders, etc. That database is held on a desktop PC in the office and shared on the local network to a laptop. Presently those are the only two PCs in the office but we're thinking of adding a third as we grow.
The problem we face lies with the fact that we've recently added an 'extra' person to helps us process orders that come in at the weekends and some of the evenings. They need to be able to access the database from a remote location and to 'solve' that we're currently using GoToMyPC to allow access to the desktop machine whilst it's not being used.
But that's sort of knackers us if someone needs access to the finance package which is also on the desktop PC and our extra person is 'using' it. What we need is a solution that will allow us to share the Access database locally as well as remotely but free up the desktop PC for someone to GoToMyPC into in case they need to get to anything on there during out of office hours.
Any bright ideas? I'm sure there's something simple but my brain is drained form trying to manage the day-to-day running of the business and doesn't have the spare capacity to think about anything else!
.
