import all object including user level security

  • Thread starter Peter van den Hooff
  • Start date
P

Peter van den Hooff

Please advice:

We have a large office2003 ms-access database frontend on a server in
a hospital running more then 10 years.

'-- ------------------------------------
The user gets his local copy of the frontend on either a C-drive or on
a shared networkdrive.
A complex inbetween MDB does the job: relinking tables, setting
hyperlinkbase, reading security settings on a server MDW etc etc This
situation was stable for over a year.
'--
-----------------------------------------------------------------------------------------------------
However last weeks problems occur: some of the users on the shared
network drive can only open the local mdb for 1 or 2 times, thereafter
the database hangs on simple object.caption = "some text" actions
(the windows users do not experiance any problems)

The MsysObjectstable contains approx 6000 records

We decided to create a new frontend and import all objects. This
prevented the error messages.

However the securtiy settings ar messed up, HOW SHOULD WE IMPORT
CORRECTLY THE OLD SECURITY SETTINGS

Please advice
Peter
(> 10.000 hours ms-access VBA experience, however not to many hours on
security :)
 

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

Similar Threads

import all object including user level security 3
Security Access to a database 4
Wise to set up user level security for a multi FE MDB ?? 9
Table permissions when relinking table 2
TFS and user level rights in .mdb 4
Permissions / Closing MDB left open 1
User-Level Security 5
User Level Security 5

Top