<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=us-ascii">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR>
<STYLE>
<!--
/* Font Definitions */
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
a:link, span.MsoHyperlink
{color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{color:purple;
text-decoration:underline;}
p.MsoAutoSig, li.MsoAutoSig, div.MsoAutoSig
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman";}
span.EmailStyle17
{font-family:Tahoma;
color:windowtext;
font-weight:normal;
font-style:normal;
text-decoration:none none;}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;}
div.Section1
{page:Section1;}
-->
</STYLE>
</HEAD>
<BODY lang=EN-US vLink=purple link=blue>
<DIV><SPAN class=421120319-19032003><FONT face=Arial color=#0000ff
size=2>Yupz.... using dao it looks like this:</FONT></SPAN></DIV>
<DIV><SPAN class=421120319-19032003></SPAN> </DIV>
<DIV><SPAN class=421120319-19032003><FONT face=Arial color=#0000ff size=2>dim db
as dao.database,<SPAN class=421120319-19032003><FONT face=Arial color=#0000ff
size=2> tbl as dao.tabledef</FONT></SPAN></FONT></SPAN></DIV>
<DIV><SPAN class=421120319-19032003></SPAN> </DIV>
<DIV><SPAN class=421120319-19032003> <FONT face=Arial
color=#0000ff size=2>set db=currentdb</FONT></SPAN></DIV>
<DIV><SPAN class=421120319-19032003><FONT face=Arial color=#0000ff
size=2> for each tbl in db.tabledefs</FONT></SPAN></DIV>
<DIV><SPAN class=421120319-19032003></SPAN><SPAN class=421120319-19032003><FONT
face=Arial color=#0000ff size=2> if
tbl.name="yourtable" then "found"</FONT></SPAN></DIV>
<DIV><SPAN class=421120319-19032003><FONT face=Arial color=#0000ff
size=2> next tbl</FONT></SPAN></DIV>
<DIV><SPAN class=421120319-19032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=421120319-19032003><FONT face=Arial color=#0000ff size=2>set
db=nothing</FONT></SPAN></DIV>
<DIV><SPAN class=421120319-19032003><FONT face=Arial color=#0000ff size=2>set
tbl=nothing</FONT></SPAN></DIV>
<DIV><SPAN class=421120319-19032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=421120319-19032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=421120319-19032003><FONT face=Arial color=#0000ff size=2>Have
fun!</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>
accessd-admin@databaseadvisors.com
[mailto:accessd-admin@databaseadvisors.com]<B>On Behalf Of </B>Mark
Boyd<BR><B>Sent:</B> woensdag 19 maart 2003 18:48 <BR><B>To:</B>
AccessD@databaseadvisors.com<BR><B>Subject:</B> [AccessD] Does table
exist?<BR><BR></FONT></DIV>
<DIV class=Section1>
<P class=MsoNormal><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Is there code to find out if an
Access table exists in the database?</SPAN></FONT></P>
<P class=MsoNormal><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma"></SPAN></FONT> </P>
<P class=MsoNormal><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">TIA,</SPAN></FONT></P>
<P class=MsoAutoSig><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Mark Boyd</SPAN></FONT></P>
<P class=MsoAutoSig><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">Sr. Systems
Analyst</SPAN></FONT></P>
<P class=MsoAutoSig><FONT face=Tahoma size=2><SPAN
style="FONT-SIZE: 10pt; FONT-FAMILY: Tahoma">McBee Associates,
Inc.</SPAN></FONT></P>
<P class=MsoNormal><FONT face="Times New Roman" size=3><SPAN
style="FONT-SIZE: 12pt"></SPAN></FONT> </P></DIV></BLOCKQUOTE></BODY></HTML>
<html>
<BR><BR>
<TABLE width=400><HR>
<P style="FONT: 9pt/11pt verdana"><a href="http://www.avast.com">avast! Antivirus</a>: Outbound message clean.
<P style="FONT: 8pt/11pt verdana">Virus Database (VPS): 19-3-2003<BR>Tested on: 19-3-2003 20:06:03<BR><FONT color=gray>avast! is copyright (c) 2000-2003 ALWIL Software.</FONT></P>
<TBODY></TBODY></TABLE>
<BR></html>