My collegue and I are accessing a database using MS Access 2007. I made a change to the query in the database and then closed the database (saved changes). When my collegue went back to access the same database and tried to open the modified query in the database it DOES NOT open in design mode, it opens automatically in SQL mode. I have never seen this behaviour before, he can access rest of the queries in design mode just fine , only this query that i modified. I can open it in design mode but not him.
Any ideas ?