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

  • Thread starter Thread starter Guest
  • Start date Start date
G

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.
 
Michelle Woodard said:
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.
Click to expand...

Access is multi-user capable out of the box. Have you given full permissions to
all users on the folder where the MDB resides?
 
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.
Click to expand...

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]
 
Back
Top