Question How to restrict End User activity (2 Viewers)

ismailr

Registered User.
Local time
Today, 09:48
Joined
Oct 16, 2015
Messages
31
Hi Experts,
I created three forms which I need to give to end users. These forms are used to collect some basic information about business transactions. I wanted to restrict the users activities therefore I have to give the form in such a way that end user will not access database. In short use will open the form enter the required information and there is exit button which will close the form and access. All development is done under Access 2013.
Is it doable? How? Thanking you in anticipation.
Ismail.
 
As i have learned the hard way if you want secure secure you have to use MySQL backend with Access front end but if pseudo secure application is enough for you..as in it looks secure and you need a little Access knowledge to get in...

read this post and you can hide the back DB window and remove the ribbon leaving your DB clean and neat..

DB properties form

If you dont know what these properties are test them out and see what happens, just do it ona test DB so you dont mess anything up :)

Copy the form and paste it into your own DB run your form and use the shortcut "Ctrl+shift+k" to make the properties form apear
 
Hi Experts,
I created three forms which I need to give to end users. These forms are used to collect some basic information about business transactions. I wanted to restrict the users activities therefore I have to give the form in such a way that end user will not access database. In short use will open the form enter the required information and there is exit button which will close the form and access. All development is done under Access 2013.
Is it doable? How? Thanking you in anticipation.
Ismail.

Check this sample DB i made with the properties form integrated. It starts up with most things off you can change the appearance in the properties form all kudos goes to speakers_86
 

Attachments

Last edited:
Look at the File-Options
at the Current DB options you can set which form will be opened, allow access to the db window and many other options.
 
Thanks. I will review and update you about my progress.
 
Hi,
One more side question.
My form width is 6". It has the below properties;
Auto center = Yes
Auto resize = Yes
Fit to Screen = Yes
Moveable = Yes
pop up = Yes
modal = Yes
Board Style =Sizable
and on open event
DoCmd.Maximize

Issue - When the form open does not show in the center. I want to display on the center of the screen.
What I have to do?
thanks
Ismail
 
As i have learned the hard way if you want secure secure you have to use MySQL backend with Access front end ...

You do no have to use just MySQL. Most Access developers use Micorsoft SQL Serer Express.

Using an client/serer RDMS like an SQL Serer (Microsoft SQL Server, MySQl, Oracle, etc) protects the back end better than a file based back end like JET/ACE (.mdb/.accdb) database formats.

Protecting your Access front end is basically the same no matter what type of back end you are using.

A compiled database (.mde or .accdb) and forcing Access into Runtime Mode get will give yu a very secure data without doing anything else. To test it with Access 2007 and later with the new ACE (.accdb/.accde) format database simply rename the front end to .accdr and double click on. BAM ... lock down.

even with a client/server back end (SQL Server) it is still impossible to completely secure an Access front end like you can a try EXE file. You can protect your forms, reports, and VBA code module by compiling the database into a .mdb/.accdb. You can only hope to out up so many road block that they give up.


If you dont know what these properties are test them out and see what happens, just do it ona test DB so you dont mess anything up

FYI: You can easily reset all the properties using an external database.

I have not looked at speakers_86's example bit I would be very surprised if it could not easily be change to set the properties on an external database.

I highly recommend only setting he "lock down" properties on your .mde/.accde just before testing a or deployment. This way you do not have to worry about locking yourself out of your master/source (mdb/accdb) database.
 
Hi,
One more side question.
My form width is 6". It has the below properties;
Auto center = Yes
Auto resize = Yes
Fit to Screen = Yes
Moveable = Yes
pop up = Yes
modal = Yes
Board Style =Sizable
and on open event
DoCmd.Maximize

Issue - When the form open does not show in the center. I want to display on the center of the screen.
What I have to do?
thanks
Ismail

Do you see a Tab in the upper left corner of the form? Is yes, try changing the setting for Document Windows Options to Overlapping Windows. This is in Access Options > Current Database
 

Users who are viewing this thread

Back
Top Bottom