• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 688
  • Last Modified:

Unsecure a secured Access database

I used user level security wizard to secure one database which is accessed by several users over the network. Problem is that all the other unsecured Access databases on the network drive are now asking for passwords. What could be the problem? Even the backup database is also asking for a password. Can i unsecure the database - how best can i solve this problem?
0
hchibuda
Asked:
hchibuda
  • 2
1 Solution
 
bluelizardCommented:
the things is that the access application now uses the workgroup file you created when securing the database as the default workgroup file.  what you need to do is store your workgroup file in a specific place and open the secure database with a shortcut that specifies the database *and* the workgrop file to use.

then, you open the workgroup manager (normally it's here: C:\Program Files\Microsoft Office\Office\1033\WRKGADM.EXE), click "join" and select the default database (usually C:\Program Files\Common Files\System\SYSTEM.MDW).  from then on, access will not ask you for passwords anymore for unsecured databases.


--bluelizard
0
 
bluelizardCommented:
btw: the syntax for "target" in the shortcut to open the secured database is the following:

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /WRKGRP "C:\path\to\myworkgroup.mdw" "C:\path\to\mydatabase.mdb"


--bluelizard
0

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now