Security schema and Split Database

[hstijnen]

Hi,
I've developed a database with lots of tables and forms. I've defined a
security schema with several groups and access rights per group.

Now I've split the database with the Splitter tool, and I see the .mdb with
the data has no security defined. What is the easiest way to maintain the
security on the data part?

Thanks for suggestions

Henk

 

[Keith Wilby]

Hi,
I've developed a database with lots of tables and forms. I've defined a
security schema with several groups and access rights per group.

Now I've split the database with the Splitter tool, and I see the .mdb
with
the data has no security defined. What is the easiest way to maintain the
security on the data part?

Thanks for suggestions

Henk

Open Access whilst joined to your secure workgroup. Open a new, empty
database file and import all of your tables into it.

Keith.
www.keithwilby.com

 

[Joan Wild]

You should have not used the splitter wizard, for this reason. You could
have split it manually; i.e. Copy your mdb. Open the original and delete
all objects except the tables/relationships. Open the copy and delete the
tables, and then use File, Get External Data, Link and browse to the
original file.

Since you've now split it, you can create a new database while joined to
your secure mdw file. Import all the objects from the mdb with the tables.
Proceed to remove permissions on all objects for the Users Group, and then
assign the necessary permissions to your groups (do this via the Tools,
Security, Permissions dialog).