Microsoft can't represent the join expression in the design view

Microsoft can't represent the join expression in the design view. I am running Access 2002 sp3

I am getting this message in a lot in queries with multiple joins. I have looked at the explanation for the error, but none of the situations apply. I just rejoin the fields between tables and they work. If I left them out they would not.
Since I have looked for the situations this error says causes this and have not found anything...is there anyone that could shed some light on other causes ?
join-problem.doc
proffittwareAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
Sometimes this can happen if Tables are renamed.  

Also, check Tools>>Options>>General Tab ... and be SURE that 'Name AutoCorrect' is turned OFF.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Also, you might want to apply the Hot Fix for SP3:

Office SP3 Issues:
http://news.office-watch.com/t/n.aspx?a=657
Hot Fix:
http://office-watch.com/kb/?945674

----
0
 
proffittwareAuthor Commented:
I know Name AutoCorrect is on.

On the Hot Fix...do I need to do it on each users computer or just the development.

0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Each computer.
Turn Auto Correct Off for sure - it has be confirmed to be the source of many other 'odd' issues also.

mx
0
 
proffittwareAuthor Commented:
Thanks...get back to you.
0
 
proffittwareAuthor Commented:
Turning off the AutoCorrect did the trick....Thanks.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.