Access 2010 Compact - Not Valid File Name (?)
Cannot find the source of compact & repair error "Not a Valid File Name"
I have a simple database that I have been using as essentially a telephone directory for remote colleagues. I create queries on the fly for different filters. I import new updated tables monthly and the application is over a year old. This is probably the first time I have attempted to compact in over a year.
Any ideas?
I have a simple database that I have been using as essentially a telephone directory for remote colleagues. I create queries on the fly for different filters. I import new updated tables monthly and the application is over a year old. This is probably the first time I have attempted to compact in over a year.
Any ideas?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
That is a good suggestion, importing objects to a new database. Given that this is over year old and given that is a simple, directory of contact info. It's not worth the time and energy to troubleshoot this.
It would be nice if the error message gave me an idea of where it is finding the invalid file name? The displayed help file.... is no help. It is basically a longer version of the original displayed error without providing any substantive additional information.
Thanks
It would be nice if the error message gave me an idea of where it is finding the invalid file name? The displayed help file.... is no help. It is basically a longer version of the original displayed error without providing any substantive additional information.
Thanks
geekmee2,
"It would be nice if the error message gave me an idea of where it is finding the invalid file name? The displayed help file.... is no help. It is basically a longer version of the original displayed error without providing any substantive additional information."
...Rest assured, ...we feel your pain.
;-)
Most of what C&R does is internal to the database, so a "FileName" might mean something other than a disk filename.
;-)
JeffCoachman
"It would be nice if the error message gave me an idea of where it is finding the invalid file name? The displayed help file.... is no help. It is basically a longer version of the original displayed error without providing any substantive additional information."
...Rest assured, ...we feel your pain.
;-)
Most of what C&R does is internal to the database, so a "FileName" might mean something other than a disk filename.
;-)
JeffCoachman
ASKER