MS Access Macro error on TransferText

[john.l.lopez]

I am creating an Access database as a tool to do a data migration from
an RDBMS to an object oriented DB

I have a series of cascading queries that take the legacy RDBMS data
and morph it into the needed object metadata. I then take the metadata
query results and from it create a query that generates the OODB
script code to create and populate the objects in the target OODB. It
looks something like:

origTable
-query_createMetaData
-query_createObjectClassSpecificMetadata
-query_createObjectCreationScriptOutputforOODB

I am keeping this all together via an Access Macro, as I have many
object classifications that I am creating from the RDBMS legacy table
data.

All of the above works except the last macro line: TransferText

I have created the needed export specification and it works it I do a
manual export from the above final query.

However when I attempt to run it from the above macro, I get the
following error: "Cannot Update. Database or object is read-only."

It then displays a dialog:
title="Action Failed"
Condition="True"
Action Name="TransferText"
Arguments="3, Mql_createBO=Drawing Export Specification,
mql_createBO=Drawing, C:\...\mql_createBO-Drawing.mql, No, "

Step & Continue are greyed out ... only Halt is hilited.

any thoughts? Thanks for your help in advance.

Regards
John Lopez

 

[Ken Snell \(MVP\)]

TransferText will not export to a file that has an extension other than
..txt, .csv, .tab, or .asc. This is a security feature within ACCESS. It
appears that you're trying to export to a file with extension of .mql.