How to test if the table already exist using VBS

		Home \| Contact Us \| FAQ \| Search & Site Map \| Link to Us
		Sign In \| Join \| Other 45 Sites in Network

Discussion Groups Forms Forms Programming Queries Modules / DAO / VBA Reports / Printing Macros Database Design Security Conversion Importing / Linking SQL Server / ADP Multiuser / Networking Replication Setup / Configuration Developer Toolkits ActiveX Controls New Users General 1 General 2

Access Directory Tools Tutorials User Groups

Related Topics

SQL Server Other DB Products MS Office More Topics ...

MS Access Forum / New Users / April 2005

How to test if the table already exist using VBS

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Carlos Garcia - 11 Apr 2005 17:26 GMT

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.

Reply to this Message

Ofer - 12 Apr 2005 07:02 GMT

You can check in the MSysObjects Table, with a simple
dlookup("Name","MSysObjects","Name='" & MyTableName & "'")

>-----Original Message-----
>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.

Reply to this Message

Sign In

Join

My Latest Posts

My Monitored Threads

My Photo Gallery

My Homepage

Start New Thread

Enable EMail Alerts

Rate this Thread

©2008 Advenet LLC Privacy Policy - Terms of Use

This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.