Problems with shared DB for multiuser

  • Thread starter Thread starter Matteo
  • Start date Start date
M

Matteo

I encountered a problem with a shared .mdb file (access
2000). In fact I have created some dynamic reports (change
grouping, recordsource, etc) which do not what expected
when many users open the same file. It seems that the
first who opens it acquires some sort of rights which do
not allow other users to change particular report settings
or layouts. As this never happened to me I begin thinking
that this might be caused by winXP Sp2 or something
related to security. Has anybody any idea about how I can
get over it?
Thanks for any suggestion
Matteo
 
Hi.
It seems that the
first who opens it acquires some sort of rights which do
not allow other users to change particular report settings
or layouts. As this never happened to me I begin thinking
that this might be caused by winXP Sp2 or something
related to security.
Click to expand...

This behavior is by design. In Access 2000 and later, design changes to
Access-specific objects, such as forms, reports, modules, and commandbars,
require that the user have an exclusive lock on the database. The users who
opened the database after the first user do not have an exclusive lock and
therefore cannot make these design changes. For more information about
design changes in a multiuser environment, please see the following Web
page:

http://support.microsoft.com/kb/237938/EN-US/

HTH.

Gunny

See http://www.QBuilt.com for all your database needs.
See http://www.Access.QBuilt.com for Microsoft Access tips.

(Please remove ZERO_SPAM from my reply E-mail address, so that a message
will be forwarded to me.)
 
Back
Top