Check if DB table exists with ASP
Printed From: Web Wiz Forums
Category: General Discussion
Forum Name: Classic ASP Discussion
Forum Description: Discussion on Active Server Pages (Classic ASP).
URL: https://forums.webwiz.net/forum_posts.asp?TID=14079
Printed Date: 30 March 2026 at 3:02pm
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Check if DB table exists with ASP
Posted By: bootcom
Subject: Check if DB table exists with ASP
Date Posted: 03 March 2005 at 4:24am
|
Not too sure on how to do this one so am asking for some advise.
Im creating an online skin editor MOD for the forums and I just need to know how to check if an access database table exists before doing any inserting. Cheers
|
Replies:
Posted By: michael
Date Posted: 03 March 2005 at 9:22am
|
Just do a query like "Select Count(*) from MSysObjects where [name]='" & yourvalue & "' AND Type=1"
If it returns 0 then it does not exist if it's 1 it does, if it's 2, your database is likely to be corrupt  ------------- http://baumannphoto.com" rel="nofollow - Blog | http://mpgtracker.com" rel="nofollow - MPG Tracker |