How to check if a table exists in Access XP

[Anthony Bowman]

Hello,
I have a access application that resides locally on users desk, I
am writing a VB.Net interface that let's the users pull data down from
a SQL server database and populate the local access database with that
data, I need to check the local access database to see if there is
already a table with the name the users give. Anyone run into that or
have any idea how this would be done.

Thanks
Anthony
ta*******@tva.gov

[NetPointer]

if u go to tools and option..and check to show the system tables, few more
tables will appear in your table list..this are the system tables.

one among this table stores all the name of the objects(including tables)..
u can query this table to check the existance of table.

Regards,
NetPointer

"Anthony Bowman" <ta******@comcast.net> wrote in message
news:da**************************@posting.google.c om...

Hello,
I have a access application that resides locally on users desk, I
am writing a VB.Net interface that let's the users pull data down from
a SQL server database and populate the local access database with that
data, I need to check the local access database to see if there is
already a table with the name the users give. Anyone run into that or
have any idea how this would be done.

Thanks
Anthony
ta*******@tva.gov

[Paul Clement]

On 3 Nov 2003 14:09:24 -0800, ta******@comcast.net (Anthony Bowman) wrote:

¤ Hello,
¤ I have a access application that resides locally on users desk, I
¤ am writing a VB.Net interface that let's the users pull data down from
¤ a SQL server database and populate the local access database with that
¤ data, I need to check the local access database to see if there is
¤ already a table with the name the users give. Anyone run into that or
¤ have any idea how this would be done.
¤

Yes, you can use GetOleDbSchemaTable:

Dim AccessConnection As New System.Data.OleDb.OleDbConnection()
Dim SchemaTable As DataTable

AccessConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=E:\My Documents\db1.mdb"
AccessConnection.Open()

'Retrieve schema information about Table1.
SchemaTable =
AccessConnection.GetOleDbSchemaTable(System.Data.O leDb.OleDbSchemaGuid.Columns, _
New Object() {Nothing, Nothing, "Table1"})

If SchemaTable.Rows.Count <> 0 Then
Console.WriteLine("Table " & SchemaTable.Rows(0)!TABLE_NAME.ToString & " Exists")
Else
Console.WriteLine("Table does not exist")
End If

AccessConnection.Close()
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

[Anthony Bowman]

Paul Clement <Us***********************@swspectrum.com> wrote in message news:<08********************************@4ax.com>. ..

On 3 Nov 2003 14:09:24 -0800, ta******@comcast.net (Anthony Bowman) wrote:

¤ Hello,
¤ I have a access application that resides locally on users desk, I
¤ am writing a VB.Net interface that let's the users pull data down from
¤ a SQL server database and populate the local access database with that
¤ data, I need to check the local access database to see if there is
¤ already a table with the name the users give. Anyone run into that or
¤ have any idea how this would be done.
¤

Yes, you can use GetOleDbSchemaTable:

Dim AccessConnection As New System.Data.OleDb.OleDbConnection()
Dim SchemaTable As DataTable

AccessConnection.ConnectionString = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
"Data Source=E:\My Documents\db1.mdb"
AccessConnection.Open()

'Retrieve schema information about Table1.
SchemaTable =
AccessConnection.GetOleDbSchemaTable(System.Data.O leDb.OleDbSchemaGuid.Columns, _
New Object() {Nothing, Nothing, "Table1"})

If SchemaTable.Rows.Count <> 0 Then
Console.WriteLine("Table " & SchemaTable.Rows(0)!TABLE_NAME.ToString & " Exists")
Else
Console.WriteLine("Table does not exist")
End If

AccessConnection.Close()
Paul ~~~ pc******@ameritech.net
Microsoft MVP (Visual Basic)

Great - Both of the suggestions worked wonders and have fixed my
problem. I appreciate the help.

Thanks
Anthony