Skip to main content
Question

How do I compact an access database created in 64 bit FME?

  • January 22, 2018
  • 2 replies
  • 43 views
S

Hello, I'm a newbie here so I hope someone can help me out.

I have a basic work space where I extract data out of an Oracle DB and write it out to an MS Access DB and compact on completion.

This is to be run by a scheduled task on a server calling a batch file which has the command line prompt for calling my FME workspace.

I wish to use 64 bit FME to do this transformation but upon completing the transformation successfully it gives an error saying compacting of database is not available in 64 bit.

The result being a Access DB with all the data but not compacted.

Thanks in advance for any help.

This post is closed to further activity.
It may be an old question, an answered question, an implemented idea, or a notification-only post.
Please check post dates before relying on any information in a question or answer.
For follow-up or related questions, please post a new question or idea.
If there is a genuine update to be made, please contact us and request that the post is reopened.

2 replies

S
  • stokessheldon
  • Author
  • 1 reply
  • January 22, 2018

 

Should add I am using FME 2017 build 17259.
M
Forum|alt.badge.img+2
  • markatsafe
  • 1891 replies
  • January 23, 2018

The MS Access 64bit driver that FME uses does not support database compact. You could try creating an empty MS Access database and setting the database Access Option to Compact on Close.

Community Stats

32,060
Posts
121,724
Replies
39,688
Members

Latest FME

Terms & ConditionsCookie settingsAccessibility statement
A product of
Safe Software respectfully acknowledges that we live, learn and work on the traditional and unceded territories of the Kwantlen, Katzie, and Semiahmoo First Nations.