>In some VBScript code, I make an OLEDB connection to a database, and then drop a table and re-create it. This works fine if there already is a table, but if there isn't, I get
Microsoft OLE DB Provider for Visual FoxPro: Invalid path or file name.
. What kind of command can I use to trap for this? I think I can use DBGetProp() but I am not sure.....
With ADOX you can traverse the Tables collection of the catalog object. (that has been opened with a connection to your DBC) Checking the Name property of each table can help you check if the table exists.