what database should be used for multiple users

S

sparkle_vy

help! i'm developing a database, very complicated one and it will be saved
in a server. there will be multiple users for this database, what version of
ms access can i use? is there such thing as ms access network version?
 
R

Rick B

Any version of Access will work.

Each user will need Access on their local machine, unless you plan to
purchase the developer's edition and package the database application with a
run-time version of Access.

Do your users all have the application?

How many users will you have?

Are you a pretty advanced application developer?

Rick B
 
J

John Vinson

help! i'm developing a database, very complicated one and it will be saved
in a server. there will be multiple users for this database, what version of
ms access can i use?
Click to expand...

1.0, 1.1, 2.0, 95, 97, 2000, 2002, or 2003 should work just fine.
Access is multiuser out of the box.
is there such thing as ms access network version?
Click to expand...

All of the above.

What you'll need to do is use the Database Splitter Wizard, or
manually split the database into a "Frontend" containing the forms,
reports, queries and so on, linked to a shared "Backend" containing
only the data tables. Each user will need Access installed (either
retail Access or the "runtime" available from the Developer's
Toolkit), and a copy of the frontend.


John W. Vinson[MVP]
 
Top