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.

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.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.accessmvp.com
http://www.mvps.org/access


"Nida" <(E-Mail Removed)> wrote in message
news:F8735F06-713B-47DB-A17C-(E-Mail Removed)...
> 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.