Link to home
Start Free TrialLog in
Avatar of wmb02
wmb02Flag for United States of America

asked on

" is not a valid name

I receive the following error message when attempting to open about 50 % of my queries in design after upgrading to Access 2007 from Access 2003.

" is not a valid name. Make sure that is does not include invalid characters or punctuation and that it is not too long.

I've tried the compact/repair without success.  I also created a blank database, then imported the objects from the originall db without success.  Would appreciate any assistance you can give me.  I tried the above suggessions after reading previous posts but had no luck.
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

"I also created a blank database, then imported the objects from the originall db without success."

Try this .... import ALL of the Tables *first* ... and then queries, etc.

mx
How many Queries do you have?  Would it be feasible to re-create them by:
In the old database, open each query in design view, click View, choose SQL View, hightlight and copy the code out
in the new database, start a new query in design view, click View, choose SQL view, paste in your SQL code
 
Is there any way you can post both your old and new databases?
Avatar of wmb02

ASKER

I will try both suggestions and will let you know the outcome.
Avatar of wmb02

ASKER


Hello, thanks for your help.  I did try to import just the tables first&.  And I am not able to open the problem tables in SQL view or design view&  thanks.
You won't be able to open tables in SQL view.  Only the queries.  Your post seemed to me that you were having problems with just your queries.  Any chance you can post your databases?  or at least their structure (take all of the data out)?
 
AR
"
" is not a valid name"

Have you opened one of there queries in design view to see what's up?  Do you see a lot of Expr1, Expr2, etc ?

mx
Avatar of wmb02

ASKER

I can't even open the query.  Whenever I try opening the query I receive the error message:
" is not a valid name. Make sure that is does not include invalid characters or punctuation and that it is not too long.
 
ASKER CERTIFIED SOLUTION
Avatar of DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
DatabaseMX (Joe Anderson - Former Microsoft Access MVP)
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of wmb02

ASKER

Used some of the suggestions, however suggestions didn't completely resolved my issue.  PLEASE CLOSE QUESTION.
Avatar of Kelzud
Kelzud

Access does not permit illegal characters in the file path or name.  The list below applies to web Access, but I believe that it also impacts desktop Access:

    Brackets ([])
    Forward slash mark (/)
    Backward slash mark (\)
    Ampersand (&)
    Tilde (~)
    Question mark (?)
    Asterisk (*)
    Pipe or vertical bar (|)
    Angle brackets (<>)
    Quotation marks (")
    Number sign (#)
    Semicolon (;)
    Colon (:)
    Plus (+)
    Period (.)
    Two periods (..)

Please see the following article (based on web Access) for more information:
http://support.microsoft.com/kb/256385

I have the same problem as you, and as my userID for my company computer is firstname.lastname I will always have this error.  That is unless there is a way to suppress the message through VBA or an application setting for suppressing error messages that arise from the application and not VBA.

Until then I have taken heart that while the error does appear, functionality after clicking okay is not affected in my case and I am able to perform filters, etc., without hindrance.

Cheers,
K