Re: Access 2002 command line options.

From: Van T. Dinh (VanThien.Dinh_at_discussions.microsoft.com)
Date: 07/20/04 

Date: Tue, 20 Jul 2004 20:49:51 +1000

For the /runtime switch, see MSKB:

http://support.microsoft.com/?id=105128

I am fairly sure the /runtime switch (or /rt) also works with the retail
version also as I used then where I worked previously and I am sure the
company didn't have the ODE97.

I can't be certain but at the time, I didn't know the MSKB existed so my
source of info. didn't come from MSKB and really the only Access references
I had at that time was Roger Jennings' Using Access 97 & Access Help and
Roger Jennings' book didn't mention about the /runtime switch. 

-- 
Cheers
Van T. Dinh
MVP (Access)
"Chris Mills" <phad_nospam@cleardotnet.nz> wrote in message
news:%23jDOszjbEHA.3944@tk2msftngp13.phx.gbl...
> > IIRC, I found the switch /runtime in A97.
>
> A97 Help: Search for runtime in this verbatim?
> -----
> Startup command-line options
>
> The following table lists the Microsoft Access command-line options.
>
> Option Effect
> database Opens the specified database. Include a path if necessary. The
> default path is your My Documents folder.
> /excl Opens the specified database for exclusive access. To open the
database
> for shared access in a multiuser environment, omit this option.
> /ro Opens the specified database for read-only access.
> /user user name Starts Microsoft Access using the specified user name.
> /pwd password Starts Microsoft Access using the specified password.
> /profile user profile Starts Microsoft Access using the options in the
> specified user profile instead of the standard Windows Registry settings
> created when you installed Microsoft Access. This replaces the /ini option
> used in previous versions of Microsoft Access to specify an initialization
> file. The Microsoft Office 97, Developer Edition, contains tools and
> information on creating user profiles. For more information, click  .
> /compact target database Compacts the database specified before the
/compact
> option and then closes Microsoft Access. If you omit a target database
name
> following the /compact option, the database is compacted to the original
> database name and folder. To compact to a different name, specify a target
> database. If you don't include a path in target database, the database is
> created in your My Documents folder by default.
> /repair Repairs the database specified before the /repair option and then
> closes Microsoft Access.
> /convert target database Converts a database in an earlier version (1.x or
> 2.0) to a Microsoft Access 95 database with a new name and then closes
> Microsoft Access. Specify the source database before the /convert option.
> /x macro Starts Microsoft Access and runs the specified macro. Another way
to
> run a macro when you open a database is to use an AutoExec macro.
> /cmd Specifies that what follows on the command line is the value that
will be
> returned by the Command function. This option must be the last option on
the
> command line. You can use a semicolon (;) as an alternative to /cmd.For
> information on the Command function, click  .
> /nostartup Starts Microsoft Access without displaying the startup dialog
box
> (the second dialog box you see when you start Microsoft Access).
> /wrkgrp workgroup
> information file Starts Microsoft Access using the specified workgroup
> information file.
> Notes
>
> · To run a Visual Basic for Applications procedure when you open a
database,
> use the RunCode action in a command-line macro or the AutoExec macro. You
can
> also run a Visual Basic procedure when you open a database by creating a
form
> with a Visual Basic procedure defined for its OnOpen event. Designate this
as
> the startup form by right-clicking the database window, clicking Startup,
and
> then entering that form in the Display Form box.
> · To specify a forward slash (/) or semicolon (;) on the command line,
type
> the character twice. For example, to specify the password ;mjs/md on the
> command line, type ;;mjs//md following the /pwd command-line option.
>
>

Relevant Pages

  • Re: Access 2002 command line options.
    ... The following table lists the Microsoft Access command-line options. ... database Opens the specified database. ... To compact to a different name, specify a target ... returned by the Command function. ...
    (microsoft.public.access.developers.toolkitode)
  • Re: Simple VBA code to open other access database
    ... You can use this method to open a database from another application that is ... controlling Microsoft Access through Automation, ... the Microsoft Access window, you can use the CloseCurrentDatabase method to ... The OpenCurrentDatabase method opens a database in the Microsoft ...
    (microsoft.public.access.forms)
  • Re: Converting from Access 2000 to Access 2002
    ... If you can still open these forms in design view and view their code window, ... then close this database, and open the new one that lacks the code. ... with the message "Microsoft Access has encountered a problem..." ... converted database, it initially opens but, when I try to use it, I ...
    (microsoft.public.access.conversion)
  • Re: Converting from Access 2000 to Access 2002
    ... I wonder how Access 2002 got through the beta program with such a ... then close this database, and open the new one that lacks the code. ... with the message "Microsoft Access has encountered a problem..." ... converted database, it initially opens but, when I try to use it, I ...
    (microsoft.public.access.conversion)
  • Re: Problems
    ... You don't specify whether this is a split db or not, ... > I'm having loads of problems with our 15 MB database. ... Stored on a Server ... You or another user may have unexpectedly quit Microsoft Access ...
    (microsoft.public.access.queries)