Start MSAccess in a Shell without starting any DBobj?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ariadne - 25 Nov 2004 16:07 GMT

Hi
is it possible to start MSAccess from a shell with a selected Database,
but without Start of any DB object like StartupForm or autoexec?
Thanks
Ariadne

Reply to this Message

Alex Dybenko - 25 Nov 2004 17:50 GMT

yes, if you hold Shift key during access start

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

> Hi
> is it possible to start MSAccess from a shell with a selected Database,
> but without Start of any DB object like StartupForm or autoexec?
> Thanks
> Ariadne

Reply to this Message

Ariadne - 26 Nov 2004 13:49 GMT

> yes, if you hold Shift key during access start

Yes, but my Question is: If I start a Shell - there I am not able to
hold the Shift key - is there a way to start MSAccess with the same result.

Reply to this Message

Alex Dybenko - 26 Nov 2004 18:17 GMT

i see. Not sure this is possible from shell

Signature

Alex Dybenko (MVP)
http://Alex.Dybenko.com
http://www.PointLtd.com

>> yes, if you hold Shift key during access start
>>
> Yes, but my Question is: If I start a Shell - there I am not able to hold
> the Shift key - is there a way to start MSAccess with the same result.

Reply to this Message

H - 26 Nov 2004 21:34 GMT

> i see. Not sure this is possible from shell

I'm afraid too...
Perhaps you have a better approach? This is what I want:
Open a Database from VisualBasic, so that
Set gAcc=GetObject(sFile)
is possible. If the DB has a password and perhaps is connected to a
wrkgrp, I have to start a MSAccess instance with these parameters (via
CreateProcessA), but if I do so, the startup-Objects will start also. I
want to do a readonly-access for an Inspection and dislike, if I start
any procedure or object in the DB.
Ariadne

Reply to this Message

Douglas J. Steele - 26 Nov 2004 22:02 GMT

Take a look at http://support.microsoft.com/?id=210111

While it's ugly, there's a section half-way down entitled "Bypassing Startup
Settings When Opening a Database". It uses SendKeys to simulate holding down
the SHIFT key when opening the database:

Dim objAccess as Object
Set objAccess = CreateObject("Access.Application")
ShowAccess instance:=objAccess, size:=SW_MAXIMIZE
SendKeys "+"
'Simulates holding down the SHIFT key as the database is being opened
objAccess.OpenCurrentDatabase filepath:= _
"C:\Program Files\Microsoft Office\Office\Samples\Northwind.mdb"

Use at your own risk: SendKeys is not the most robust approach!

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> > i see. Not sure this is possible from shell
> >
[quoted text clipped - 8 lines]
> any procedure or object in the DB.
> Ariadne

Reply to this Message