Multiple users

J

Jasper Recto

What's the rule on having multiple users access a access database. I
created a small program for users to run reports and other things. Is
access automatically setup so that multiple users can open the same program
or do I have to do anything?

Thanks,
Jasper
 
C

Cheech73

For multiple users, you need to "split" your DB, keeping the front end on the
user's pcs, and the back end in a shared location. There is a database
splitter wizard under "Tools"...
Good luck...
-FT
 
J

John Vinson

What's the rule on having multiple users access a access database. I
created a small program for users to run reports and other things. Is
access automatically setup so that multiple users can open the same program
or do I have to do anything?
Click to expand...

Access is multiuser by default, out of the box. You can (and must, for
instance if you'll be doing some kinds of work on the design of
database objects) open the database exclusively, but that's the
exception.

It's good practice to use the Database Splitter Wizard, though; this
splits your database into a "backend", a shared database containing
nothing but Tables, and a "frontend", a user-interface database
containing the Forms, Reports, Queries and so on. Each user would have
a copy of the frontend on their own machine, linked to the tables in a
shared backend on a network folder.

See http://www.mvps.org/access and
http://www.granite.ab.ca/access/tipsindex.htm for some useful
resources on setting up multiuser databases.

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps
 
Top