Skip to main content
Question

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


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.

2 replies

 

Should add I am using FME 2017 build 17259.

Forum|alt.badge.img+2
  • 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.


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings