OleDb Access On 64 Bit Machine

[TickerTimer]

I have a small office application being used by around 70 users reading/amending data to/from an Access database using the Oledb connection string.

My problem is that a few users are on 64 bit operating systems and the OleDb connection will not work. The application is set to run on AnyCPU so it's trying to make the connection but failing just on those machines - very annoyingly.

Has any encountered this problem and found a solution?

Any help appreciated.

Thanks

Rob

 

[RiverGuy]

Project Properties -> Compile -> Advanced Compile Options -> Target CPU -> x86

 

[TickerTimer]

just an update - and solution.

RiverGuy - thank you for your answer - you are completely correct.

The application was built in VB.Net Express 2008 which sets the CPU target to "Any CPU" - you don't have the option of targetting the CPU at x86 unless you want to mess around with the configuration files (not a good idea for novices like myself!).

Anyhow - I now have the 2010 Express edition and it looks like Microsoft have got things in order. The CPU is now automatically targeted at x86 so I rebuilt the application from scratch (cutting and pasting the code) in 2010 and all is now working fine on 32 bit and 64 bit machines - happy days!

I had to rebuild it, as opening the Express 2008 build in the Express 2010 edition keeps its "Any CPU" configuration -despite running it through the automatic upgrade facility. It still doesnt give you the option of targetting the CPU at x86 - and won't let you change it - at least not through the user interface. Very annoying but a lesson learned.