secured db - HELP

  • Thread starter Thread starter dan
  • Start date Start date
D

dan

Hi,

i have secured my mdb using the access wiz.
Created users, groupes and delegations.

Plus, i have splitted my file, and all this to save the
file in a newtwork folder, to allow users the access.

but!, it saves a link to the original mdb, i can't move
it since i can't reach the place where the link is
defined...
how can i update it? how can i remove the security from
my mdb??
 
Hi Dan,

dan said:
i have secured my mdb using the access wiz.
Created users, groupes and delegations.

Plus, i have splitted my file, and all this to save the
file in a newtwork folder, to allow users the access.
Click to expand...

If you split it after securing it, the backend file will be completely
unsecure, just so you know.
but!, it saves a link to the original mdb, i can't move
it since i can't reach the place where the link is
defined...
how can i update it?
Click to expand...

Which link are you referring to? If you mean the desktop shortcut that the
wizard creates, just right click it and choose properties. You can modify
the target there.

If you mean the link to the backend tables, then open the frontend and go to
Tools, Database Utilities, Linked Table manager, select all the table links,
put a check in the 'always prompt for new location', and locate the backend
in its new location.

how can i remove the security from
my mdb??
Click to expand...

There are steps outlined in the security FAQ on how to do this.
http://support.microsoft.com/?kbid=207793

Essentially you log in as a member of the Admins group, give full
permissions for all objects (including the database object) to the Users
group. Exit Access, then reopen it using the standard system.mdw workgroup,
create a new database and import all objects from the old.
 
Back
Top