I changed the code to use the sysobjects table and it worked just fine 
Now to see if I can do this with access somehow 
Through googling, I found this topic... however it didnt seem to answer my question directly, I think I can use it to do what I want with Access.
The line really in question is
If DBName = dbs2020.TableDefs(Count).Name Then
DBName being the table name being checked for...
dbs2020.TableDefs(Count).Name being the table name in the database.
The part I need to know is... is dbs2020 the connection object? IE my_Conn.TableDefs(Count).Name would be the code I would use *if* using snitz connection (example only).
Anybody have experience with this?
Topic Locked
Posted - 07 January 2005 : 04:09:58
