wmb02
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.
" 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.
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?
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?
ASKER
I will try both suggestions and will let you know the outcome.
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
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
" 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
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.
" 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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Used some of the suggestions, however suggestions didn't completely resolved my issue. PLEASE CLOSE QUESTION.
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
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
Try this .... import ALL of the Tables *first* ... and then queries, etc.
mx