<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1106" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=788074317-05062003><FONT face=Arial color=#0000ff size=2>Found
solution in knowledge base article 181542. DAO library must have higher priority
than ADO library.</FONT></SPAN></DIV>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Wortz, Charles
[mailto:CWortz@tea.state.tx.us] <BR><B>Sent:</B> Thursday, June 05, 2003 11:35
AM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> RE: [AccessD]
Cannot open table in code<BR><BR></FONT></DIV>
<DIV><SPAN class=557373116-05062003><FONT color=#0000ff
size=2>Chester,</FONT></SPAN></DIV>
<DIV><SPAN class=557373116-05062003><FONT color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=557373116-05062003><FONT color=#0000ff size=2>If this is A97
code, then it should be okay if that really is the name of your table.
However, if this is running in A2K or higher, then you should specify
whether the objects are DAO or ADODB and use the appropriate
constants.</FONT></SPAN></DIV>
<DIV> </DIV><!-- Converted from text/rtf format -->
<P><SPAN lang=en-us><B><FONT color=#0000ff>Charles Wortz</FONT></B></SPAN>
<BR><SPAN lang=en-us><FONT color=#0000ff>Software Development
Division</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Texas Education
Agency</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>1701 N. Congress
Ave</FONT></SPAN> <BR><SPAN lang=en-us><FONT color=#0000ff>Austin, TX
78701-1494</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>512-463-9493</FONT></SPAN> <BR><SPAN lang=en-us><FONT
color=#0000ff>CWortz@tea.state.tx.us</FONT></SPAN> </P>
<DIV></DIV>
<DIV class=OutlookMessageHeader lang=en-us dir=ltr align=left><FONT face=Tahoma
size=2>-----Original Message-----<BR><B>From:</B> Kaup, Chester A
[mailto:kaupca@chevrontexaco.com] <BR><B>Sent:</B> Thursday 2003 Jun 05
11:21<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B> [AccessD]
Cannot open table in code<BR></FONT></DIV><!-- Converted from text/rtf format -->
<P><FONT face=Arial size=2>The following code will not open the table . Message
is type mismatch. Looks like code I have used before. Probably missing something
simple.</FONT></P>
<P><FONT face=Arial size=2>Function Add_or_Read_Record()</FONT> </P>
<P><FONT face=Arial size=2>Dim myds As Recordset, MyDB As Database</FONT>
<BR><FONT face=Arial size=2>Set MyDB = CurrentDb</FONT> <BR><FONT face=Arial
size=2>Set myds = MyDB.OpenRecordset("tbl Last Date in tbl_monthly_inputs",
dbOpenTable)</FONT> </P>
<P><FONT face=Arial size=2>End Function</FONT> </P>
<P><FONT face="Times New Roman" size=1>No trees were killed in the sending of
this message. However a large number of electrons were terribly
inconvenienced.</FONT><BR></P><BR></BODY></HTML>