Automate Linking Table Manager

[Guest]

I have a database for multiple users that has the Allow Full Menus, Display
Database Window, and Allow Toolbar/Menu Changes unchecked. When I install a
new front-end, I always have to go in using the passaroud key so I can see
the regular toolbar so I can run the Linking Table Manager. I've added this
feature to a Maintenance Bar that comes up only for specific people when they
click on a specific form. But that's further along in the database. Is
there a way trigger the Linking Table Manager on a new front-end when it
tries to open the first time?

 

[John Vinson]

Is
there a way trigger the Linking Table Manager on a new front-end when it
tries to open the first time?

It's possible - and in fact rather routine - to include VBA code which
checks for correct linking of the backend and opens a Windows file
dialog to let the user identify the backend if it's not there.

The code I use is copyrighted, from the Access Developer's Handbook,
but there are examples aplenty out on the web. I'd start with Tony
Toews' site http://www.granite.ab.ca/access or search the references
in:

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html


John W. Vinson[MVP]

 

[Guest]

Thank you so much.

It's possible - and in fact rather routine - to include VBA code which
checks for correct linking of the backend and opens a Windows file
dialog to let the user identify the backend if it's not there.

The code I use is copyrighted, from the Access Developer's Handbook,
but there are examples aplenty out on the web. I'd start with Tony
Toews' site http://www.granite.ab.ca/access or search the references
in:

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html


John W. Vinson[MVP]

 

[Douglas J. Steele]

It's possible - and in fact rather routine - to include VBA code which
checks for correct linking of the backend and opens a Windows file
dialog to let the user identify the backend if it's not there.

The code I use is copyrighted, from the Access Developer's Handbook,
but there are examples aplenty out on the web. I'd start with Tony
Toews' site http://www.granite.ab.ca/access or search the references
in:

Jeff Conrad's resources page:
http://home.bendbroadband.com/conradsystems/accessjunkie/resources.html

The Access Web resources page:
http://www.mvps.org/access/resources/index.html

Or, specifically, http://www.mvps.org/access/tables/tbl0009.htm at "The
Access Web"

 

[John Vinson]

Or, specifically, http://www.mvps.org/access/tables/tbl0009.htm at "The
Access Web"

Thanks, Douglas! Need to bookmark that one... <g>

John W. Vinson[MVP]