[AccessD] Does table exist?

StaRKeY StaRKeY at Wanadoo.nl
Wed Mar 19 13:15:47 CST 2003


Yupz.... using dao it looks like this:

dim db as dao.database, tbl as dao.tabledef

    set db=currentdb
    for each tbl in db.tabledefs
        if tbl.name="yourtable" then "found"
    next tbl

set db=nothing
set tbl=nothing


Have fun!
  -----Original Message-----
  From: accessd-admin at databaseadvisors.com
[mailto:accessd-admin at databaseadvisors.com]On Behalf Of Mark Boyd
  Sent: woensdag 19 maart 2003 18:48
  To: AccessD at databaseadvisors.com
  Subject: [AccessD] Does table exist?


  Is there code to find out if an Access table exists in the database?



  TIA,

  Mark Boyd

  Sr. Systems Analyst

  McBee Associates, Inc.


-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://databaseadvisors.com/pipermail/accessd/attachments/20030319/9cbebd89/attachment-0001.html>


More information about the AccessD mailing list