Checking if a Table Exists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a Client Database on a Laptop which has a Macro to link to the Master
Database on a server.

A table is created in the Client Database only if it can connect to the
Master Database. I want the Macro to exit (StopMacro) if the Table doesnt
exist or if there is no connection to the Master Database.

Is there a Macro command to check if it can connect to the Master Database
or if the Table exists (Table only exists while this Macro is running)?
 
Same as what Stu said in the next post after yours
in a macro for the condition
DCount("*","yourtable")>0 (this will perform the action as long as you have
any records)
 
Back
Top