peskywinnets
Registered User.
- Local time
- Today, 02:21
- Joined
- Feb 4, 2014
- Messages
- 578
I currently use a Access DB as a single user to help me run my small online home business.
My wife helps me in the business now & then & carries out certain tasks using access ...this leads to contention for the seat at the PC where Access is running!
I've read up a little & think the best way would be to have two PCs & split the database (front end & back end)...am I correct?
if so, if I then change the front end on one PC ...what do I do to ensure the other PC's front end is updated too? (sorry if this is a basic question - will it just be a matter of copying a 'front' end (whatever that might be?!) from one PC to the other?
My Access database is currently running on a PC with a single drive...occasionally when I remember I make a copy, but it's far from ideal should my hard drive fail...I was therefore thinking about putting the back end on a NAS (with two mirrored disks for redundancy) but any speed degradation would be a downer....is there a better approach? (i.e. for two users ...I'm not bothered if one PC/User has a slower service & one has a fast service if that helps decide which way to go)
Many thanks in anticipation.
My wife helps me in the business now & then & carries out certain tasks using access ...this leads to contention for the seat at the PC where Access is running!
I've read up a little & think the best way would be to have two PCs & split the database (front end & back end)...am I correct?
if so, if I then change the front end on one PC ...what do I do to ensure the other PC's front end is updated too? (sorry if this is a basic question - will it just be a matter of copying a 'front' end (whatever that might be?!) from one PC to the other?
My Access database is currently running on a PC with a single drive...occasionally when I remember I make a copy, but it's far from ideal should my hard drive fail...I was therefore thinking about putting the back end on a NAS (with two mirrored disks for redundancy) but any speed degradation would be a downer....is there a better approach? (i.e. for two users ...I'm not bothered if one PC/User has a slower service & one has a fast service if that helps decide which way to go)
Many thanks in anticipation.