Database Security After Split

[racemadnss]

Hi All,

I know this has been posted many times before, but none of them addressed this problem.

When you open the front end, you see the form that opens automatically and then you can also go look at the tables. If I password the backend and the forntend has connected with the backend (using the password) can a user still delete a table by switching over to the Access window?

If so I will need to spend some more time figuring out this Jet security stuff.

Thanks Yall.

 

[KenHigg]

Are you currently using just the db password feature or are you doing the full Access security stuff?

ken

 

[racemadnss]

I am not currently using any password or security.

 

[KenHigg]

Sorry, I thought you had security already in place.

Then to answer your question:

If I password the backend and the forntend has connected with the backend (using the password) can a user still delete a table by switching over to the Access window?

If you set security up properly, no.

ken

 

[racemadnss]

Hey, I figured it out!

My main form loads all the other forms inside of it, so I made it a popup, and when its a popup it steals focus until its closed, so you cant view the tables, etc. and when you close the main form, it just closes everything

Thanks for the help, I think I will go ahead and password protect the backend as well, for extra security.

 

[KenHigg]

There is also a check box to hide the db window in the tool-> start up dialog box...


ken

 

[racemadnss]

Sweet! Never noticed that! Thanks