We're using Access 2003, on XP systems. All users are on SP2.
We've written a database that works fine in IT, but the end users are not able to run it. The process includes exporting a table to a fixed-width txt file. The users are getting an error during the export.
When the export starts (and this happens in manual exports as well), we choose a Save As type of Text Files, and name the file (for example, test.txt).
We then click on Export, then select Fixed Width. As soon as we click Finish, an error box appears.
The title in the box is Export Text Wizard (there is no error number).
The contents of the box states:
The Microsoft Jet database engine could not find the object 'test#txt'. Make sure the object exists and that you spell its name and the path name correctly.
Note that the error message above has converted the "dot" to be a "pound". Also, the object shouldn't exists... we're trying to create it during the export.
Any ideas would be appreciated.