Need simple VBA code to refresh linked tables.

Question

Is there simple VBA code tied to, perhaps, a command button which, when clicked, runs code that performs the same function as does going to 'Tools', 'Database Utilities', 'Linked Table Manager', 'Select All', 'OK'.

Answer 1

Simple is in the eye of the beholder.  Here's some examples that cover most of what you can do in the Link Table Manager:

http://www.mvps.org/access/tables/tbl0009.htm

http://dfenton.com/DFA/download/Access/Reconnect.html

http://www.mvps.org/access/tables/tbl0012.htm

Personally, I don't think they are mysterious, but they are not elementary either.  OTOH, they are tried and true so all you really need to do is figure out how to use them in your application.

Answer 2

Hi I wonder if you could tell me why   http://ow.ly/M56Q gives an access security warning when i try to open it

The web page gives you this message, or the database after you have downloaded it and extracted it from the zip file?  What is the text of the message? 

The database contains VBA code, so you may get an Access security warning when you open it, if you haven't placed it in a trusted location.

Answer 3

On Thu, 30 Sep 2010 19:33:33 +0000, Marshall Barton [MVP] wrote:

>

>

>Simple is in the eye of the beholder.  Here's some examples that cover most of what you can do in the Link Table Manager:

>

>http://www.mvps.org/access/tables/tbl0009.htm

>http://dfenton.com/DFA/download/Access/Reconnect.html

>http://www.mvps.org/access/tables/tbl0012.htm

>

>Personally, I don't think they are mysterious, but they are not elementary either.  OTOH, they are tried and true so all you really need to do is figure out how to use them in your application.

Our free J Street Access Relinker is pretty darn elementary.  It's on

our J Street Downloads page:  http://ow.ly/M56Q   We've used it in

hundreds of Access apps we've built for clients.

It's some code that you simply copy into your front-end application.

It handles multiple Access back-end databases, ignores ODBC linked

tables, and can automatically and silently relink to back-end

databases in the same folder as the application (handy for work

databases or single-user scenarios).  There's a ReadMe table with

instructions.

Armen Stein

Microsoft Access MVP

www.JStreetTech.com

Hi I wonder if you could tell me why   http://ow.ly/M56Q gives an access security warning when i try to open it

Answer 4

On Thu, 30 Sep 2010 19:33:33 +0000, Marshall Barton [MVP] wrote:

>

>

>Simple is in the eye of the beholder.  Here's some examples that cover most of what you can do in the Link Table Manager:

>

>http://www.mvps.org/access/tables/tbl0009.htm

>http://dfenton.com/DFA/download/Access/Reconnect.html

>http://www.mvps.org/access/tables/tbl0012.htm

>

>Personally, I don't think they are mysterious, but they are not elementary either.  OTOH, they are tried and true so all you really need to do is figure out how to use them in your application.

Our free J Street Access Relinker is pretty darn elementary.  It's on

our J Street Downloads page:  http://ow.ly/M56Q   We've used it in

hundreds of Access apps we've built for clients.

It's some code that you simply copy into your front-end application.

It handles multiple Access back-end databases, ignores ODBC linked

tables, and can automatically and silently relink to back-end

databases in the same folder as the application (handy for work

databases or single-user scenarios).  There's a ReadMe table with

instructions.

Armen Stein

Microsoft Access MVP

www.JStreetTech.com