Is bypass (shift) key functionality from command line possible?

[Joshua Ammann]

I've searched for this and haven't found the answer yet, so here
goes. I'm using multiple versions of Access, all 2000 or later. Is
there a command line switch that will produce the same result as
opening the file in Windows while holding down the bypass (shift) key?

I have GoToMyPC set up on a client's computer, and when accessing it
through my Pocket PC I am unable to transmit the holding of the shift
key while opening the database. If there were a command line switch I
could use that to open the database without the restrictions imposed by
the Tools->Startup screen.

Thanks,

Joshua Ammann

[Larry Linson]

I suggest you include an obscure "backdoor" to design view... some
unintuitive graphic or text that accepts a Click and executes code to show
the database window, for example.

Larry Linson
Microsoft Access MVP

"Joshua Ammann" <jo****@ammann.com> wrote in message
news:11**********************@z34g2000cwc.googlegr oups.com...

I've searched for this and haven't found the answer yet, so here
goes. I'm using multiple versions of Access, all 2000 or later. Is
there a command line switch that will produce the same result as
opening the file in Windows while holding down the bypass (shift) key?

I have GoToMyPC set up on a client's computer, and when accessing it
through my Pocket PC I am unable to transmit the holding of the shift
key while opening the database. If there were a command line switch I
could use that to open the database without the restrictions imposed by
the Tools->Startup screen.

Thanks,

Joshua Ammann

[Joshua Ammann]

Thanks Larry.

I already have a button to show the db window, but without the bypass
key I don't have access to the full set of menu bar options (File -
Edit, etc.).

It's not a big problem for this particular application, since most of
the default menus are available anyway. I was asking primarily for
future reference, in case I ever need it on a database I didn't design
(no "back door") or one with more signifigant restrictions on the menu
bar choices.

Anyone have any other ideas on bypassing startup options without a
keyboard shortcut?

Joshua Ammann

[bruce]

There is no way to do this from the command line. What you might be
able to do is create a 'starter' application that starts the first one
and install that on the client machine. Then you could use your pocket
pc to start the 'starter' application which would in turn start the
main application while simulating a depressed shift key. The code at
http://www.mvps.org/access/api/api0068.htm uses automation to run an
access app bypassing startup. Your 'starter' application could use
this code along with something like the following to invoke it:

Sub StartWithShift(strMyApp as String)

Static app As Access.Application

Set app = fGetRefNoAutoexec(strMyApp)

End Sub

With this approach, your application will start in a separate window
via automation as though you had depressed the shift key and will live
until you close it manually or until you close your 'starter'
application.

HTH,
Bruce