user restriction

[stump3]

I want to restrct users from modifying the access applications. Many users have microsoft access on their computer so it isn't any problem for them to open the application frontend, and change the forms, or create new ones or even copy the app to their hardrive, modify it and link to the backend which is on the server. I was thinking about putting the application in a citrix envoironment but everything I read on the internet says that it is difficult to do and doesn't support multiple users very well. The big thing about citrix is the users only get a screen shot and are then unable to copy or modify anything. We have about 180 access applications in 97, 2000, and 2003 versions Any advice would be appreciated.

 

[Ed2020]

You'd probably be better off asking this question in one of the Access forums (I'd suggest "Microsoft: Access Other topics").

With 180 different systems there may not be a quick and easy way of doing this. Access's Workgroup Security would do what you want, but as this involves changes to the system you should test each one after applying the security. Are you familiar with Access's security?

Ed Metcalfe.

Please do not feed the trolls.....

 

[Ed2020]

One other thought (not sure why this didn't occur to me before):

You could look at removing full MS Access and deploying Runtime Access instead.

Ed Metcalfe.

Please do not feed the trolls.....

 

[Hondy]

there is a way of making it run in a "user" mode - i can't think off the top of my head how to do it but you have to know to hold down the left shift button to access the design part, i would expect you can password protect this also. But maybe the access forum is best for this.