View Single Post
  #7 (permalink)  
Old June 23rd, 2004, 05:40 AM
Imar's Avatar
Imar Imar is offline
Wrox Author
Points: 72,073, Level: 100
Points: 72,073, Level: 100 Points: 72,073, Level: 100 Points: 72,073, Level: 100
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Utrecht, Netherlands.
Posts: 17,089
Thanks: 80
Thanked 1,587 Times in 1,563 Posts
Default

That depends on the database and the number of users. Most databases are multi user, so you shouldn't have a problem. But some database are limited by the number of users they can serve. Technically, an Access database cannot handle more than 255 users at the same time, but in practice, this limit is hit much sooner.

There is no real need to use stored procedures and transactions, just to enable a multi-user scenario. However, when data integrity is important, you'll have to use transactions anyway (even if you were the only user). You'll also find that Stored Procedures will make database / application development much easier in the end.

Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.
While typing this post, I was listening to: Sunburn by Muse (Track 1 from the album: Showbiz) What's This?
Reply With Quote