interesting that you posted here, as I thought this community forum had been turned off.
as this is an Access forum, or was.... I cannot answer exactly on Windows Server / RDS parameters... but it is a set up & deployment I work with all the time as an Access developer. To deploy Access via RDS - where Access is a multi user application
then the app is split into 2 files: Front & Back. The single Back holds the common table data. Each user has their own Front file in their RDS profile and they all link to the single Back.
you cannot have multiple users simultaneously work in an unsplit Access file (which is single user) nor in a single common Front file - that will corrupt.