Checking a table exists??

A

Ant

Hi,

Can anyone tell me how to check that a table exists in a
Access 2000 backend before attempting to link to that
table from a front end? I have code that deletes and then
recreates a linked table (I could not get
the 'Refreshlink' to work) depending on which backend you
choose to work on.

Thanks,

Ant
 
M

Marshall Barton

Ant said:
Can anyone tell me how to check that a table exists in a
Access 2000 backend before attempting to link to that
table from a front end? I have code that deletes and then
recreates a linked table (I could not get
the 'Refreshlink' to work) depending on which backend you
choose to work on.
Click to expand...


Answered in your earlier thread
 

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

"MSysCompactError", "System resource exceeded" & "You do not have the necessary permissions to use the...." 0
Changing Front End Back End Connection Through VBA 1
VBA to see if a Section exists in Word Document, and if it does, delete it 2
could not lock file 1
Adjusting the layout of over 1000 existing Word documents using a macro-driven batch run 0
Ghost references to deleted tables in a back end database (Access2000 XP) 5
crash detection in database 5
Vertical short line in front of word 0

Top