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.

Table and query objects

Any ideas?
geekmee2Asked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

geekmee2Author Commented:
The database file name is: "ProgramCentral_2013"
0
Jeffrey CoachmanMIS LiasonCommented:
How "exactly" are you running the Compact and repair utility?
Code?, ..manually, ?

You may also try creating a brand new database file and importing all the objects
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
geekmee2Author Commented:
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
0
Jeffrey CoachmanMIS LiasonCommented:
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
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.