Why does VB.NET Jet 4.0 app crash if Office not installed?

views:

325

answers:

+1 Q:

Why does VB.NET Jet 4.0 app crash if Office not installed?

Hi all

I'm working on a VB2008 project that references two Access databases using Provider=Microsoft.Jet.OLEDB.4.0;

It would seem if the user does not have MSOffice on their machine, the program crashes with a "XXX stopped working" on startup on Vista and Win7.

I thought that Windows had XP and above had Jet functionality built in? Does anyone know why this is happening? What are the correct project/publish/prerequisites required please?

TIA

+3 A:

There is absolutely NO Jet support for x64 architectures. So the program will runtime error if you are running on an x64 proc and your application is compiling to AnyCPU.

Change the compile target of your application to x86 explicitly and your problems should go away...if I have correctly ID'ed the issue that is. If the failing machines are running x86 OSes then you'll have to look for another solution. But if the failing machines are running x64 OSes then I guarantee this is the problem.

Seth

Seth Spearman 2009-07-17 13:47:05

THANK YOU Seth I think you may have hit the nail on the head. I shall investigate and report back.

2009-07-17 14:18:37

Earle...did this solve it for you? Seth

Seth Spearman 2009-07-25 18:37:29

It did, thank you! It installed fine on Windows 7 after I made the change. I am using VB Express so had to manually add in the line of code into the Project Settings<PlatformTarget>x86</PlatformTarget>Only problem now is that the ClickOnce deployment is messed up and the app thinks it is a different app entirely... sigh. Wonder if there is a way around this??Thanks

2009-07-26 12:37:09

ansaurus

tags:

views:

answers:

Why does VB.NET Jet 4.0 app crash if Office not installed?

related questions