Access 2003 Extra queries appear when removing Name AutoCorrect with the Custom Startup Wizard. How do I fix this?

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?
anAppBuilderAsked:
Who is Participating?
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Connect With a Mentor Database ArchitectCommented:
"Custom Startup Wizard"

I've never used that ...

If you uncheck everything to do with N.A.C ... then I don't see a problem.

mx
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
~sq_ffrmSomething

When you use an SQL statement as the Row Source for a combo box, list box or Form/Report Record Source, this is how Access stores that in the MSysObjects table in the Name field.  I'm not sure how Name Auto Correct ties into this, but I *never* turn on Name Auto Correct - because it's a poorly implement feature.

mx
0
 
anAppBuilderAuthor Commented:
Thanks, mx

I don't have it turned on either.  These queries do not show up until I run the DB thru the Custom Startup Wizard with  "Resolve Any Pending Name Changes" checked.  According to Microsoft's help this checkbox "Clears the name map. The name map is used in conjunction with the Name AutoCorrect feature to automatically propagate name changes for tables, forms, reports, and fields throughout your Access databases. ...."

Since I'm not using Name AutoCorrect, shoudl I just leave that box unchecked?
0
Cloud Class® Course: Microsoft Windows 7 Basic

This introductory course to Windows 7 environment will teach you about working with the Windows operating system. You will learn about basic functions including start menu; the desktop; managing files, folders, and libraries.

 
anAppBuilderAuthor Commented:
Thanks againi.  I

I tried running without that box checked.  The queries still show up and they are not there in the original DB.  Also the DB that comes out of the Custom Startup Wizard is a third smaller than the source DB.  Any idea what the wizard does?  It appears to have a better compact thatn Conpact and Repair.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
Where is the wizard ?  I have no clue.

mx
0
 
anAppBuilderAuthor Commented:
The wizard is part of the Microsoft Office Access Developer Extensions that come with Visual Studio 2005 Tools for Microsoft Office Systems
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ok ...but why are you using that tool ?

mx
0
 
anAppBuilderAuthor Commented:
It is an easy way to strip menus, the db window and form properties dialogs from a front end that goes to users.  
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
ok. Well, I don't really have a need for that wizard, as my start up code does all of that, etc.

So ... not sure what I can say here, sorry.

mx
0
 
anAppBuilderAuthor Commented:
So you just write vb code to diable the menus etc?
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I have an MDA Library that has startup code which I've used for years. So, basically Yes.

I'm not saying to not use the wizard, but I have no clue about N.A.C ... and it's not an issue for me.

mx
0
 
anAppBuilderAuthor Commented:
Thanks!  You answered the question.  I'm going to post another question for an expert on the wizard, because I want to know if it is safe to use the wizard as a better compactor.
0
 
DatabaseMX (Joe Anderson - Microsoft Access MVP)Database ArchitectCommented:
I don't know why it wouldn't be safe ... nor do I know why it would compact better - unless it's using the CompactDatabase method - and that some how compacts more, but I've never heard that.

mx
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.