linking/relinking tables

[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

 

[pyttyco]

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

 

[Peter Hibbs]

Jennifer

Maybe the code at :-

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

would be easier to use.

Peter Hibbs.