MS access file is getting corupt
I have a Windows AD environment and use DFS to sync three locations. I want to use a MS Access file and have three computers at one site to do updates to the file. The rest of the users will have a runtime reader to read only the file. I've done some testing and the reader seams to lock the file as well. One location reported a completely mixed up file. Am I fooling myself thinking this will work ?
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks guys. That was my fear. I like the RDP solution, the branches use that anyway for other apps.
We use the full Microsoft Access program to produce the form which is what we share.
Do you think Google drive would do any better ?
We use the full Microsoft Access program to produce the form which is what we share.
Do you think Google drive would do any better ?
<<Do you think Google drive would do any better ?>>
No. A JET/ACE DB must be shared on a Windows OS (or a NAS as long as it can handle the locking), and it must be done over a local LAN.
Google Drive, Drop Box, or anything along those lines is a non-starter.
Jim.
No. A JET/ACE DB must be shared on a Windows OS (or a NAS as long as it can handle the locking), and it must be done over a local LAN.
Google Drive, Drop Box, or anything along those lines is a non-starter.
Jim.
I have a number of clients who use Citrix. It works extremely well. RDP is also an option as someone already mentioned. Using Citrix or RDP, if you host the server yourself and it is attached to your LAN will allow people to run the app directly when in the office and via Citrix or RDP when in another location.
Yes.
<< The rest of the users will have a runtime reader to read only the file. >>
Even if a user only reads a MDB, they are still writing to it. The process of logging into the database and connecting to it requires write operations.
As gustav said, either switch to SQL Server for the data store, or have users outside of the main site use an RDP server on the main site to get to the app as a JET/ACE DB cannot be used over a WAN.
Jim.