Question

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

  • 22 January 2018
  • 2 replies
  • 2 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.

2 replies

S

 

Should add I am using FME 2017 build 17259.
M
Badge +2

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.

Reply


Community Stats

28,692
Posts
109,433
Replies
36,544
Members
Terms & ConditionsCookie settings
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.