Query table name persists after deletion

[Glory]

I'm trying to write some code to make a querytable. The problem is that, after the first table is deleted, when the second table is added, the name of the second table has a "_1" appended to the end.

I've tried deleting all the names on the worksheet, but that doesn't help. Any ideas?

 

[chuckchuckit]

I am not familiar with the use of connections in the "Object" sense. Someone else here may have some info on that. But in any case, I would think you will still have to be aware of if you are generating a bunch of "Connections" no longer used.

That of course you can observe them in the "Menu, Data, Connections" box that will display them.

Hope that all is of use.

Chuck

 

[chuckchuckit]

The code above (used to delete multiple connections) is referring to the connections as an object. Perhaps leaving the connection object not deleted, is linking to your Query table name object also, and may be why it is putting _1 on the end of the next query.

Try using the code above to delete all connections in between queries and see if the Query table name stops adding _1 to the next one.

Worth a try to see anyway.

 

[Glory]

Tried it out. The delete method is not a property of the connection object for anything earlier than 2007. Thanks anyway.

Anybody else got any ideas?

 

[Glory]

I wound up realizing that I didn't actually need my querytables to be named a certain specific way to extract the data from them. The ADO just looks at the ranges to get what it needs.

Instead of worrying about making sure they always kept exactly the same name, I settled for adding in the date, hour, minue and second of creation each time a new table is created. That way the name appears exactly the way I originally intended. There's never any chance of conflict with the old name, this way.