deleting tables from VBA

[JeroenNL]

Hi there,

I want a routine that deletes all tables in my Access application. But I can't delete all of them, because some of the tables are systemtables of Access itself. I don't want a lot of IF name=??? statements here, I just want to delete my own tables. Anyone knows a solution for this?

Thanks,
Jeroen

 

[KenReay]

Hi

Well all System Tables have names beginning MSys, so provided you have NOT named your tables beginning MSys, you could just loop through the tabledef collection, skipping those with name like MSys* and delete the rest. Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[JeroenNL]

Thanks, that did the trick! Didn't know about the MSys thing.