Results 1 to 5 of 5
  1. #1
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, New South Wales, Australia
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    MSDE 2000 (Access 2003)

    I need to develop a database which has a transaction log because that's what the client wants. At the moment, I'm exploring my options. Do I recommend SQL Server? Or does anyone know if SQL Server Desktop Engine (MSDE 2000) has transaction log capability? Or should I stick with Access 2003 and create my own? Does anyone have any information re creating transaction logs in Access?

    Any suggestions would be greatly appreciated.
    Thanks
    Nick

  2. #2
    Bronze Lounger
    Join Date
    Nov 2001
    Location
    Arlington, Virginia, USA
    Posts
    1,394
    Thanks
    0
    Thanked 3 Times in 3 Posts

    Re: MSDE 2000 (Access 2003)

    Don't have much experience using MSDE, recommend check these links for more info:

    MS SQL Server - MSDE 2000 Home

    MSDE 2000 Technical Resources

    MSDN - Microsoft Data Engine (MSDE) for Microsoft Visual Studio 6.0: An Alternative to Jet for Building Desktop and Shared Solutions

    On last link listed, see Table 1, Database Requirements - according to table, SQL Server and MSDE support Transaction Logging, while MS Access (Jet) doesn't. In general MS recommends using MSDE rather than Jet if you think you may eventually upgrade to SQL Server. You could always try to program your own Transaction Logging functionality in an Access database (aka, reinvent the wheel) but it is not likely that anything you write yourself will be as efficient or reliable as the built-in functionality provided by MSDE or SQL Server. I have not attempted to do so myself. Recommend review the information provided by Microsoft - the sites listed above provide many more links for more detailed info re MSDE engine.

    HTH

  3. #3
    3 Star Lounger
    Join Date
    Nov 2001
    Location
    Sydney, New South Wales, Australia
    Posts
    216
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: MSDE 2000 (Access 2003)

    Thanks. I had seen the first two docs but it was the third which gave me the info I needed to make an informed decision.

    Cheers
    Nick

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

    Re: MSDE 2000 (Access 2003)

    Although the MSDE comes for free with Access 2000+, if you go forward with the SQL Server back-end (we use if frequently), I would recommend getting the full package. The MSDE runs out of gas pretty quickly past 5 users (by design), and doesn't have many of the tools that make SQL Server easier to use. It costs a few dollars to buy, but your client will quickly save that amount in developer time and administrative effort.

    For what it's worth, I would also recommend using ODBC linked tables rather than an ADP - especially if you are upsizing an existing application.
    Wendell

  5. #5
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Jerusalem, Israel
    Posts
    708
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: MSDE 2000 (Access 2003)

    BTW you can download a 120 day trial of SQL Server for free.

Posting Permissions

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