Determining if a table exists in a remote mdb

  • Thread starter Thread starter Jim Pockmire
  • Start date Start date
J

Jim Pockmire

I have code that successfully links tables from a remote mdb when the table
exists. How can I trap for errors when the table does not exist in the
remote mdb?
 
I have code that successfully links tables from a remote mdb when the table
exists. How can I trap for errors when the table does not exist in the
remote mdb?
Click to expand...
on error resume next
'do your linking
if err.number <> 0 then
'there was an error
endif
on error goto 0
 
Back
Top