I know how to do this with MSSQL but not access...sorry! -----Original Message----- From: Susan Hamilton Allen [mailto:[EMAIL PROTECTED]] Sent: Monday, June 24, 2002 4:18 PM To: SQL Subject: Re: (SOT) Compacting Access db's and performance issues
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] ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
