Setup data security in Access 2003

C

Cam

Hello,

I am planning to start creating an Access database 2003 and would like some
suggestion on how I should setup the security. Any advice is appreciated.
I can only think of two ways. Please let me know which would you sugguest.
1) Design the database with tables, forms and reports, then apply security
(access level right) to the database, then split the databse into FE & BE.
Create a shortcut to the FE for users to input database.
2) Create the tables, split the database into FE & BE then create forms and
reports from the front end. Create a shortcut to the FE for users to input
database.

Also, should I create a new workgroup, join the new workgroup before or
after creating a database?
 
K

Keith Wilby

Cam said:
Hello,

I am planning to start creating an Access database 2003 and would like
some
suggestion on how I should setup the security. Any advice is appreciated.
I can only think of two ways. Please let me know which would you sugguest.
1) Design the database with tables, forms and reports, then apply security
(access level right) to the database, then split the databse into FE & BE.
Create a shortcut to the FE for users to input database.
2) Create the tables, split the database into FE & BE then create forms
and
reports from the front end. Create a shortcut to the FE for users to input
database.

Option 1 would do it for me.
Also, should I create a new workgroup, join the new workgroup before or
after creating a database?

Before. Be sure to leave the default "system.mdw" unmodified and leave it
as the default workgroup so that none of your unsecured databases are
affected.

Keith.
www.keithwilby.com
 
C

Cam

Thank you for the sugguestion.
Also, where is the join workgroup .exe located in Access 2003? or what is
the file name?
 
K

Keith Wilby

Cam said:
Thank you for the sugguestion.
Also, where is the join workgroup .exe located in Access 2003? or what is
the file name?

It's incorporated into Access - Tools, Security, Workgroup Administrator.

Keith.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top