Export text wizard - "changes not successful"

[mcnpr]

Hello all,

So, this one's got me very confused...

I'm using the Export Text Wizard to output a query to a text file. All the other (similar-ish) exports work fine, but on this particular one I get the error message:

Export Text Wizard
The changes you requested to the table were not successful because they would create duplicate value in the index, primary key, or relationship. Change the data in the field or fields that contain duplicate data, remove the index, or redefine the index to permit duplicate entries and try again.

??? what changes?? what table?? I'm just trying to create a text file!! ??

I've checked the original tables which the query is based on (through a few layers of queries), and removed one accidental "autonumber" ID field, but I can't see anything else obviously wrong.... and I'm entirely confused how it will happily display the query results, but then won't let me export them!

The query is comparing two other queries, and returning results from "old", where the equivalent fields in "new" are null.

Any suggestions of where to start solving this?

Thanks

Nick

 

[Ranman256]

Sometimes access will give false errors ...
1. export/import if a export spec is incorrect (all text needs the spec )
2. if the export filename is not .txt or .csv (I forget which)
3 if your db is getting full. Are you well below the 2gig limit?

 

[JHB]

Did you try a "Compact & Repair"?
Could you post a sample database and a description how to reproduce the error?

 

[mcnpr]

Thank you both!

@Ranman256 - those are useful tips, I shall try and remember for future.... especially the size limit... but in this case the db is 'only' 600Mb

but - @JHB you win the prize - the 'compact and repair' worked! (It's always the obvious solution....) I have the database set to 'auto compact' on save, but forgot that this didn't do the 'repair' as well!

Thank you both for the quick replies

Nick

 

[JHB]

Good you got it solved by a "Repair"!