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 & "'")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to copy and paste only visible cells from Excel using vbscript 0
Excel VBS script to prevent Excel prompt 0
How to call a Query with Parameters in VBS 1
fire a VBS from ASP.NET 4
vbs script wshshell.exe error 0
How to find Minimum of four fields 11
How to Pass a Parm from VBS script to Access 2007 17
Access How to check that the value of a field in a new record is not present in 2 fields of the table? 0

Back
Top