Determining if a table exists in a remote mdb

[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?

 

[Andi Mayer]

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?

on error resume next
'do your linking
if err.number <> 0 then
'there was an error
endif
on error goto 0