> The access db opens fine on my computer but when I open it on a
> different computer I get an error message. It is already opened
> exclusively by another user or you need permission to view data. The
> db is shared - I do not get it

"Joan Wild" wrote:

> Check the windows permissions on the folder where the mdb is located.  All
> users need create/read/write permission on the folder in order to create the
> associated ldb file.  If the first person in doesn't have this permission,
> they can't create the ldb and therefore open the mdb exclusively.
>
> You should also split the database.  Put the backend (contains just the
> tables/relationships) on the server, and give each user a copy of the
> frontend on their workstation.  The frontend contains all the other objects,
> and linked tables (linked to the tables in the backend)
>
>
> --
> Joan Wild
> Microsoft Access MVP
>
> freddy wrote:
> > The access db opens fine on my computer but when I open it on a
> > different computer I get an error message. It is already opened
> > exclusively by another user or you need permission to view data. The
> > db is shared - I do not get it
>
>
>

> I copied the db to his machine but I still get the same error - I did
> not create the db
>
> "Joan Wild" wrote:
>
>> Check the windows permissions on the folder where the mdb is
>> located.  All users need create/read/write permission on the folder
>> in order to create the associated ldb file.  If the first person in
>> doesn't have this permission, they can't create the ldb and
>> therefore open the mdb exclusively.
>>
>> You should also split the database.  Put the backend (contains just
>> the tables/relationships) on the server, and give each user a copy
>> of the frontend on their workstation.  The frontend contains all the
>> other objects, and linked tables (linked to the tables in the
>> backend)
>>
>>
>> --
>> Joan Wild
>> Microsoft Access MVP
>>
>> freddy wrote:
>>> The access db opens fine on my computer but when I open it on a
>>> different computer I get an error message. It is already opened
>>> exclusively by another user or you need permission to view data. The
>>> db is shared - I do not get it

"Joan Wild" wrote:

> Is this a secured database?
>
> --
> Joan Wild
> Microsoft Access MVP
>
> freddy wrote:
> > I copied the db to his machine but I still get the same error - I did
> > not create the db
> >
> > "Joan Wild" wrote:
> >
> >> Check the windows permissions on the folder where the mdb is
> >> located.  All users need create/read/write permission on the folder
> >> in order to create the associated ldb file.  If the first person in
> >> doesn't have this permission, they can't create the ldb and
> >> therefore open the mdb exclusively.
> >>
> >> You should also split the database.  Put the backend (contains just
> >> the tables/relationships) on the server, and give each user a copy
> >> of the frontend on their workstation.  The frontend contains all the
> >> other objects, and linked tables (linked to the tables in the
> >> backend)
> >>
> >>
> >> --
> >> Joan Wild
> >> Microsoft Access MVP
> >>
> >> freddy wrote:
> >>> The access db opens fine on my computer but when I open it on a
> >>> different computer I get an error message. It is already opened
> >>> exclusively by another user or you need permission to view data. The
> >>> db is shared - I do not get it
>
>
>