What is /mbihap? I think what you want there is /wrkgrp.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security:
www.ltcomputerdesigns.com/Security.htm
Jeff Conrad's Big List:
www.ltcomputerdesigns.com/JCReferences.html
Hi Again,
I'm almost there.
I created a shortcut to MSaccess.exe as the following
Target:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" /mbihap
"G:\IS\App
Dev & Bus Support\MBI\MBI Shared\Form\SYSTEM.MDW"
"G:\IS\App Dev & Bus Support\MBI\MBI Shared\Form\mbi.mdb"
Start in:
"C:\Program Files\Microsoft Office\Office"
I got the error "The command line you used to start Microsoft Access
contains an option tha Microsoft Access doesn't recognize. Exit &
Restart
Microsoft Assess using valid command line options. I click ok 7 times
and
it
takes me to the .mdw file.
So I went to another post on 04/21/05 - Subject: Workgroup File where
the
syntax was described as
"Full path to MSAccess.exe" "path to mdb" /wrkgrp "path to mdw"
Here is the result:
Target:
"C:\Program Files\Microsoft Office\Office\MSACCESS.EXE" "G:\IS\App Dev
&
Bus Support\MBI\MBI Shared\Form\mbi.mdb" /mbihap "G:\IS\App Dev & Bus
Support\MBI\MBI Shared\Form\SYSTEM.MDW"
Start in:
"C:\Program Files\Microsoft Office\Office"
I got the same error, clicked ok 7 times and it took me to the mdb.
I changed the start in on both of them to
G:\IS\App Dev & Bus Support\MBI\MBI Shared\Form"
and still got the same error with the shortcut taking me either to the
db
or
the mdw file which ever was first after the .exe file.
What am I doing wrong?
Thanks for your time!
:
Thanks tons!
I'll be in touch!
:
anoyse wrote:
I understand. She tried it and it still won't let her in.
What Rick posted about the mdw having a password on the Admin user
is
correct.
I'm trying to create the shortcut (using the correct mdw) because
I
don't want to have to go from workstation to workstation to try to
get this stuff to work. Rick was kind enough to give me the syntax
for the shortcut however I don't know where I (or how to) actually
create it in Access. Is there a window I need to go to? [snip]
You don't create the shortcut in Access. A Windows shortcut is a
Windows
object that you create in Windows. Right-Click the desktop - New -
Shortcut.
or...
Find MSAccess.exe and drag with the right mouse button to the
desktop
and
choose "Create Shortcut Here". That will give you a head start as
the
icon
will already be correct and the target will already have the
MSAccess.exe
portion filled in. All you have to do is add the rest.