Results 1 to 11 of 11
  1. #1
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Using MSDE or Jet? (2003)

    Assuming a company wants a shared database to be accessible to, say, 10 users. Would you not advise building it directly in Access using Jet, if the developer is comfortable with this environment, along with splitting the database and other optimizing techniques? Surely there is a great deal of overhead in terms of learning SQL/ MSDE, and the database can still be Upsized at a later date.. Are there any additional cost implications for MSDE? Thanks, Andy.

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Using MSDE or Jet? (2003)

    It depends on how the database will be used. If all 10 users will frequently be entering/editing data at the same time in an Access database, they may experience performance problems. If there will be only 5 users simultaneously entering/editing data, while the others are only browsing, it should be OK.
    Others will probably comment on your questions about MSDE.

  3. #3
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Using MSDE or Jet? (2003)

    I thought there was basically a 5-user limit for MSDE. Not an absolute limit, but my understanding was that performance degraded drastically beyond that.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  4. #4
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Using MSDE or Jet? (2003)

    With 2002 and 2003, the SQL 2000 version of the MSDE uses a more sophisticated throttling mechanism, so the 5-user limit isn't hard and fast. It's more dependent on the amount of activity, and you also have a reduced database size. We normally develop with the full version of SQL Server however, as the tools available with it are far more powerful than what you get with the MSDE. And frankly the cost of a SQL Server Standard system is pretty reasonable compared to the cost of the server it runs on. Just my <img src=/S/2cents.gif border=0 alt=2cents width=15 height=15>.
    Wendell

  5. #5
    Gold Lounger
    Join Date
    Jun 2001
    Location
    Crystal Beach, FL, Florida, USA
    Posts
    3,436
    Thanks
    1
    Thanked 34 Times in 34 Posts

    Re: Using MSDE or Jet? (2003)

    I realize that the 5-user limit is not as hard-and-fast as it once was, but I was under the impression you could immediately start seeing a performance degradation.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Using MSDE or Jet? (2003)

    I don't have much experience other than anecdotal, but a peer MS MVP tells me that he's seen it work well in systems (using ODBC links) with up to 10 or 15 users with a light load. I did have a less than happy experience trying to use the original MSDE and ODBC, where with 2 users performance was not great, and with 3 it was awful. In that version they apparently throttled things based on the number of connections. My take would be to go ahead and try it, and if it doesn't cut it, upgrade to the standard SQL Server.
    Wendell

  7. #7
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using MSDE or Jet? (2003)

    Are there no licensing costs involved in using MSDE?

  8. #8
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using MSDE or Jet? (2003)

    Could anyone recommend a book on using the MSDE? Or would a book on SQL Server serve just as well (excusing the terrible pun). Andy.

  9. #9
    Plutonium Lounger
    Join Date
    Dec 2000
    Location
    Sacramento, California, USA
    Posts
    16,775
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Using MSDE or Jet? (2003)

    MSDE *is* SQL Server, so a standard SQL Server book should work. Some of the Access books have sections on working with MSDE as well.
    Charlotte

  10. #10
    Super Moderator
    Join Date
    Aug 2001
    Location
    Evergreen, CO, USA
    Posts
    6,623
    Thanks
    3
    Thanked 60 Times in 60 Posts

    Re: Using MSDE or Jet? (2003)

    Answering several of your questions, there is no licensing cost associated with MSDE. And it comes as a part of all Access versions from 2000 up, though doesn't install by default. As to books, there are two that I recommend - one is by Chipman and Baron - Microsoft Access Developer's Guide to SQL Server , and the other is the Enterprise volume of Alison Balter's Alison Balter's Guide to Access 2002 Enterprise Development. The first is more of a technical details view of the world, while the second contains lots of what I consider good pragmatic advise along with some of the how-to kind of stuff. Finally, note that the management tools with the MSDE for doing backups, database maintenance are rather limited compared to what you get with any full version of SQL Server, even the Developer version. That is especially true with Access 2000. You can use an ADP front-end to do some things to offset that somewhat, but there are still some issues that you will need to consider in the long term. Hope this helps.
    Wendell

  11. #11
    5 Star Lounger
    Join Date
    Mar 2001
    Posts
    989
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Using MSDE or Jet? (2003)

    Thanks very much.

Posting Permissions

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