A2003 - custom menu bar problem with multiple log ins

[jeff blumsom]

This is bizarre! I have an big (90+ tables, over 100 forms) application
that has a custom toolbar. This is set as the default toolbar in the
start-up options. It is also the toolbar assigned to the first visible form
that fires up.

When a second user log in to the program file (the data is in a back-end
file) the following message appears:
"You do not have exclusive access to the database at this time. If you
proceed to make changes, you may not be able to save them later".

You click OK and it appears again - repeat about 20 times (!) and the
problem disappears. The number of times it appears seems to depend on the
number of items in the original access toolbar before the custom toolbar is
loaded. If you restore the default toolbar and remove the custom toolbar
from the first visible form the problem goes away. The problem does not
seem to occur with users using Access2000.

Even more bizarre - the problem did not exit until I upgraded the program,
and then once it had appeared it occured even for the original program (i.e.
the old version).

Can anyone offer any explanation?

Jeff Blumsom

[david epsom dot com dot au]

It appears that you have changed or enabled your default
toolbars. The value saved in your database is not the
same as the value saved in your user settings. This
is particularly a problem because you have two sets
of user settings, because you are sharing the FE file.

I suggest that you delete or rename in the registry
of all of your users:

Hkey Current
User\software\microsoft\office\11.0\access\setting s\commandbars.

or not use a shared FE file.

(david)
"jeff blumsom" <je**********@btopenworld.com> wrote in message
news:dv**********@nwrdmz01.dmz.ncs.ea.ibs-infra.bt.com...

This is bizarre! I have an big (90+ tables, over 100 forms) application
that has a custom toolbar. This is set as the default toolbar in the
start-up options. It is also the toolbar assigned to the first visible
form that fires up.

When a second user log in to the program file (the data is in a back-end
file) the following message appears:
"You do not have exclusive access to the database at this time. If you
proceed to make changes, you may not be able to save them later".

You click OK and it appears again - repeat about 20 times (!) and the
problem disappears. The number of times it appears seems to depend on the
number of items in the original access toolbar before the custom toolbar
is loaded. If you restore the default toolbar and remove the custom
toolbar from the first visible form the problem goes away. The problem
does not seem to occur with users using Access2000.

Even more bizarre - the problem did not exit until I upgraded the program,
and then once it had appeared it occured even for the original program
(i.e. the old version).

Can anyone offer any explanation?

Jeff Blumsom