how to hide my database

[associates]

Hi,

This is concerning the database security. What i have done is that i have managed to set up the user-level database security and it's currently working. However, there is something that i'd like to try out. How do i make sure that users who log into the database can not see the access database window (sorry unsure what this is called) that has a list of tables, queries, forms and so on. For example, we can double click on tables to get a list of tables and can see their content. SO all i want people to see is just a start-up form with nothing else in the background of the database when they open up the database. That way, people cannot access to the tables or forms or reports and so on. If there is a way of doing this? how do i do it?

Thank you in advance and look forward to hearing from you.

 

[mp9]

Tools, Startup

There you can uncheck "Show Database Window" and set a start-up form.

http://www22.brinkster.com/accessory/

 

[associates]

Thank you MP9

That's what i wanted. However, I'd like to ask one more thing.

When i unchecked everything except for the display status bar and use access special key options, then closed the database, then opened it up again, i could see the database window disappearing (that's good), only the start-up form showed up. Then, I closed and reopened it but this time with the use of holding down the shift key, i could view everything including the database window but the start-up form did not pop up.

My question is how to get the start-up form to be loaded up or i actually need to manually go to form to open up the start-up form or write some codes. what's the easiest way?

Thank you very much and look forward to hearing from you

 

[MajP]

I am not sure of your question. When you hold down the shift key you bypass the startup options, so you will not see the startup form or the options set in the startup window. If you are asking how to keep someone from bypassing the startup options you have to add a property to the database property collection. The following code does this:
Dim db As DAO.Database
Dim prt As Property
Set db = CurrentDb()
On Error Resume Next
Set prt = db.Properties("allowbypasskey")
If Err.Number <> 0 Then
Set prt = db.CreateProperty("allowbypasskey", dbBoolean, False)
db.Properties.Append prt
Else
prt.Value = False
End If

When you run this code nothing seems to happen. Close the database, and try to bypass the startup options. You will not be able to do that. Not sure if this is your question.

 

[Pampers]

Hi associates,
I think in StartUp you want to set Display/Form Page; that is the form that will pop if you start your application without holding the shift-key down.


Pampers.

You're never too young to learn

 

[associates]

Hi,

Thank you to both MajP and Pampers for your help.

Sorry for making you confused because i don't know if by holding down the shift key, we actually bypass the startup options which means it doesn't bring up the startup form that was designed as a startup menu where user can make their selection there. And this startup form usually show up when opening the database. I think holding down the shift might keep this form from showing. That's fine if that's the way it works...

I've got a question at the moment. Where do i put the above code given by you in my database because i like to try it out. Sorry for asking this question.

Thank you very much and look forward to hearing from you.

 

[rosieb]

Hi associates

Have you thought of creating an mde file? That would stop users tampering and it avoids the chance of them using the shift key.

You'd need to split your database, then MDE the front end. Obviously you'd have to make sure you kept a secure backup of your master front end mdb.

Rosie
"Never express yourself more clearly than you think" (Niels Bohr)

 

[MajP]

associates,
Yes if you hold down the shift key you will bypass startup options, that includes the start up form and anything else that you set in the StartUp options. That is the purpose of holding down the shift key at start up. For example you could limit the use of Full Menus in the start up options or the use of short cut keys. However, if you hold down the shift key you will bypass these restriction.
The code I gave you can be ran from any module in the database, even from the immediate window. Once you run it, it sets a property of the database that stays with the database. You will not see anything happen.

Also Rosieb's statements about MDE's are incorrect. This will not stop the user from bypassing the startup options with a shift key. Try it. Also and MDE stops the user from doing a few things such as messing with modules, forms, and reports. But it is far from a means to keep the user from tampering.

 

[mp9]

Associates - search Access Visual Basic Help for AllowBypassKey for a comprehensive overview of holding down the Shift key, what effect this has and how to turn off the ability of holding down the Shift key. There's even a code example of how to turn this facility on and off.