Runtime 2007 and Linked Table Manager

[JohnB]

I want to run an Access 2007 application on a customer machine using Runtime
2007.
How do I get to use Linked Table Manager to work with Runtime.

 

[Tom Wickerath]

Hi John,

My recommendation is to implement re-linking code, rather than attempt to
use the Linked Table Manager. Access MVP Armen Stein makes his re-linking
code available for free on his web site. Check out the download "J Street
Access Relinker", currently shown as the first download:

http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

You add a call to the function, in an Autoexec macro, to use this code.

Access 2007 (.accdb file format only) allows one to insert an action into
the Autoexec macro that can allow one to test to see if the folder has been
trusted, so that VBA code is allowed to run. I have a download available that
includes an Access 2007 .accdb file with such an Autoexec macro (borrowed it
from a sample in the Access 2007 book written by John Viescas and Jeff
Conrad). You can find this database sample, with the Autoexec macro, here:

http://www.accessmvp.com/TWickerath/downloads/tmpwrkdb.zip


Tom Wickerath
Microsoft Access MVP
http://www.accessmvp.com/TWickerath/
__________________________________________

 

[Armen Stein]

Hi John,

My recommendation is to implement re-linking code, rather than attempt to
use the Linked Table Manager. Access MVP Armen Stein makes his re-linking
code available for free on his web site. Check out the download "J Street
Access Relinker", currently shown as the first download:

http://www.jstreettech.com/cartgenie/pg_developerDownloads.asp

Thanks Tom!

John, in order to browse to an Access 2007 format ACCDB/ACCDE back-end
database, you need to use this replacement code:

'Set up display of dialog
'October 2009 - now handles Access 2007 formats ACCDB and ACCDE
Dim strAccExt As String
strAccExt = "*.accdb; *.mdb; *.mda; *.accda; *.mde; *.accde"
strFilter = "Microsoft Office Access (" & strAccExt & ")" &
Chr$(0) & strAccExt & Chr$(0) & _
"All Files (*.*)" & Chr$(0) & "*.*" & _
Chr$(0) & Chr$(0)
strTitle = "Find new location of " & strDBName
strDefExt = "mdb"

I'll have the Relinker with this change posted to the download site
soon.

Cheers,

Armen Stein
Microsoft Access MVP
www.JStreetTech.com