Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Question about Access2000...

Status
Not open for further replies.

MoonMullen

Programmer
Jun 13, 2001
25
0
0
US
Is Access2000 tranactional? Can it handle numerous, from 3 to 30, users in the database at the same time? They would all be updating a central table with text information. [smarty]
 
Access can handle up to 255 users at the same time all working on the same table if everything is set up correctly.

Autoeng
 
If you are in a multi user enviroment more the 10 people you should think serously about changing databases. to something like SQL or MYSQL which all have GUI interfaces like access and use SQL to access data.

or you can use Microsoft Destop Engine which is a scaled down version of SQL and a 10 user limit.

There are practiculy no limitations in MYSQL or SQL server

MYSQL can be used freely. with access depening how it is used you may have to by licenses for each user at $288 a pop

and another Reason speed
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top