How to test if the table already exist using VBS

  • Thread starter Thread starter Carlos Garcia via AccessMonster.com
  • Start date Start date
C

Carlos Garcia via AccessMonster.com

Hello,

I'm looking for a sub fuction to test if a table already exist in a
database using VBS, before I execute the function creatobject. Thanks.
 
You can check in the MSysObjects Table, with a simple
dlookup("Name","MSysObjects","Name='" & MyTableName & "'")
 
Back
Top