TonyT said:
If the name itself isn't the problem, then what code are you using to save
the form, or are you just pressing the Save As icon?
Right clicking on the form and choosing Save As...
The wording of the error message makes it sound like you might have a
function or public sub using reserved words that are causing the issue.
Will check for reserved words.
Do you have any code that references that particular file or folder that
the
error message generates?
Will check this also.
Of course it could be that the database is corrupt or mis-compiled. Do a
search on here for corrupt database to see the many and varies methods of
recovery depending on your version of Access.
Recently re-compiled using \compile switch.
This happened once before (sometime around last June) and each time I tried
to Save As, one of these .tmp files was written to the parent folder of
where the .mdb resides. Opening the files in Notepad, they were just copies
of all the code in the form looking much like it does in the VBA editor. I
couldn't figure it out, so I just moved to a different machine where it
behaved properly. I am now trying it on two machines and the misbehavior is
identical, except the .tmp files are not being saved anywhere that I can
see.
Thanks again,
Ripper