Table Exists 1

[brau]

I did a search in tektips on how to find out if a table exists in my database but just can't quite figure out the methods used. Can someone give me the code to find out if I have a table called EDF in my database? I want to use it under a command button and not as a function if it's possible.
Thankyou for your help.
Bob

 

[THoey]

The following link has code that checks to see if a table exists, then runs a macro if it does not. I am sure it can be altered to fit your code...

thread181-6951 Terry M. Hoey
th3856@txmail.sbc.com
While I don't mind e-mail messages, please post all questions in these forums for the benefit of all members.