<div>
the things is that the access application now uses the workgroup file you created when securing the database as the default workgroup file. &nbsp;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.<br />
<br />
then, you open the workgroup manager (normally it's here: C:\Program Files\Microsoft Office\Office\1033\WRKGADM<wbr />.EXE), click &quot;join&quot; and select the default database (usually C:\Program Files\Common Files\System\SYSTEM.MDW). &nbsp;from then on, access will not ask you for passwords anymore for unsecured databases.<br />
<br />
<br />
--bluelizard<br />

</div>


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


<div>
<div class="content wysiwyg-content">
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?
</div>
</div>


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?

Unsecure a secured Access database

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.