G Guest Sep 27, 2006 #1 Is there a way to programmatically check if a table object exists in a MS Access 2002 Database? Any help would be greatly appreciated!
Is there a way to programmatically check if a table object exists in a MS Access 2002 Database? Any help would be greatly appreciated!
A Alex Dybenko Sep 27, 2006 #2 Hi, something like this: dim tdf as tabledef on error resume next set tdf=currentdb.tabledefs(strTableName) if err.number=0 then 'table exist else 'not end if -- Best regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com
Hi, something like this: dim tdf as tabledef on error resume next set tdf=currentdb.tabledefs(strTableName) if err.number=0 then 'table exist else 'not end if -- Best regards, ___________ Alex Dybenko (MVP) http://alexdyb.blogspot.com http://www.PointLtd.com
