Re: Exclusive access to the database

Rick -

Do you mean that two managers can't modify the same report at the same time
(which sounds reasonable), or that no one can modify a report that is based
on data being edited at that time?

Thanks again,

-Bruce D


"Rick B" wrote:

> With versions of Access after 97, you cannot modify objects while they are
> being used. You should split your database into Front-End and BAck-End.
>
> --
> Rick B
>
>
>
> "Bruce D" <BruceD@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
> news:85CBA5A7-017D-4FF0-A6D7-917656A2529D@xxxxxxxxxxxxxxxx
> > Hello all,
> >
> > My company has three Access database files that were originally created in
> > Access 97 and was recently converted to Access 2003 (We replaced all of
> our
> > old workstations with new ones that came preloaded with Office Pro 2k3).
> The
> > problem we're encountering is most accurately described in KB 839782, "You
> > receive a '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.'
> error
> > message when you try to open database objects in Access."
> >
> > EXCEPT - The error message does NOT occur when there's only one user in a
> > database; there already IS only one .ldb file in each folder; and changing
> > the folder(s) did not help.
> >
> > This is becoming an issue because the managers are frequently modifying
> > reports while us peons are entering data into the tables. And yes, the
> data
> > and the structures are both in the same .mdb file. Don't ask. Anyway,
> this
> > was never an issue with 97, but now it's a problem.
> >
> > Anyone have any idea how to fix this? Is this by any chance connected to
> > the mysterious (to me) .mdw file(s)? And how do we preserve access (no
> pun
> > intended) to all three databases in this fashion?
> >
> > Thanks in advance,
> >
> > -Bruce D.
>
>
>
.

Relevant Pages

  • Re: Looking for inventory management and invoicing programs
    ... > Good point Rick, but I think most of the problematic issue with Y2K related ... Accounting program used 4 digits for data in the year ... Database program generated "automatic dates" using Julian ... It simply went nuts trying to report dates after 12/31/1999. ...
    (comp.sys.tandy)
  • Re: Multiple users on an Access database
    ... I think version 97 was the last one that allowed you to modify objects while someone else was using the mdb - not any more. ... I've split the database however I'm still encountering problems. ... design of a Report or Form the following message appears " Microsoft ... Access can't save design changes or save to a new database object because ...
    (microsoft.public.access.security)
  • Re: Exclusive access to the database
    ... Rick B ... > Do you mean that two managers can't modify the same report at the same ... >>> My company has three Access database files that were originally ...
    (microsoft.public.access.security)
  • Re: Copying Report from another database
    ... "Rick B" wrote: ... >> I have copied a report from a database into another database. ... I changed the Record Source to reflect the new database. ...
    (microsoft.public.access.reports)
  • Re: Need a lead for layout change in mde, if possible
    ... Hi Rick and thanks for the response. ... yes I know the purpose of the mde ... the coordinates of each control on the report would be based on ... > let them have modify. ...
    (microsoft.public.access.reports)
Quantcast