Problem opening up MS Access app from .net 1.1 winforms app.

[moondaddy]

I have a vb.net 1.1 winforms app that performs a login, checks for updates,
downloads updates to the client, then starts the client app. The client app
is a MS Access 2003 application. I created a setup file using the latest
version of InstallShield and have installed this app on about 10 computers
so far and it worked great on all of them. Now today I installed it on my
client's notebook and the login app runs OK. But when it gets to the part
where it calls on some MS Access dlls to open Access and pass in some
parameters to a starter function it crashes. Here's the error I get:

-------------------------------------------------------------------------------------
System.IO.FileNotFoundException: File or assembly name
Microsoft.Office.Interop.Access, or one of its dependencies, was not found.
File name: "Microsoft.Office.Interop.Access"
at TransAct.ClientAppHelper.OpenApp()
at TransAct.frmMain.OpenClientApp()

=== Pre-bind state information ===
LOG: DisplayName = Microsoft.Office.Interop.Access, Version=11.0.0.0,
Culture=neutral, PublicKeyToken=71e9bce111e9429c
(Fully-specified)
LOG: Appbase = C:\Program Files\TransAct\Tools\
LOG: Initial PrivatePath = NULL
Calling assembly : TransAct, Version=1.0.1888.23942, Culture=neutral,
PublicKeyToken=null.
===

LOG: Publisher policy file is not found.
LOG: Host configuration file not found.
LOG: Using machine configuration file from
C:\WINDOWS\Microsoft.NET\Framework\v1.1.4322\config\machine.config.
LOG: Post-policy reference: Microsoft.Office.Interop.Access,
Version=11.0.0.0, Culture=neutral, PublicKeyToken=71e9bce111e9429c
LOG: Attempting download of new URL file:///C:/Program
Files/TransAct/Tools/Microsoft.Office.Interop.Access.DLL.
LOG: Attempting download of new URL file:///C:/Program
Files/TransAct/Tools/Microsoft.Office.Interop.Access/Microsoft.Office.Interop.Access.DLL.
LOG: Attempting download of new URL file:///C:/Program
Files/TransAct/Tools/Microsoft.Office.Interop.Access.EXE.
LOG: Attempting download of new URL file:///C:/Program
Files/TransAct/Tools/Microsoft.Office.Interop.Access/Microsoft.Office.Interop.Access.EXE.
---------------------------------------------------------------------------------------

This PC already has Office and Access installed on it so I don't know why
its looking for Interop.Access files in the directory where this winforms
app is installed. For example: the app is installed in:

C:\Program Files\TransAct\Tools
and its looking for and access interop like this:

URL file:///C:/Program
Files/TransAct/Tools/Microsoft.Office.Interop.Access.EXE.

Can anyone explain whats going on and how I can resolve this?

Thanks.

 

[Jeffrey Tan[MSFT]]

Hi moondaddy,

Thanks for your post!!

Looking at the exception message of your application, the problem should be
that your client machine did not install the
Microsoft.Office.Interop.Access assembly, which is included in Microsoft
Access' .Net Programmability Support. Defaultly, this component is not
installed in the client machine. So I think you may re-install this
component on your problem machine, and this problem should go away.

To get this component installed, you may first open "Add or Remove
Programs" app in Control Panel. Then find "Microsoft Office Professional
Edition 2003" item, clicked "Change" button. In the following wizard, we
may select "Add or Remove Features" option -> "Next" ->Check "Choose
advanced customization of applications"->"Next".
In the "Advanced Customization" dialog, we can expand the "Microsoft Office
Access" node, select ".Net Programmability Support" node. At last, we may
click this node and choose "Run all from My Computer" option->"Update".

I think this should resolve your problem.
========================================
Thank you for your patience and cooperation. If you have any questions or
concerns, please feel free to post it in the group. I am standing by to be
of assistance.

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[moondaddy]

Thanks. I"ll try it out later this week when i can get ahold of that
notebook again.

 

[Jeffrey Tan[MSFT]]

Ok, if you need further help, please feel free to feedback. I will work
with you. Thanks

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[Jeffrey Tan[MSFT]]

Hi moondaddy,

Have you tried my suggestion? Is your problem resolved? Please feel free to
tell me, Thanks

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.

 

[moondaddy]

Actually no it didnt work and i had limited time to work on it as the client
cant let me have it for very long. and since she travels alot, I havent
been able to get it again. This issue will resume some time but I have no
idea when. Thanks and I'll let you know when I'm on it again.

 

[Jeffrey Tan[MSFT]]

Hi moondaddy,

Ok, I suggest you provide more information of this issue in a futher issue.
With further information, we can understand this issue better. You may post
a new issue at that time. Thanks

Best regards,
Jeffrey Tan
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.