Opening a Secured Database

[timekeepumd]

Hello,

I am running Access 2000 and have 2 databases. From database 1 I need to open database 2. The problem is that I set up user level security using the Access wizard so I have a workgroup file that must be used to open the database which creates a shortcut to the database that looks like it routes itself through the workgroup file. I have included the shortcut target code below but have been unsuccessful in including it in either an Access hyperlink or in VB code using the onClick() function.

"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "T:\shr\Tool Order Management\Backup\Tool Database.mdb" /WRKGRP "T:\shr\Tool Order Management\Backup\Secured.mdw"

Any help?

Thanks

[Rabbit]

Call Shell("""C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"" ""T:\shr\Tool Order Management\Backup\Tool Database.mdb"" /WRKGRP ""T:\shr\Tool Order Management\Backup\Secured.mdw""")
 

[timekeepumd]

Call Shell("""C:\Program Files\Microsoft Office\Office\MSACCESS.EXE"" ""T:\shr\Tool Order Management\Backup\Tool Database.mdb"" /WRKGRP ""T:\shr\Tool Order Management\Backup\Secured.mdw""")
 

Thanks much. The code worked like a charm.

[Rabbit]

Not a problem. Good luck.