Security of application

[gaju_3112]

I have created one MS-Access application. This application will reside on server. The application will be used by many users from there local PC. I want to allow them access to only forms of application and they should not able to inerfere in database tables, queries form designing etc. How can I accomplish this task?
In short, only I should able to modify the application and all other should be able to enter the data in form and nothing else.
Please help me out...

 

[s1police]

YOU CAN TRY TO LIMIT THE FUNCTIONS IN TOOLS>STARTUP..

It is depended on what you want to display....

 

[HHUK]

s1police is correct, goto Tools, then startup. You can disable the menus, etc. So only your startup form will show when you turn it on. Then the are only permitted to follow your database as you wish.

You could protect this further by compiling the user's copies into .MDE's but always keep a backup of your .MDB's.

Just remember though, if you get rid of the menus you should open your database while holding down the shift key to over-ride hiding the menus so you can edit your database again.

Always keep backups when trying to do something like this, getting locked out of your own database is the worst you could ask for.

 

[gaju_3112]

I tried tools->startup for sample application. But now I am not able to restore the tool bars. Can you please tel me the technique of holding Shift key in detail?

 

[HHUK]

Hold down the shift key, then doubleclick your .mdb file. Keep the shift key held down while the database is opening so it registers it properly. Your bars should now be there.

I notice that if it takes a while to open and you let go of the shift key before it's fully opened it can carry on loading without the menubars.

 

[MadSmoke]

You can also protect your back end (through start up options) by disabling the database window. Also specifying a form to run on start up that states that the back end is protected and on an 'On-timer event' closes the application.

 

[gaju_3112]

Is it poassible that "shift key" by pass is available for only some users and not for all. I mean to say, can I enforce security in such a way that only I can look into database window and no one else?

 

[supercool]

actually have a few solution.
(a) you can assign different users of varies of capability by creating accounts. everytime, the user is trying to use the database, he/she has to login before getting the permissions and rights intended.

(b) Just as somebody previously mentioned, actually u can disable the menus and hide those windows you dont want to show in the startup. Or just simply post a mde file instead of mdb. pay attention the following:
if you use mde:
(1) The user interface for modifying or creating forms, reports, or modules will be disabled. The VBA References dialog box will not allow adding, deleting, or changing references to object libraries or databases.
(2)The source code will not be available.
(3)The importing and exporting commands will be disabled for forms, reports, or modules. However, tables, queries, data access pages, and macros can be imported from or exported to non-MDE databases.
(4) Some wizards would also be not available.

(c) If your users use MS access of run time version, then you dont need to worry about it as database window does not even come as a feature of runtime version fo MS access.

 

[MadSmoke]

Hi gaju

Just running at the moment so don't have the time to reply in detail, but have a look for setting the "Autobypass" property to False on startup. This disables the shift key bypass function.

Setting it for different users would be a possibility, but you would probably need the useres for whom you wish to have access to the database window etc to start up the application, log in (and from their login set AutoBypass to False) then for them to close the app and re-open it (holding down the shift key).

Hope this is helpful for starts

MS

 

[s1police]

The "SHIFT" tricky is known to someone professional to MS Access. haha....

I think there is no solution that fit to you. You cannot bypass "SHIFT". If someone know, please let me know.....