Thread: How can I use VBA ADO to check if a table exists in an Access DB?
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
  
Posts: 11,272
Default How can I use VBA ADO to check if a table exists in an Access DB?
See my response in .excel for a version that doesn't have to iterate through
all tables

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Ai_Jun_Zhang"
wrote in message
news:Ai_Jun_Zhang.1u72ub_1124762717.6606@excelforu m-nospam.com...

How can I use VBA ADO to check if a table exists in an Access DB?

--------------------------------------------------------------------------
------

Hi!

If I aready have an access DB called c:\temp\MyDb.mdb, is there any way
that I can use ADO to check if a table exists in this database?

Thanks,

Aijun.


--
Ai_Jun_Zhang
------------------------------------------------------------------------
Ai_Jun_Zhang's Profile:
http://www.excelforum.com/member.php...o&userid=25474
View this thread: http://www.excelforum.com/showthread...hreadid=397999



Reply With QuoteReply With Quote