<!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=907531500-18062003><FONT face=Arial color=#0000ff size=2>It was
only happening on W2k machines, but there was another quirk. It was
occurring on a database that people were opening a link to from an intranet
page. They were getting the Open From location or Save options. The
Open option was opening to instances of the database, the first 'locked', the
second got the error. When I switched the code, the first still locked,
but the second opened. When the second instance was closed by the user,
the first instance closed too. It was wierd.</FONT></SPAN></DIV>
<DIV><SPAN class=907531500-18062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=907531500-18062003><FONT face=Arial color=#0000ff size=2>I do
know that Jet 3.51 has a quirk in MDAC 2.5 (and I think up to 2.7), I always use
Jet 4.0, but that's with ADO, not DAO.</FONT></SPAN></DIV>
<DIV><SPAN class=907531500-18062003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=907531500-18062003><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> Rocky Smolin - Beach Access
Software [mailto:bchacc@san.rr.com]<BR><B>Sent:</B> Tuesday, June 17, 2003
6:58 PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> Re:
[AccessD] access97 application on win2000<BR><BR></FONT></DIV>
<DIV><FONT face=Arial size=2>Rats. I would hate to do that because I've
moved the app to A2K and they're still on A97. Was the problem
associated with W2K?</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>Rocky</FONT></DIV>
<DIV> </DIV>
<BLOCKQUOTE
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
<DIV style="FONT: 10pt arial">----- Original Message ----- </DIV>
<DIV
style="BACKGROUND: #e4e4e4; FONT: 10pt arial; font-color: black"><B>From:</B>
<A title=DWUTKA@marlow.com href="mailto:DWUTKA@marlow.com">Drew Wutka</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>To:</B> <A
title=accessd@databaseadvisors.com
href="mailto:'accessd@databaseadvisors.com'">'accessd@databaseadvisors.com'</A>
</DIV>
<DIV style="FONT: 10pt arial"><B>Sent:</B> Tuesday, June 17, 2003 1:22
PM</DIV>
<DIV style="FONT: 10pt arial"><B>Subject:</B> RE: [AccessD] access97
application on win2000</DIV>
<DIV><BR></DIV>
<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>
<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>