Starting with command line args for work group file

[JB]

Back in the days of NT4 everything went ok
But now with windows xp and office 2002, the folloing wont work for
me.

I wish to start access with arguments for work group file and what
user is default.
I made a bat file with this
START /MAX %ACCESS% %MDB% /wrkgrp %MDW% /user SA /Excl

that one does not work, but if I remove START /MAX and just run
%ACCESS% %MDB% /wrkgrp %MDW% /user SA /Excl
it works just fine, nut I need the "START" so that the bat file can
drop dead after my access app is started.

Is there a way to replace the bat file with extra arguments in a
regular shortcut to my access db? Tried it but unsuccessfuly.

If so, is it possible to do even for shortcuts to tables, reports and
so on?

 

[Van T. Dinh]

1. I think the difference is that old Windows (NT4,
W98??? and earlier) still have actual DOS but *actual* DOS
disappeared in later version and you only get
the "simulated" DOS (not "The Real Thing" <smile>).

2. However, it looks like you you should be able to
replace with a shortcut icon using the startup command-
line options for everything you wrote. The format of the
command should be something like:

FullPathNameForMSAccess.exe FullPathNameToMDBFile /excl
/use ... /pwd ... /wrkgrp ...

Note that you need the FULL PathName of MSAccess.exe. If
you have spaces or special characters in the pathnames
(MSAcess.exe or the database file), you need to enclose
the pathnames in Double-Quotes.

Check Access Help topic "Startup Command-Line Options".

3. FWIW, you can create shortcut icons to (the
DatasheetView) of a Table or a Report. Simply drag the
icon from the Database Containers window to your Desktop
and Access (Windows?) will create the shortcut icon for
you. I don't think the options are attached to these
icons. If you need the options, use (2) above and use
the "Startup Options ..." in the MenuBar or create an
Macro to open your Table or Report on start-up.

HTH
Van T. Dinh
MVP (Access)