Results 1 to 4 of 4
  1. #1
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Performance Access/MSDE (Access 2000)

    Assuming one optimises a front end would having the back end data stored in an MSDE give better performance than the back end being an Access 2000 format?

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

    Re: Performance Access/MSDE (Access 2000)

    Usually, but it depends on whether you're talking about an ADP or an MDB. With the mdb, unless you are building the app from the ground up rather than converting an application, you'll have to make some significant changes to your code in order to harness the power of SQL Server rather than still being at the mercy of the Jet engine.
    Charlotte

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

    Re: Performance Access/MSDE (Access 2000)

    See <!post=my reply,152300>my reply<!/post> on your question of several users trying to use an MDE. Also, note that if you are saving the back-end on your local hard drive in a single user mode, you would be hard pressed to notice any performance gain from using an MDE.
    Wendell

  4. #4
    4 Star Lounger
    Join Date
    Jan 2001
    Location
    Altnau, Thurgau, Switzerland
    Posts
    447
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Performance Access/MSDE (Access 2000)

    Actually the FE is neither MDB or ADP - it's coded in C++, currently onto an Access mdb (what the end users originally specified). The question that has been raised recently is how to get more performance / stability. SQL Server would be overkill in some circumstances.

Posting Permissions

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