Access 2003 Extra queries appear when removing Name AutoCorrect with the Custom Startup Wizard. How do I fix this?
Posted on 2008-06-18
I have an Access 2003 DB split FE/BE with user level security. When I run the DB through the Custom Startup Wizard and check "Resolve Any Pending Name Changes" I suddenly get a number of new queries of the form ~sq_ffrmSomething. Because these are not owned by the current user they cause permissions problems.
When I look at General Options (in my ORIGINAL DB) "Track Name AutoCorrect Info" is NOT checked. So why is there even anything to resolve? What is happening here and what do I do to correct it?