Check if Access Table exists - 2007

[jsjones]

I am using Access 2007.

What would be the correct syntax to use in vba module to check if an access table exists?

Example:
If accesstable1 exists then
xxx
Else
yyy
End If

This seems like it should be a very basic function, but I have not been able to find it.

Thanks!!

 

[MarkK]

Here's a function you can use...

function TableExists(name as string) as boolean
  TableExists = dcount("*", "MSysObjects", "Name = '" & name & "' AND Type = 1")
end function

Cheers,
Mark

 

[jsjones]

That worked, and simple.
Thanks!!!

 

[G37Sam]

Here's a function you can use...

function TableExists(name as string) as boolean
  TableExists = dcount("*", "MSysObjects", "Name = '" & name & "' AND Type = 1")
end function

Cheers,
Mark

Hello Mark,

You sure it's not type = 6? On my accdb all my tables are type 6 for some reason.

Cheers,
Sam

 

[spikepl]

http://www.access-programmers.co.uk/forums/showpost.php?p=473720&postcount=3