Using Queue to Export Multi-table Relational Data to Access 2000 Fails

Dave Warren

I've been having an issue running queues that run an export using Microsoft Access 2000 Database as the output format. For some reason if the export contains more than one table in the output, and the export is set to "Export one-to-many records in separate tables" the queue always fails. I've confirmed that the export itself runs perfectly, and that running this export in a queue with a DIFFERENT relational output format (such as Microsoft Access 97 Database) also works perfectly. The issue only presents itself when the export contains more than one table in the output, and the output format is set to Microsoft Access 2000 Database. Is this a known bug? I'm currently running version 7.93.5782.0 I can provide more details if required! Dave

Mark Zarbailov

Dave Warren:
I've been having an issue running queues that run an export using Microsoft Access 2000 Database as the output format. For some reason if the export contains more than one table in the output, and the export is set to "Export one-to-many records in separate tables" the queue always fails. I've confirmed that the export itself runs perfectly, and that running this export in a queue with a DIFFERENT relational output format (such as Microsoft Access 97 Database) also works perfectly. The issue only presents itself when the export contains more than one table in the output, and the output format is set to Microsoft Access 2000 Database. Is this a known bug? I'm currently running version 7.93.5782.0 I can provide more details if required! Dave

The issue could relate to a new feature of RE 7.93. In this version, you can use custom names for fields. Mark

Darrel Giesbrecht

Dave Warren:
I've been having an issue running queues that run an export using Microsoft Access 2000 Database as the output format. For some reason if the export contains more than one table in the output, and the export is set to "Export one-to-many records in separate tables" the queue always fails. I've confirmed that the export itself runs perfectly, and that running this export in a queue with a DIFFERENT relational output format (such as Microsoft Access 97 Database) also works perfectly. The issue only presents itself when the export contains more than one table in the output, and the output format is set to Microsoft Access 2000 Database. Is this a known bug? I'm currently running version 7.93.5782.0 I can provide more details if required! Dave

 I'm having the same problem. It's a bit more critical for me in that we have switched to MS Office 2013 and Access13 won't open an Access 97 database. If I want one-to-many tables, I have to use Access 2000 or higher.

Anybody have a solution?