C
connomar
Hi,
One of my rather old databases that originated on Office 97 has a weird
problem. I cannot use the query designer on most, but not all of the
queries. I get the message:
" is not a valid name. Make sure that is does not include invalid
characters or punctuation and that is not too long.
Example name:- qryDoTransfer
I can view the sql, and yesterday I recreated the query using the designer
by reading through the sql. At first, it worked perfectly, as does the
original, and I was able to go back to the designer and make changes. Then,
I renamed the old query and named the new query with the old name, and found
I was back to square one. I don't think I am alone having searched the Net
for this problem, but no solutions as yet.
I also tried running a convert on the database, but this completely broke
it. None of my VB code would run. I got the message File not found, as it
tried to run the first FormLoad VB code, then dumped me in the code but
wouldn't let anything run.
Anyone got any ideas?
Martin
One of my rather old databases that originated on Office 97 has a weird
problem. I cannot use the query designer on most, but not all of the
queries. I get the message:
" is not a valid name. Make sure that is does not include invalid
characters or punctuation and that is not too long.
Example name:- qryDoTransfer
I can view the sql, and yesterday I recreated the query using the designer
by reading through the sql. At first, it worked perfectly, as does the
original, and I was able to go back to the designer and make changes. Then,
I renamed the old query and named the new query with the old name, and found
I was back to square one. I don't think I am alone having searched the Net
for this problem, but no solutions as yet.
I also tried running a convert on the database, but this completely broke
it. None of my VB code would run. I got the message File not found, as it
tried to run the first FormLoad VB code, then dumped me in the code but
wouldn't let anything run.
Anyone got any ideas?
Martin