linking/relinking tables

  • Thread starter Thread starter Toxalot
  • Start date Start date
T

Toxalot

I see that many posts on this topic refer to the following
http://www.mvps.org/access/tables/tbl0009.htm

I'm not sure I understand all the code there and I don't think I need
it all.

I already have code to allow the user to choose a BE file and that
info is stored in a local table.

What I want to do is check to see if the table exists and if so
refresh the link and if it doesn't exist then create it.

How can I check if the table exists?

Also, would it be better (faster) to check the connect to see if
refreshing is necessary or just automatically refresh all existing
links?

Jennifer
 
Toxalot said:
I see that many posts on this topic refer to the following
http://www.mvps.org/access/tables/tbl0009.htm

I'm not sure I understand all the code there and I don't think I need
it all.

I already have code to allow the user to choose a BE file and that
info is stored in a local table.

What I want to do is check to see if the table exists and if so
refresh the link and if it doesn't exist then create it.

How can I check if the table exists?

Also, would it be better (faster) to check the connect to see if
refreshing is necessary or just automatically refresh all existing
links?

Jennifer
Click to expand...
 
Back
Top