how do i set up a database to have more than one open at a time

[Guest]

I am trying to set up my database so that more than one computer can have it
open at a time. I have gone to tools/options/advanced and checked the share
button, but it will still only open on one computer. Any help would be
greatly appreciated.

 

[Rick Brandt]

I am trying to set up my database so that more than one computer can have it
open at a time. I have gone to tools/options/advanced and checked the share
button, but it will still only open on one computer. Any help would be
greatly appreciated.

Access is multi-user capable out of the box. Have you given full permissions to
all users on the folder where the MDB resides?

 

[John Vinson]

I am trying to set up my database so that more than one computer can have it
open at a time. I have gone to tools/options/advanced and checked the share
button, but it will still only open on one computer. Any help would be
greatly appreciated.

You should use the "Database Splitter Wizard" to split the database
into a "frontend" containing the forms, queries, reports, and so on;
and a shared "backend" containing the tables. Each user should have a
copy of the frontend, linked to the backend on a shared drive. It's
*possible* to share a single database, but it's not prudent: you'll
have bad performance, bloating, and a marked risk of corruption.

John W. Vinson[MVP]