Is my Database secure?

[yummy7]

In my Access Database,I made my Startup Form the first form to be appear and is maximized.I did this through Startup option. Startup form is switch board.
I only want to know that when user clicks on .mdb database file,he sees that switchboard (Startup)form first. In this way is my VB code is safe from user acces or not.
OR I need to make .mde file.
In Addition I made all forms secure by making them dialogbox without close,mini and maximise buttons.All are maximized.So user will remain in the forms. After pressing quit button,whole application will quit.
Any suggestion is appreciated.

 

[kjv1611]

You might want to do some searching around in these forums on that issue. It depends upon who you're trying to secure your database from. If from end users in your own company, then that might be good enough. If you want to go a little further, you can disable the shift option when starting up the database (search here for "disable shift key at startup" or something along those lines). But, no, just setting up those options in that manner would not totally secure your database. If you wanted your code protected, you'd also need to encrypt it somehow, which has also been discussed in here at depth, in other threads.

 

[yummy7]

Thanx kjv1611 for positive response.My end users are users using it. I made it shared database by cheking mark its property 'shared'. They all are on same level but there is one administrator.So that if he wants to make any change in Database Design so he can.
I tried a lot to make it mde file but failed.So please send me some helpful posts or site addresses regarding how do i secure my database and make it shared by putting in network folder.
Thanx

 

[xeb]

Why can't you just set a password? (Tools-Security-Set Database Password)

Also, it's very important to disable the shift key, which gives users access to everything even if you made other settings. Users who aren't familiar with the shift key option could easily find out about it on the Web. There are many options to disable the shift key including stand alone programs. Presently I'm using code that allows me to enter a password to turn it on and off. I'll share my setup with you if you'd like. Also, when disabling the shift key be sure that you don't lock yourself out!

 

[yummy7]

thanx for response xeb. I set the password on Db. So how to disable shift key .Please send me your setup so that i may have idea about DB.
thanx

 

[xeb]

http://www.databasedev.co.uk/disable_shift_bypass.html

I put the code behind a very small button in the bottom corner on my opening form. Then I just open the database, click the button, enter the password, and enable or disable the shift key as necessary. It's simple and works very well for me.


Let me know if you need help.

 

[yummy7]

Cheers ,it works.

 

[yummy7]

Hi Xeb your code works. I try to understand it ,but fail.Tell me the story of ShiftKey in Access Projects. So please tell me to where we need to use ShiftKey and why? Thanx

 

[jadams0173]

If it's similar code to what I've seen and use then it simply modifies the properites of the database.

If you hold down the shift key while opening the DB it will bypass all startup options...autoexec, startup form and the like.

 

[yummy7]

bypass means?

 

[xeb]

Bypass" means to avoid, detour, evade, etc. In other words when you bypass you go around.

These may help explain the shift key...

http://www.techonthenet.com/access/security/enable_shift.php

http://www.tek-tips.com/faqs.cfm?fid=143

I have no idea why Microsoft choose to have such a feature.

You can run code that will disable it (until enabled) on the application level but I don't think that is such a good idea.

Like I said in an earlier post, there are also programs you can download that allow you to select the database of your choice and then with a few click disable or enable the shift key.

It's really whatever way works best for you. The only important thing is to make sure that you take the time to disable it so your users won't have access to places you don't want them to be.

 

[yummy7]

Thanx Xeb.I understand now.
But there is great trouble.See if I enter any data in tables through forms in .mde file. So that data will be concide in only that database.What about orignal one .mdb file.
Explain please.

 

[xeb]

Sorry, but I don't understand your problem.

 

[yummy7]

Hi, xeb
Users are using .mde file and updating database by entering data through forms. But if somehow that .mde crashes or misshandled by someone. So The updated data will remain in that .mde file. Lets see if i take backup of .mde file regularly. But can I ever convert .mde file into .mdb file.
Help me please.

 

[yummy7]

Also i found an idea of importing tables.That we can import tables of .mde.We can also extract forms modules and reports through a tool. Any other idea if you have regarding to tables because in tables most recent data is placed.

 

[xeb]

Sorry, but these issues are not something that I know enough about to help you. You should post them as a new question so you can get help from others.