Searching for a Table using code 1

[SPL26]

Hi,

Can anybody help,

I'm trying to find a table in a database, and if this table does not exist, then I will create it.

The bit I'm having trouble with is how do I see if this table exists or not using code. I'm using Access 2000 by the way.

Regards

 

[PHV]

A crude way:
On Error Resume Next
t = CurrentDB.TableDefs("yourTable").Name
e = Err.Number
On Error GoTo 0
If e Then
Err.Clear
' create table stuff
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[SPL26]

Thanks for that, works just fine !

Regards