Try using the system tables. SELECT count(name) as thecount FROM MSysObjects where name = 'yourTableName';
Good luck, Matthew >From: "Susan Hamilton Allen" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: SQL <[EMAIL PROTECTED]> >Subject: Re: (SOT) Compacting Access db's and performance issues >Date: Mon, 24 Jun 2002 17:17:42 -0400 > >I am writing a VB app connected to an Access database; I need to check for >the existence of a table in the database, and if it exists, copy the data >(select into) to another table and delete it (drop). The only problem I'm >having is how to check for the existence of the table in the first place. >Any suggestions? Tia, > >Susan H. Allen >Web Developer >Pfingsten Publishing, L.L.C. >Cleveland, Ohio >[EMAIL PROTECTED] > > ______________________________________________________________________ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
