Determine if a table exists in a database 1

[jdbogie]

I need a method of determining if a table already exists in a database (so that I dont append information to an existing one, or un-intentionally overwrite an old one)

Any ideas?

 

[WildHare]

Use the AllTables collection (A2K) or the Tables collection (A97) and see if there is an object named "{your-table-name-here}" in it...

Look up the COLLECTIONS methods for more help - shouldn't take more than about 4 lines of code to return a TRUE or FALSE answer.

Jim How many of you believe in telekinesis? Raise my hand...
Another free Access forum:

http://www.forumco.com/jmhare

More Access stuff at

http://www.jmhare.com/wildhare2.htm

 

[FoxProProgrammer]

The following should do what you are looking for:

Dim db As Object
Dim item As AccessObject

Set db = Application.CurrentData

For Each item In db.AllTables
If item.Name = <tablenamestring> Then
tblExists = True
Exit Sub
Else
tblExists = False
End If
Next item