Automotion
asked on
Compatibility issue between MS Access and certain builds of Windows 10
He attached article outlines an issue I’ve encountered with numerous MS Access databases that I own. The databases are all split and shared by multiple simultaneous users. Both the frontend and backend for each database is stored on a network drive.
The article provides workarounds for single-file databases and databases that are split, but in the scenario they lay out for split databases, each user has their own copy of the frontend.
In a situation like mine where the frontend is stored on a network drive and shared, would leasing need to be disabled for the folder that houses the shared frontend as well? Thank you.
https://support.office.com/en-us/article/access-reports-that-databases-are-in-an-inconsistent-state-%EF%BB%BF-7ec975da-f7a9-4414-a306-d3a7c422dc1d
The article provides workarounds for single-file databases and databases that are split, but in the scenario they lay out for split databases, each user has their own copy of the frontend.
In a situation like mine where the frontend is stored on a network drive and shared, would leasing need to be disabled for the folder that houses the shared frontend as well? Thank you.
https://support.office.com/en-us/article/access-reports-that-databases-are-in-an-inconsistent-state-%EF%BB%BF-7ec975da-f7a9-4414-a306-d3a7c422dc1d
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
John Tsioumpris
Why you keep the FE on the network folder...isn't it easier to have each user having a copy of the FE on their local drive ?
ASKER
John- Good question. About 20% of the user base is based overseas with the remaining 80% in the U.S. Performance for overseas staff would be debilitatingly slow if we didn’t have a shared frontend here in the U.S. available for them to access using a Microsoft Access productivity app that is hosted here in the U.S. where the backends also reside.
And how the overseas clients are using the application RDS? VPN?
If its RDS on the "user" directory there should be a fresh "local" copy every time they login...
Can you elaborate on the scenario you use.
If its RDS on the "user" directory there should be a fresh "local" copy every time they login...
Can you elaborate on the scenario you use.
<<John- Good question. About 20% of the user base is based overseas with the remaining 80% in the U.S. Performance for overseas staff would be debilitatingly slow if we didn’t have a shared frontend here in the U.S. available for them to access using a Microsoft Access productivity app that is hosted here in the U.S. where the backends also reside.>>
Even in a RDP setup, you want a separate FE for each user. They way to accomplish that is through a mapped drive to a local set of folders where there is one folder for each user.
While you can share FE's, it's not a great idea.
Jim.
Even in a RDP setup, you want a separate FE for each user. They way to accomplish that is through a mapped drive to a local set of folders where there is one folder for each user.
While you can share FE's, it's not a great idea.
Jim.