Checking if a Table Exists

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)?
 
G

Guest

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
Need if statement in macro 1
Need vb script/macro to append table in access database A to datab 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Conditional help 1
Set Display Control for a Table Yes/No Field 5

Top