+ Reply to Thread
Results 1 to 4 of 4

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

  1. #1
    Registered User
    Join Date
    07-21-2005
    Posts
    28

    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.

  2. #2
    Bob Phillips
    Guest

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

    Here is a simple function. Call with

    ?IfTableExists("C:\temp\MtDB.mdb","DB")

    Function IfTableExists(FileName As String, Table As String) As Boolean
    Dim oConn As Object

    Set oConn = CreateObject("ADODB.Connection")
    oConn.Open = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & _
    FileName

    On Error Resume Next
    oConn.Execute "SELECT 1 FROM [" & Table & "] WHERE 0=1"
    IfTableExists = (Err.Number = 0)

    oConn.Close
    Set oConn = Nothing

    End Function



    --

    HTH

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


    "Ai_Jun_Zhang" <Ai_Jun_Zhang.1u72ua_1124762703.1677@excelforum-nospam.com>
    wrote in message
    news:Ai_Jun_Zhang.1u72ua_1124762703.1677@excelforum-nospam.com...
    >
    > 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=397998
    >




  3. #3
    Registered User
    Join Date
    07-21-2005
    Posts
    28

    Thanks. Can I be notified by email if there is a response to my question?

    Thanks, Bob. It works and I really appreciate your help.

    Bob, I have a side question. Is there any way this forum can notify me by email if somebody has responded to my question? It will be very convenient for me. Otherwise, as I am doing now, I have to check the forum periodically to see if anybody has responded to my email.

    Thanks,

    Aijun.

  4. #4
    Bob Phillips
    Guest

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

    Hi Aijun,

    I am afraid that I cannot help you with that question. I do not subscribe to
    the forum, I connect to the Microsoft public newsgroups, where questions on
    your forum are forwarded to. You would need to raise it there, but my
    experience is that it's all or noting with these forums, you get an email
    about all posts, or none.

    Sorry I could not help more.

    Bob


    "Ai_Jun_Zhang" <Ai_Jun_Zhang.1ua8qd_1124910305.6801@excelforum-nospam.com>
    wrote in message
    news:Ai_Jun_Zhang.1ua8qd_1124910305.6801@excelforum-nospam.com...
    >
    > Thanks, Bob. It works and I really appreciate your help.
    >
    > Bob, I have a side question. Is there any way this forum can notify me
    > by email if somebody has responded to my question? It will be very
    > convenient for me. Otherwise, as I am doing now, I have to check the
    > forum periodically to see if anybody has responded to my email.
    >
    > 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=397998
    >





+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1