By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
425,775 Members | 2,658 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 425,775 IT Pros & Developers. It's quick & easy.

Test for a table

P: n/a
Using VBA how can I test to see if a table has been created?

Situation: I create temp tables that are used by users and then deleted
when they log off. How can I tell if a table is still in use or has been
created so that I do not try and create a duplicate table?

Michael Charney

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
Dev's the man
Look at this code:

http://www.mvps.org/access/tables/tbl0001.htm
Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.