diferents user/pass for diferents Access BBDD

[emilio]

Hello!
The first sorry for my english.

I have same access 2007 BBDD in my computer, but I only want to have
security to one. If I make users\groups\passw in my system.mdw this are maked
for all my BBDD and I wont make only for one. Is possible??

thanks evrybody

 

[Tom van Stiphout]

On Fri, 21 Aug 2009 02:17:01 -0700, emilio

You are correct: this WOULD apply security to all of them. So you
follow the steps in the Access Security FAQ you can download from
microsoft.com and you leave your system.mdw file alone, and create a
new workgroup file just for this one database. Then you create a
shortcut to run this database, using the /wrkgrp switch to point to
your new .mdw

-Tom.
Microsoft Access MVP