<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=ISO-8859-1">
<META content="MSHTML 6.00.2722.900" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><SPAN class=557572020-17062003><FONT face=Arial color=#0000ff size=2>Yes,
don't create a variable to reference CurrentDB. Just use the CurrentDB
object. I had this happen to one of the databases (before my starting
here) that had an Access created switchboard. The switchboard code failed
on the set db=currentdb line, so I just removed db in all places and replaced it
with just CurrentDB. Worked great.</FONT></SPAN></DIV>
<DIV><SPAN class=557572020-17062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=557572020-17062003><FONT face=Arial color=#0000ff
size=2>Drew</FONT></SPAN></DIV>
<BLOCKQUOTE>
<DIV class=OutlookMessageHeader dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Rocky Smolin - Beach Access
Software [mailto:bchacc@san.rr.com]<BR><B>Sent:</B> Tuesday, June 17, 2003
2:12 PM<BR><B>To:</B> AccessD@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] access97 application on win2000<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Dear List:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Does anyone know the answer to this one?
</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>MTIA,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky Smolin<BR>Beach Access
Software</FONT></DIV>
<DIV> </DIV>
<DIV style="FONT: 10pt arial">----- Original Message -----
<DIV style="BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A
title=dmcdonald@trci.net href="mailto:dmcdonald@trci.net">Dave McDonald</A>
</DIV>
<DIV><B>To:</B> <A title=bchacc@san.rr.com
href="mailto:bchacc@san.rr.com">Rocky Smolin</A> </DIV>
<DIV><B>Sent:</B> Tuesday, June 17, 2003 11:56 AM</DIV>
<DIV><B>Subject:</B> Fw: access97 application on win2000</DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Rocky,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>I found some else with a similar
problem.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Dave</FONT></DIV>
<DIV style="FONT: 10pt arial">----- Original Message -----
<DIV style="BACKGROUND: #e4e4e4; font-color: black"><B>From:</B> <A
title=dmcdonald@trci.net href="mailto:dmcdonald@trci.net">Dave McDonald</A>
</DIV>
<DIV><B>To:</B> <A title=vescalera@apelcan.com
href="mailto:vescalera@apelcan.com">"Victor"</A> </DIV>
<DIV><B>Sent:</B> Tuesday, June 17, 2003 2:00 PM</DIV>
<DIV><B>Subject:</B> RE: access97 application on win2000</DIV></DIV>
<DIV><BR></DIV>
<DIV><FONT face=Arial size=2>Hello Victor,</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>If you ever get an answer, please pass it on to
me. I have the same problem, running Access97 in Windows2000.
Tried removing and re-installing Access and W2000. No help. I used
to get the "ActiveX component can't create object" (Error 429). Debug
would take me to the same location as you in the mdb , Set db As
database()</FONT></DIV>
<DIV><FONT face=Arial size=2>Set and rerun would not help.</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Now Access won't even open the mdb. I get a
message </FONT></DIV>
<DIV><FONT face=Arial size=2>"<process has already exited> has
generated errors and will be closed by Windows" which it
does. </FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Please pass any advice along to me.</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Thanks,</FONT></DIV>
<DIV> </DIV>
<DIV><FONT face=Arial size=2>Dave <A
href="mailto:dmcdonald@trci.net">dmcdonald@trci.net</A></FONT> </DIV><BR>-----Original
Message-----<BR>From: "Victor" <<A
href="mailto:vescalera@apelcan.com">vescalera@apelcan.com</A>><BR>Sent:
6/16/2003 1:00:44 PM<BR>Subject: access97 application on win2000<BR><BR>I have
an access97 application perfectly running on win95, win98 and winxp,<BR>but no
on win2000 (at least in the server edition).<BR>If I execute the application
on win2000, it spends several seconds (with an<BR>intensive use of the
hard disk) in the instruction:<BR><BR>set db= currentdb() 'db as an
object of the database.<BR><BR>.... and finally the application is
closed without messages.<BR><BR>In the original application I used DAO 3.51.
In win2000 DAO 3.6 is marked in<BR>references.<BR>I have installed the MDAC
2.7 but the problem is not removed.<BR><BR>How can I solve the
problem?<BR><BR>Thanks<BR>Victor<BR><BR><BR>.<BR></BLOCKQUOTE></BODY></HTML>