Applying security on Access Templates

[Nida]

Hi i want to use the Inventory management database template from access 2007.
i'll be adding transaction into it thats is the purchase orders are entered
by people from procurement and then the transaction into the inventory are
done by warehouse. the databse will be shared on the netwrok. i'll make the
releveant forms and procedrues for this db but is there a way to provide user
level security so that the forms of procurement are not visible to warehouse
and vice versa.

 

[Arvin Meyer [MVP]]

In order to apply security to an Access 2007 Template, you must convert it
to an MDB. It may break certain macros, which will need to be rewritten as
VBA code. User level security is only available with MDB's.