Securing a new database with an existing workgroup file

  • Thread starter Thread starter paulsmith5
  • Start date Start date
P

paulsmith5

Hi,

I secured a database a while back using the User-Level Security Wizard.
During this process I created a new workgroup file, modified the Admins
group by adding a new administrator and removing the original Admin
account etc. Users opened up the database using a shortcut which
pointed to the new workgroup file. Everything worked out fine. Now I
wish to create a new database, with new database objects and apply the
same security to it. The groups and users will be the same so I was
wondering if I can use the same workgroup file to secure this database?
If so how do I go about doing this?

Thanks,

Paul
 
I secured a database a while back using the User-Level Security Wizard.
During this process I created a new workgroup file, modified the Admins
group by adding a new administrator and removing the original Admin
account etc. Users opened up the database using a shortcut which
pointed to the new workgroup file. Everything worked out fine. Now I
wish to create a new database, with new database objects and apply the
same security to it. The groups and users will be the same so I was
wondering if I can use the same workgroup file to secure this database?
If so how do I go about doing this?
Click to expand...

Hi Paul,

Open Access up using a shortcut to your existing secured app. Close your
app but keep Access open. Use the menus as appropriate to create your new
app. Apply permissions as and when required. That's about it.

Regards,
Keith.
www.keithwilby.com
 
Hi Keith,

Thanks for the reply. I ran through what you suggested. Am I right in
saying that when you create a new database that the Users group is
given full permissions on the newly created objects and that I should
remove these rights before assigning rights to my custom groups? Thats
what I did anyway and it seems to work.

Thanks again.

Paul
 
Paul,

Copy your existing db, rename it to whatever name you want
Delete all objects you don't use anymore (maybe there are code modules that you want to
re-use)
Compact and you are done.
Security for the db and new objects that you are going to create will be *exactly* the
same.
 
Am I right in
saying that when you create a new database that the Users group is
given full permissions on the newly created objects and that I should
remove these rights before assigning rights to my custom groups? Thats
what I did anyway and it seems to work.
Click to expand...

That's right. Glad to be able to help.

Regards,
Keith.
 
Back
Top