trouble with command line options and starting access

[romanzero]

Hi,

I am trying to upgrade the security on a multi-user database located on a network.

I have utilized the Access user level security. Every group's permissions have been assigned.

What I need to do is to have my users enter the db via a shortcut that will take them to the necessary mdw file - assign their permissions -and then send them to the front end db.

This is the command line that I have written in the shortcut. It gives me an error.

"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "K:\Data Files\DB_FE_test_folder\TEST_FE.mdb" "K:\Data Files\DB_WKGRP_test_folder\Database.mdw"

Ideally I would like to have the user name and password automatically assigned, but I can never get that to work either, although I have read several threads where those were written into the command line.

Any help would be greatly appreciated.

 

[PHV]

C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "K:\Data Files\DB_FE_test_folder\TEST_FE.mdb" [!]/wrkgrp [/!] "K:\Data Files\DB_WKGRP_test_folder\Database.mdw" /user UserName /pwd Password

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[romanzero]

Fantastic!!!

I knew it must be something easy.

Thanks for your help PHV!!!