Reconnect Table Dialog

I want to make a form can relink the table when it startup, if the data source is change or can not find then pop up the open dialog to find the data source and reconnect the table!  How to do that?
UncochenAsked:
Who is Participating?
 
Jim Dettman (Microsoft MVP/ EE MVE)Connect With a Mentor PresidentCommented:

  I'm attaching a relink sample database.   Code is called in the Autoexec.  Once of the tables is checked and if able to connect, the rest of the code is skipped.  If not, then the open dialog is popped up asking for the location of the back end database.

Enjoy.

JimD.
Relink2.Zip
0
 
dannywarehamCommented:
See here too
http://www.mvps.org/access/tables/tbl0009.htm

Same meat, different gravy as Jim's
0
All Courses

From novice to tech pro — start learning today.