Forms Not Displaying for Domain Users

[KKenui]

I have an Access 2010 database. I have split it into FE and BE. I created the .accdr and published to my RDS servers, as well as added this as an RDS App.

The issue is when I run the .accdr as a RDS App everything displays correctly (I am a domain admin); however, when the average user tries to run this RDS App, everything displays correctly except the actual forms. I am not sure why this is happening or how.

Changed security on FE and BE to allow users full access to both. Still not showing forms. No other users are using this as it is broken and i am only user with it open.

I am at a loss. I have repackaged the .accde file and everything. When I run the file it runs correctly (forms show). When a domain user runs the file it does not populate the forms.

I have added the registry key to for the Trust Center.

I have tried running just the file itself and not thru the RDP server and still no luck..

I have added the group "Everyone" to have full access to the database (both front and back end) with no luck... Any ideas? I have to have this fixed by Monday....

 

[Galaxiom]

Re: Forms Not Dispalying for Domain Users

Drive mapping differences among users?

 

[missinglinq]

Re: Forms Not Dispalying for Domain Users

Are the Controls on the Forms visible but not showing any data, or are they not even visible?

Linq ;0)>

 

[KKenui]

Re: Forms Not Dispalying for Domain Users

So I have resolved this issue...

I was simply right clicking on the file and changing the permissions under the security tab.

I had added the user x to have full access rights, then logged in as user x and right clicked on the folder. I found out that the security was not being applied. I then logged into the file server and went to Share & Storage Management and changed the permissions there to allow modify. Once I did this the forms appeared.

Apparently in 2008 R2 you have to change the permissions in the Share and Store Management MMC and cannot simply right click on the folder to change the permissions.

This seems to work for a Share, but what if I only want to give a user access to a specific file within that folder? This seems apply security to the whole share. What about files and folders within the share? I only want users to be able to modify certain files within the folder and it seems that giving them modify access to the whole root share overrides the security on the security tab of the file....

 

[Galaxiom]

Re: Forms Not Dispalying for Domain Users

There is separate security on the Share and on the Folders/Files.

The Folder/File Security is normally inherited from the parent folder. To change security from that model you need to go to the Advanced section and change the inheritance settings for the folder's subfolders and files.

It is generally a good idea to keep the Folder/File Security at the folder level and not have a separate security setting on individual files. This way files copied into the folder adopt the correct security without having to remember to individually set it for the new files.

Note that files Moved into a folder bring their original security with them so always copy and paste rather than drag and drop.