Front End/Back End Security

[Supermansteel]

I created an Access Database and added the Security thru the Securtiy wizard. Then Split the database into the fe and be files, however, the security did not stay with the .be file. Is there a way to prevent random people from accessing the .be file and/or tables? or by creating security on the .be, will it give me problems with running queries on the front end?

Can anyone help?

Thanks,

Matt

[Guus2005]

Did you create a new workgroup first?
If not, you are editting the default system.mdw file. Then even i can enter your "secure" database when you use the default.

Create a new workgroup file.
Using this new workgroup file, open a new database
Import all objects from the old, unsecure FE database into this new database.
Do the same for your BE.

Add users and permissions. Now you are secure.

HTH:D