Home All Groups Group Topic Archive Search About

Access database concurrently?

Author
3 Nov 2006 1:44 PM
Troper
My problem is:

I have a shared database so multiple users can access it.   All users can
connect to the shared folder and all users can open the database inside the
folder but can not open the database concurrently.  If a user tries to open
the database the .lbd file is created and everything works fine but when
another try to open the database, if someone else already has the database
open, absolutely nothing happens. You can double-click as much as you want,
and the file won't open.


Any help here?

--
Thanks
Troper

Author
3 Nov 2006 2:57 PM
Joan Wild
You really need to split the database.  Put just the backend (contains
tables/relationships) on the server.  Give each user a copy of the frontend
(all other objects and links to the tables in the backend) on their PC.

--
Joan Wild
Microsoft Access MVP

Troper wrote:
Show quoteHide quote
> My problem is:
>
> I have a shared database so multiple users can access it.   All users
> can connect to the shared folder and all users can open the database
> inside the folder but can not open the database concurrently.  If a
> user tries to open the database the .lbd file is created and
> everything works fine but when another try to open the database, if
> someone else already has the database open, absolutely nothing
> happens. You can double-click as much as you want, and the file won't
> open.
>
>
> Any help here?
>
> --
> Thanks
> Troper