You are viewing limited content. For full access, please sign in.

Question

Question

Connecting 32-bit Quick Fields to 64-bit MS Access database

Quick Fields
Updated February 12
asked on December 19, 2024

We have a customer that just upgraded all their Microsoft applications to 365, meaning it's all 64-bit.  Once that happened, Quick Fields was no longer able to connect to an MS Access database that they had been using for real-time lookup.  We've tried using different bitness of the ODBC drivers, setting up a linked server in SQL, and several other things, but haven't been able to get it to work.

Has anyone else tackled this issue before?  Also, do we know if a 64-bit version of Quick Fields is in the works?  I'm surprised we haven't got one yet.

0 0

Replies

replied on December 19, 2024

Download the x86 version of the drivers from Microsoft and reconfigure the data source: https://www.microsoft.com/en-us/download/details.aspx?id=54920 

There are no plans for a 64-bit Quick Fields.

0 0
View 1 previous reply
replied on January 27

Download the x86 version of the drivers from Microsoft and reconfigure the data source:

As I stated in my original post:

 We've tried using different bitness of the ODBC drivers...

We've tried both the 64 and 32 bit versions, to no avail.  Can you offer any helpful hints that would allow this to work? 

0 0
replied on January 27

When you configure the 32 bit ODBC, are you using the 32 bit version of the ODBC Data Sources Utility? %windir%\syswow64\odbcad32.exe

1 0
replied on January 27

Paul, there isn't enough information in your post to troubleshoot. There are multiple drivers for Office and you're not specifying which one you're using or what the error is. I pointed you to the one that is expected to work.

If you tried the x86 driver from the Microsoft Access Database Engine, what happened? Did you use the ODBC or OLE driver? Are you seeing the data source in Quick Fields? Can you select it? Does it show tables? What error are you getting?

0 0
replied on February 12

Ok, so I took everything back to scratch.  Here's what I did.

1. Went to the link Miruna provided and downloaded the x86 version of the 2016 Access Database Engine.

2. Installed on a server running Quick Fields that has NO other office components installed

3. Opened the Session in Quick Fields and went to the Real-Time processes for the document class

4. In the Source tab, opened the data source wizard and used that to open the 32-bit ODBC source configuration in Windows.

5. Configured the source to use the Access database (there's no system DB and no username/password for the database)

6. Tested the connection in Quick Fields and got the following error:

 

The db is being used by several other processes, so we know it's not corrupt.  Any ideas?

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.

Details
Related Posts
Loading ...