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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Checking if Table exists 1
Checking if a Table exists 1
in Access 2007-TransferDatabase action will not work. 0
Access 2007 replica to master 4
Access how to open existing database from another database using Access - VBA 0
Run a macro in multiples databases 0
Set Display Control for a Table Yes/No Field 5
Conditional help 1

Back
Top