How do you detect if a table exists. I have a table tblAvailability and I need to delete it and create it, and I am trying to avoid errors by knowing in advance if the table exists or not.

I have seen the following used...

Function fTableExists3(strTableName As String) As Boolean
    On Error Resume Next
    fTableExists3 = IsObject(CurrentDb.TableDefs(strTableName))
End Function

But not sure if this is the ticket.

Regards,


Marc Noon

Coding is a game. Live it, love it, break it, run it.

__________________
Marc Noon

Coding is a game. Live it, love it, break it, run it.

I have always used this one to detect if a table is present and then Drop it to create a new one. rs is an ADODB recordset and cn is an ADODB connection. RBRVS is that name of the table in question.

Hope that helps

Mike

strSQL = "SELECT Count(*) AS Present FROM MSysObjects WHERE Name = 'RBRVS' AND Type = 1"

    rs.Open strSQL, cn

    If rs.Fields("Present") = 1 Then
        strSQL = "DROP TABLE RBRVS"
        cn.Execute strSQL
    End If

Mike
EchoVue.com

If you are using SQL server, then u can check in sysobjects
for that object_id (table).

Om Prakash

Another question... how would one go about dropping a table... one that I create and drop often, if two or more people use it to view data through a query?

Thanks,

Marc Noon

Marc Noon

Coding is a game. Live it, love it, break it, run it.

For your case I'd recommend using Front end and back end databases.

Keep the shared tables (tables that you don't drop (delete) and create) in the back end. Link to those tables from the front end.

Give everyone their own copy of the front end. Put the table(s) you do drop (delete) in the front end. No worries about two people trying to view that table since each have their own copy.


Randall J Weers
Membership Vice President
Pacific NorthWest Access Developers Group
http://www.pnwadg.org

How do you go about separating the database in access. Do create a separate work-flow process for each session, and just poll often from the main database. Just interested in the model and demarcation lines more than anything.

Marc Noon

Coding is a game. Live it, love it, break it, run it.