Results 1 to 7 of 7

Thread: Microsoft Access Issue

  1. Jan 16th, 2003, 07:40 PM #1
    fkheng
    fkheng is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2002
    Posts
    332

    Microsoft Access Issue

    I am using the DAO method for my project, and intend to build a multi-user program. Is it true that using DAO, only one person can access the Access Database at a time?
    Reply With Quote Reply With Quote
  2. Jan 16th, 2003, 08:55 PM #2
    Beacon
    Beacon is offline
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    Nope.
    Reply With Quote Reply With Quote
  3. Jan 16th, 2003, 09:04 PM #3
    Chris
    Chris is offline
    PowerPoster Chris's Avatar
    Join Date
    Jan 1999
    Location
    K-PAX
    Posts
    3,238
    i guest MS Access can support 10-20 connection at the same time. please correct me if i'm wrong.
    My Virtual Home - My Blog
    Reply With Quote Reply With Quote
  4. Jan 16th, 2003, 10:46 PM #4
    Beacon
    Beacon is offline
    PowerPoster Beacon's Avatar
    Join Date
    Jan 2001
    Location
    Pub Floor
    Posts
    3,188
    If performance is not an issue Access can hold 255 concurent users.

    Somone say it degrades after 20 or so i'd push that up to 60-70+.
    Depending on the setup.

    b
    Reply With Quote Reply With Quote
  6. Jan 17th, 2003, 12:42 AM #5
    Chris
    Chris is offline
    PowerPoster Chris's Avatar
    Join Date
    Jan 1999
    Location
    K-PAX
    Posts
    3,238
    oh..ya... that good, as i only try out max of 10 connection concurrent don't have that much of client in the app i have dev
    My Virtual Home - My Blog
    Reply With Quote Reply With Quote
  7. Jan 17th, 2003, 05:05 AM #6
    goatsucker
    goatsucker is offline
    Hyperactive Member goatsucker's Avatar
    Join Date
    Dec 2002
    Location
    Leeds, England
    Posts
    283
    I have worked on an Access database with >50 users using DAO. Performance was merely OK, but we had serious corruption problems. Mostly is was with records with memo datatypes, and I suspect if you avoid data types which store a pointer to where the data is stored (OLE datatypes are similar) this problem may not occur.

    I would err on the side of caution and plump for SQL server if more than 10 users were required, but for just 10, you should be fine.
    After all "Rust Never Sleeps"
    Reply With Quote Reply With Quote
  8. Jan 17th, 2003, 09:13 AM #7
    fkheng
    fkheng is offline

    Thread Starter
    Hyperactive Member
    Join Date
    Jan 2002
    Posts
    332
    thanx for the opinoins, well...hm.......in truth, i'm onli developing a minor application to support less than 10 users for sure
    so if i place the database at the server, how should i connect the client PCs to the database located on the server?
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width