Skip to main content
B
BarrettChamberlain
Known Participant
May 5, 2014
Answered

Does Coldfusion 11 allow use of 32 bit MS Access datasources?

  • May 5, 2014
  • 1 reply
  • 432 views

Does Coldfusion 11 allow use of 32 bit MS Access datasources?

This topic has been closed for replies.
Correct answer Steve Sommers

Well, my first rhetorical question: It's 2014, why MS Access? MS SQL has free versions that are much faster and more stable than any MS Access version, I don't see any drawback migrating.


Now more to your question, 32 bit "should" not be a factor. 64 bit apps can talk to most 32 bit apps via an API without much difficulty. The only exception that I am aware of are 32 bit apps that rely exclusively on DLLs for their API -- I don't "think" MS Access has this limitation. It's probably been at least 15 years since I touched anything dealing with MS Access thus my hesitance to be more definitive in my answer. Good luck.

1 reply

S
Steve SommersCorrect answer
Legend
May 5, 2014

Well, my first rhetorical question: It's 2014, why MS Access? MS SQL has free versions that are much faster and more stable than any MS Access version, I don't see any drawback migrating.


Now more to your question, 32 bit "should" not be a factor. 64 bit apps can talk to most 32 bit apps via an API without much difficulty. The only exception that I am aware of are 32 bit apps that rely exclusively on DLLs for their API -- I don't "think" MS Access has this limitation. It's probably been at least 15 years since I touched anything dealing with MS Access thus my hesitance to be more definitive in my answer. Good luck.

B
BarrettChamberlainAuthor
Known Participant
May 5, 2014

Hi Steve,

Thanks for your reply.  There is certainly no good reason for the company I'm contracting for to be using these datasources.

It took quite a bit of troubleshooting to get CF 10 to work with these datasources so I imagine the same hurdles are likely to be in store.

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