Table exists

  • Thread starter Thread starter Guest
  • Start date Start date
Function TableExists(strName As String) as Boolean
Dim strTemp as String
On Error Resume Next
strTemp = CurrentDb.TableDefs(strName).Name
TableExists = (Err.Number = 0)
Err.Clear
End Function

Code originally from Ken Getz

Daniel
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Tables/Queries Exists() Function 2
Exists() function seems broken.. Any help? 12
Verify existence of a field 0
Form Problem 0
Excel VBA 0
Check if text string exists 5
how to see if a field exists in table 1
Record entry on an unbound form 1

Back
Top