A2007 Runtime and LinkedTable Manager

[Tom Ventouris]

The ACCDE file has a button with Macro and Menu Option (Ribbon) with code
which both succesfussly call up the Linked Table Manager.
After I package the application with Runtime I get the "Microsoft has
encountered an error and needs to close....." when I try to link.

I have compiled, disabled shiftkey, tried without disabling shift key,
placed the files in trusted locations.

All other functions and work as expected in the packaged application.

Any help welcome.

 

[Tom Wickerath]

I'm not using Access 2007 on any regular basis yet, and I also don't deal
with runtime solutions, but you might try calling a function to do the
relinking instead of trying to invoke the linked table manager.

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


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Tom Ventouris]

I will try this and post back, thanks again.

I'm not using Access 2007 on any regular basis yet, and I also don't deal
with runtime solutions, but you might try calling a function to do the
relinking instead of trying to invoke the linked table manager.

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


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Tom Ventouris]

The code from Dev Ashish works, but I need to work on the File Types and the
OpenFile Dialoge which for some reason does not diplay the ACCDB files. I
thnk this is caused by the Relinking code, which lists only the Access File
ectensions up to A2003.

The code at the other link you provided tells me I have selected the wrong
file to lonk, probably because it was written for A2003 and earlier and may
have something to do with the file extensions.

In any event, the problem is solved, even if the user must select "All
Files" to see the back end, for now.

Thank you, for this and you response on my Developer Extensions post. I can
now move back to my laptop - the Developer option was available on my desktop

 

[Tom Wickerath]

Hi Tom,

Find the following snippet of code in the GetOpenFile function:

' Define the filter string and allocate space in the "c"
' string Duplicate this line with changes as necessary for
' more file templates.
strFilter = ahtAddFilterItem(strFilter, _
"Access (*.mdb)", "*.MDB;*.MDA")


Add *.accdb. I think this will do it, although I am not taking the time to
test it at the moment:

strFilter = ahtAddFilterItem(strFilter, _
"Access (*.mdb, *.accdb)", "*.MDB;*.MDA;*.accdb")

You can probably get rid of the .mda extension, since it is unlikely that
you'd ever be using this.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

 

[Tom Ventouris]

This works. Thanks.

Hi Tom,

Find the following snippet of code in the GetOpenFile function:

' Define the filter string and allocate space in the "c"
' string Duplicate this line with changes as necessary for
' more file templates.
strFilter = ahtAddFilterItem(strFilter, _
"Access (*.mdb)", "*.MDB;*.MDA")


Add *.accdb. I think this will do it, although I am not taking the time to
test it at the moment:

strFilter = ahtAddFilterItem(strFilter, _
"Access (*.mdb, *.accdb)", "*.MDB;*.MDA;*.accdb")

You can probably get rid of the .mda extension, since it is unlikely that
you'd ever be using this.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________