import all object including user level security

  • Thread starter Peter van den Hooff
  • Start date

Peter van den Hooff

Our user level secured ms-access 2K frontend is used by two groups of
users, one group having the frond-end on local c-drives and one group
running the front-end on a shared network drive.
Only the latter group is sometimes facing errors clearly related to
something we cannot understand (e.g. the vba command label.caption =
"hello world")

The database can be compiled without errors, a mde can be made.

We saw only one solution: creating a new MDB and import all objects.
This new frond-end works without errors, however the extensive
securitysettings are messed up

Pleace advice how to correctly import / copy and paste the security


Peter vd H

Peter van den Hooff

Peter van den Hooff wrote:

Why do some users execute the app from the C: drive and others from the
network?  Are 2 or more users sharing the same computer somehow?  Do
some users have rights to the C: drive and others are locked out out of C:?

What do you not understand in my question:
Please advice how to correctly import the security settings ??

To answer yours, we are talking about a big hospital environment where
different departments / sections have different network solutions.

Joan Wild

Security settings are never carried with an object on import (they
instead get the permissions set on <New Object> for each type.

To answer your question, you can use Jeff Conrad's utility to copy the
permissions from one database to another.

First item at

Joan Wild

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