Check if a table exists 1

[dcusick]

I was wondering if someone could help me. I want to check to see if a table exists in my DB through VB code... Is there some function out there that could tell me this? Thanks in advance for the help.

Doug

 

[nickjar2]

i think it is something like this:

dim db as database
dim tb as tabledefs
dim bExists as boolean

set db = currentdb

for each tb in db.tabledefs

if TABLENAME = tb.name then
bExists = true
exit for
end if

next tb

I hope this code is not too inaccurate.

Nick

 

[dcusick]

Very close... The only problem was that tb had to be defined as tabledef, not tabledefs. But besides that, the code worked just like what I needed. Thanks for the help. It's greatly appreciated.

Doug