By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,551 Members | 2,727 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,551 IT Pros & Developers. It's quick & easy.

Front End/Back End Security

P: 73
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
Apr 14 '08 #1
Share this Question
Share on Google+
1 Reply


Guus2005
P: 3
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
May 30 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.