<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>Access VB question</TITLE>
<META content="MSHTML 6.00.2722.900" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=639132823-02052003><FONT face=Arial color=#0000ff size=2>I
didn't write the original post, but it said the issue was opening an instance of
Access, with VB/VBA, and then opening a database, without the startup
running.</FONT></SPAN></DIV>
<DIV><SPAN class=639132823-02052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=639132823-02052003><FONT face=Arial color=#0000ff size=2>As far
as I know, there are only two ways to do this. One method is to disable
the startup from with the database itself. ie, have it look for a specific
flag in a record, or have it check for a specific command line argument, so that
when it starts, the startup code checks that 'trigger', and then
stops...effectively 'bypassing' the startup stuff. The other method is to
actually open the database and use a 'sendkeys' approach to have the shift key
held when the code opens the database. </FONT></SPAN></DIV>
<DIV><SPAN class=639132823-02052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=639132823-02052003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Susan Harkins
[mailto:harkins@iglou.com]<BR><B>Sent:</B> Friday, May 02, 2003 6:21
PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re: [AccessD]
Access VB question<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>I know, but without giving it too much thought, I
thought it might be a place to start -- don't really know what the real
problem is. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Susan H. </FONT></DIV>
<DIV><FONT face=Arial size=2></FONT><BR> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV><SPAN class=768500523-02052003><FONT face=Arial color=#0000ff
size=2>Yes, but that only sets whether the shift key bypasses the startup or
not. It doesn't actually trigger it.</FONT></SPAN></DIV>
<DIV><SPAN class=768500523-02052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=768500523-02052003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Susan Harkins
[mailto:harkins@iglou.com]<BR><B>Sent:</B> Friday, May 02, 2003 5:27
PM<BR><B>To:</B> <A
href="mailto:accessd@databaseadvisors.com">accessd@databaseadvisors.com</A><BR><B>Subject:</B>
Re: [AccessD] Access VB question<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>If you could someone set the Access database
setting the AllowBypassKey property before you try to open it in VB? Do
you have to disable it from inside VB?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Susan H. </FONT><BR></DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV><SPAN class=941041722-02052003><FONT face=Arial color=#0000ff
size=2>I may be mistaken, but nothing in that code bypasses the startup
stuff. </FONT></SPAN></DIV>
<DIV><SPAN class=941041722-02052003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=941041722-02052003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2><BR></FONT> </DIV>
<BLOCKQUOTE>
<P><FONT face=Arial size=2>Does anyone know how to programmatically
open an access database in VB, bypassing the startup options?
</FONT></P></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE></BLOCKQUOTE>
<P>
<HR>
<P></P>_______________________________________________<BR>AccessD mailing
list<BR>AccessD@databaseadvisors.com<BR>http://databaseadvisors.com/mailman/listinfo/accessd<BR>Website:
http://www.databaseadvisors.com<BR></BLOCKQUOTE></BLOCKQUOTE></BODY></HTML>