I upgraded from Access 2003 to 2010 and have an issue with my specification file format for one of the DB's. The format looks good but in 2010, the second column in the exported txt file gets shifted throwing all off all of the other roles. The first stops on column 11 with the second field starting on column 12. I even recreated the spec file in 2010 thinking the 2003 files was corrupted. Currently, I have to run the file in Access 2003 just so I get the correct output format.
See attached image file showing the two outputs and the Spec File format.
Also, is there a way to edit the spec file outside of the DB?