Check if table or query exists

[RuudJ]

Hi,

Can anyone help me with the following:
In VBA I want to check if a table or querydefinition exists.
I'm stuck on finding the code for this action.

Thanks in advance.
Ruud,
Holland

 

[MicroE]

http://www.mvps.org/access/tables/tbl0001.htm

 

[RuudJ]

Thanks very much !

MicroE,

Thanks for your help !!

Best regards,
RuudJ

 

[Cosmos75]

There is also this KB article - ACC2000: Sample Code to Check for Table or Query in a Database

 

[MicroE]

Ruud - You are welcome.