Skip to main content
A
Anonymous
March 31, 2010
Answered

CF9 64 bit MS Access datasources

  • March 31, 2010
  • 1 reply
  • 1316 views

As I understand things 64 bit CF9 does not support MS Access datasources.  Is this correct?

Unfortunately there are lots of Access mdb connections still in production.  Some are easy to deal with and I can convert them to SQL server.  But a few are generated/populated by CF6 applications and then sent to other groups outside the company.

So we still need MS Access support.  Should I go with 32 bit CF9 on the windows 2008 R2 server?

This topic has been closed for replies.
Correct answer Owainnorth

OK, so I am thinking that I will buy Windows 2008 R2 with the downgread rights.  I will downgrade to Windows 2008 32-bit and then install CF9.

Or should I just downgrade to Windows 2003?

I am also thinking about testing this 64-bit type 4 driver: http://www.hxtt.com/access.html

Has anyone given this a try?


I can't comment on the driver, but I would always go for 2003 R2 rather than 2008 R1, simply for the in-built backup engine. Server 08 R1 had no way of performing backups without third party products, 2003 at least had NTBackup.

If backups aren't an issue or you've got another product, might as well go 2008.

1 reply

Owainnorth
Owainnorth
Inspiring
March 31, 2010

That is correct, but to the best of my understanding it's now down to Adobe, it's that there's no Microsoft 64-bit Jet driver for Access.

If you still need Access then in all honesty yes, go with 32-bit and start thinking about moving to a more future-proof database engine if it's a long-term project.

O.

A
Anonymous
April 1, 2010

Thanks for your insight.

Are you running 32 bit CF9 on Windows 2008 R2 64 bit?

Owainnorth
Owainnorth
Inspiring
April 1, 2010

We're not, no - 64-bit all the way. From R2 Server 2008 isn't even available in 32-bit; Microsoft have hinted that Windows 8 will be 64-bit only.

I know it sounds like an age-old whinge about Access but it really isn't designed for large or important databases, Microsoft themselves have said it's not meant to be used with websites. Now with it not working on their main architecture and them not really being bothered about it doesn't look good for it, so I'd seriously start looking at moving away from Access. SQLServer Express is free and infinitely faster and more powerful, apart from the ballache of moving the data across there are now fewer reasons than ever to still use it.

Two issues however - I'm not sure you *can* install CF9 as 32-bit on a 64-bit machine - it just installs whichever Java runtime it needs to work on the architecture it has; almost certainly you'd be looking at some serious bodging for it to work.

Secondly - I don't know enough about how the drivers work, if they're ODBC-related then you might find that even using 32-bit CF the driver won't work on a 64-bit OS.

To be honest, you can but try - if you desperately need Access you may need to stick with Server 2003.

O.

Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices