Re: Workgroup file for one db only (not to apply to other dbs)

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

Well, there is, you can either add a right click regsetting 'Open secure' or
make a custom file extension
But I agree with Rick that for most intents or purposes you should use a
shortcut to open the secure mdb
By using vbScript & wshshell it's fairly easy to autocreate one

This demonstrates it used in VBA for a Access '97 installation

Sub wsh()
Dim wsh As New IWshRuntimeLibrary.WshShell
Dim shC As IWshRuntimeLibrary.WshShortcut
Dim AppExe As String

' Set WsH = WScript.CreateObject("WScript.Shell")
AppExe =
Wsh.RegRead("HKCR\CLSID\{8CC49940-3146-11CF-97A1-00AA00424A9F}\LocalServer32\")
' "C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"

Set shC = wsh.CreateShortcut("C:\Temp\Test.lnk")
shC.TargetPath = AppExe
shC.Arguments = """C:\MyApp\MyApp.mdb"" /WrkGrp""C:\MyApp\secure.mdw"""
shC.Description = "My Application"
shC.WorkingDirectory = "C:\MyApp"
shC.Save
End Sub


Pieter


"Rick Brandt" <rickbrandt2@xxxxxxxxxxx> wrote in message
news:6okFi.33308$RX.15713@xxxxxxxxxxxxxxxxxxxxxxxxxxxxx
"Deirdre" <Deirdre@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:4DF39FF2-CC20-483C-8A7E-67CB8C9A6499@xxxxxxxxxxxxxxxx
I use several databases on various work servers (some I own/manage others
I
just use). Until now, we relied on folder security.
I just had to create a new db with user-level security. If I join the
workgroup for the secure db I set up I can access the db with userid and
password. But when I try to access the other db's I am also prompted for
a
userid and password now. I can use a shortcut (and remain on system.mdw)
and not have the security follow on to the other db's.
Any other way around this? I only want the secure.mdw to apply to the
one
db. I will have multiple users and don't want them to have to join a
workgroup file or have to use a shortcut either as their ms access
folders
are often different (office 10 vs office 11). I don't really want to
have to
create different shortcuts on the basis of their access folders.

You either join the workgroup (and are always prompted) or you use a
shortcut. There is not a third alternative.

--
Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com





.

Relevant Pages

  • Re: more than one db -one without security one with security
    ... You do not need to join your secure.mdw if the shortcut includes it. ... Rick B ... > Then setup secure icon pointing to the secure mdw and use it instead of ... Next time they open a database it will use whatever ...
    (microsoft.public.access.security)
  • Re: Lost ability to login to secure database
    ... It sounds like you still have your secure mdb and you still ... have your secure mdw. ... You just deleted the shortcut. ... First I moved the folder my database was in. ...
    (microsoft.public.access.security)
  • Re: security only works on my PC
    ... shortcut successfully on my PC. ... Just open Windows Explorer and double click the 'secure' mdb. ... I opened the workgroup administrator ... I'm not sure about changing the permissions. ...
    (microsoft.public.access.security)
  • Re: Permission changes from computer to computer
    ... Create your shortcut to the file. ... "Rick B" wrote: ... > Do I (as administrator) set this up for all the users or do they have to ... >> workgroup in which you created your passwords. ...
    (microsoft.public.access.security)
  • Re: logging in to an access db
    ... Just because you're using a shortcut and getting a login prompt, ... mean your mdb is secure. ... Your first post said that you were able to open it ...
    (microsoft.public.access.security)