FlowHeater Demo Video
 
FlowHeater - The Data Import / Export Specialist
 
Welcome, Guest
Username: Password: Remember me
See also the existing examples of using the Access Adapter , which may answer your question: CSV import , generate test data , automated batch CSV import
  • Page:
  • 1

TOPIC: Access 64-bit Flowheater 32-bit?

Access 64-bit Flowheater 32-bit? 1 month 3 weeks ago #3557

  • Gerhard Samstag
  • Gerhard Samstag's Avatar Topic Author
  • Offline
  • Posts: 4
Hello Robert,

on my production-server i have following components installed:

Windows Server 2016 64-bit
Access 2019 MSO 16.0.10350 64-bit
FlowHeater 4.1.7 64-bit

Now when I start a Export-Definition (Access to csv, I created with win10), the message comes up:

Please use 32-bit FlowHeater

What can I do, to use the correct 64-bit FlowHeater?

Many regards
Gerhard
Attachments:

Please Log in or Create an account to join the conversation.

Access 64-bit Flowheater 32-bit? 1 month 3 weeks ago #3558

Hi Gerhard,

I guess you would like to export the old MDB Access database format with the Access Adapter ? In this case, only the FlowHeater 32 Bit Version is able to do this. This depends on the old Access JET database format.

Note: It would be possible to install and use both (32 bit | 64 bit) FlowHeater version in parallel. The latest installed version is the default version and is used in case you double click a FlowHeater Definition file (.FHD).

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Access 64-bit Flowheater 32-bit? 1 month 3 weeks ago #3559

  • Gerhard Samstag
  • Gerhard Samstag's Avatar Topic Author
  • Offline
  • Posts: 4
Hi Robert,

thanks for the info, but....

In my understanding, I would like to export the ACCDB database, which is based on the new JET engine.

On my Win10-PC, but with Access for Office 365 MSO v16.0.12527, everything also 64-bit, it works smoothly.

Many regards
Gerhard

Please Log in or Create an account to join the conversation.

Access 64-bit Flowheater 32-bit? 1 month 3 weeks ago #3560

Hi Gerhard,

Ok, I see. Sorry for this question :-) You´re sure whether Access is installed in the 64-Bit Office version on your Windows 2016 Server?

Usually the error appears in case the wrong MS Access version (32-bit / 64-bit) or Access isn´t installed. May I ask you to verify this, Thanks.

In case Access is not installed on your server, you just have to install the “ Microsoft Database Access Engine ” 64-bit driver. No Access license will be required.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Access 64-bit Flowheater 32-bit? 1 month 1 week ago #3561

  • Gerhard Samstag
  • Gerhard Samstag's Avatar Topic Author
  • Offline
  • Posts: 4
Hi Robert,

after my vacation I have checked the MS Access Version. In my eyes a 64-bit version is installed, see screenshot.


I would be reluctant to install any other software at this point in time.
If you want i can remotely show you the installation or can I create a Logfile?

Many regards
Gerhard

Attachments:

Please Log in or Create an account to join the conversation.

Last edit: by FlowHeater-Team. Reason: correct attachment

Access 64-bit Flowheater 32-bit? 1 month 1 week ago #3562

Hi Gerhard,

I´ve made some more tests and I discovered out that the Office/Access 2019 installation doesn´t install the needed “Microsoft Database Engine”. I´m afraid but currently there is no way to install this afterwards.

Workaround/Solution
  1. It would be possible to export your Access Database with the installed Access ODBC database driver. In this case, you have to use the ODBC Adapter  instead.
  2. If you want to use the Access Adapter , you have to uninstall Office first, install the 64 Bit “ Microsoft Database Access 2016 Engine ” and afterwards reinstall Office 2019 again.
The reason why this works on your Windows 10 workstation is, here I guess either you have installed a previous office version first or the “Microsoft Database Access 2016 Engine” was already installed before?

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Access 64-bit Flowheater 32-bit? 1 month 5 days ago #3563

  • Gerhard Samstag
  • Gerhard Samstag's Avatar Topic Author
  • Offline
  • Posts: 4
Hi Robert,

thanks for your investigation.

You are sure that it is not possible to install the "Microsoft Database Access 2016 Engine" afterwards?

Many regards
Gerhard

Please Log in or Create an account to join the conversation.

Access 64-bit Flowheater 32-bit? 1 month 4 days ago #3564

Hi Gerhard,

I´m afraid yes. On my test server the setup runs into an error and tells me that the installation isn´t possible because access has been already installed.

The reason why is, the needed “Microsoft Database Access 2019 Engine” isn´t available until now.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Access 64-bit Flowheater 32-bit? 1 month 1 day ago #3565

Hi Gerhard,

Workaround without uninstallation MS Office/Access from your server. In the current FlowHeater Beta version (4.1.8.1 Beta1) the Access Adapter supports an ODBC fallback in case no other MS Access database driver (JET/ACE) are available onto the system. Please find the beta version download links below.

Limitation) if you want to use this feature you have to use the FlowHeater 32 Bit version instead.

Beta Version Download
FlowHeater Beta 32 Bit
FlowHeater Beta 64 Bit
FlowHeater Server Beta

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.

Please Log in or Create an account to join the conversation.

Best wishes
Robert Stark

Did this answer your question? We would be grateful if you provide a brief comment as feedback. It may also help others who may have encountered a similar problem.
Last edit: by FlowHeater-Team.
  • Page:
  • 1

other Languages

de

FlowHeater Home

de en

Imprint/Contact

Privacy Statement

Copyright © 2009-2020 by FlowHeater GmbH.
All rights reserved.

Follow us on

twitter  facebook

YouTube

 de en