My suggestion is that one of your end users may be opening the database
exclusively and thus it doesn't matter what the shared mode is.
Your best bet may be to make an MDE file (Tools - Database Utilities - Make
MDE file) and copy the MDE file to each user locally. If you have as few
users as you seem to have, it shouldn't be a problem. That way they can't
mess with your code or designs (purposefully or by accident).
hth,
Gary
"Jack Black" <(E-Mail Removed)> wrote in message
news:%(E-Mail Removed)...
> Hi Joan
>
> Thanks for the reply.
>
> Everyone has full permissions to the folder. It's just that Access 2000,
> even though in the "share" mode, still comes back with the error, "Cannot
> use.. database.mdb; file already in use" error message.
>
> Any ideas?
>
> Thanks, Jack
>
> "Douglas J. Steele" <NOSPAM_djsteele@NOSPAM_canada.com> wrote in message
> news:%(E-Mail Removed)...
> > What permissions do your users have on the folder where the MDB file is
> > located?
> >
> > They need Read, Write, eXecute and Delete access.
> >
> > --
> > Doug Steele, Microsoft Access MVP
> > http://I.Am/DougSteele
> > (No private e-mails, please)
> >
> >
> > "Jack Black" <(E-Mail Removed)> wrote in message
> > news:#(E-Mail Removed)...
> >> HI All
> >>
> >> I have my access 2000 database in "share" mode so many users can use it
> >> at
> >> once.
> >>
> >> However, even though it's set for sharing, it still won't allow more
than
> >> one user at a time.
> >>
> >> Any ideas?
> >>
> >> Thank you, Jack
> >>
> >>
> >
> >
>
>
Similar Threads
