View Full Version : Check if table or query exists


RuudJ
03-11-2007, 09:06 AM
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
03-11-2007, 09:54 AM
http://www.mvps.org/access/tables/tbl0001.htm

RuudJ
03-13-2007, 06:02 AM
MicroE,

Thanks for your help !!

Best regards,
RuudJ

:)

Cosmos75
03-13-2007, 02:03 PM
There is also this KB article - ACC2000: Sample Code to Check for Table or Query in a Database (http://support.microsoft.com/kb/210398/en-us)

MicroE
03-13-2007, 02:27 PM
Ruud - You are welcome.