Multiple users

[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

 

[Guest]

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

 

[Joseph Meehan]

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

You can use a basic database with multiple users. However you can
expect less problems and better reaction if you "Split" the database. You
put the "back end" on the server and each user has a "front end."

The back end holds just the data that is changed. The front ends hold
most of the queries, reports, forms, and some non-volatile tables where the
information will not change.

 

[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?

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