View Full Version : restricting user access


stump3
07-02-2008, 09:52 AM
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.

Pat Hartman
07-02-2008, 09:17 PM
Citrix isn't going to solve your problem unless you really cripple the session plus you would need to use the Access runtime to run the applications rather than a full version of Access.

You should probably be distributing .mde files rather than .mdb files. At least this will keep the users from modifying forms and reports. To keep them away from other things, you'll need to resort to ULS which at its best is a PITA to implement. Also, ULS is no longer available when you eventually upgrade to A2007 so you'll be back to square one.

Do your best to lock down the application by disabling the bypass-shift Key. you should be able to find code examples here or on the net.