microsoft.public.access

Strange that it should be different between 2000 and 2003, but
it's always been a strange corner of Access functionality.

Your personal preferences are stored in the registry. Your
database settings are stored in the database. Even in A97 it
was possible for database preferences to reset your personal
preferences, and your personal preferences to reset your
database preferences, leading to a loss of the menu items
that allowed you to reset your menu, recoverable only by
coding or simultaneous registry changes and restore from backup.

I have no idea how that worked, and I never understood it,
and eventually we worked out how to avoid the problem, which
was more important than understanding it.

In your particular case, I would consider a registry script to
delete your Access preferences from the registry. One click
and they're gone. They magically restore to default next time
you open Access.

HKCU\software\microsoft\office\11\access\settings

(david)


"Can Of Worms" wrote in message
news:CF8FC328-38C4-4911-A8D8-37F488916B70@microsoft.com...
> Access 2003 is... acting wierd.
>
> I use somewhere between 20 and 30 different access databases every week,
97,
> 2000, and 2003 formats included.
>
> I recently began using 2003 almost exclusively, in part to re-write
several
> of those databases to smooth them out and make them faster and more user
> friendly. Ever since I have started this however, the application settings
> and options keep changing. I keep losing my system pre-set toolbars,
having
> buttons move in my toolbars, losing the close X button in the upper right
> hand corner for 1 set of stuff (only lost it for queries right now, as an
> example), having the 'show windows in taskbar' option check and uncheck
> itself...
>
> I believe it may be due to pre-selected options in different databases
> carrying over between databases. I know how to 'fix' each issue as it
shows
> up, (get my toolbars to show back up, etc...) but i am tired of resetting
> everything back to defaults one by one every time i open a database.
>
> It never did this in 2000, I have to believe that it is part of
Microsoft's
> "Let me help you do it, I think I know what you want" coding, like Word's
> auto-formatting.
>
> Is there any way to lock the settings/options in place so they don't keep
> changing like this?
>
> Getting annoyed,
> -CoW