Results 1 to 10 of 10
  1. #1
    2 Star Lounger
    Join Date
    May 2006
    Location
    Portland, Oregon, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Save as MDE in Access 2003 (2003)

    Years ago you could save an Access Database as an *.MDE. I don't see that option in Access 2003. If this is not available, how would I share a database with someone who does not actually have Access?
    Charlotte Quiroz

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

    Re: Save as MDE in Access 2003 (2003)

    There are 2 issues at play here.

    First is, to create a .mde database in Access2003, you need to have your .mdb database in A2003 format. Creating a .mdb database in A2003 doesn't automatically put it in A2003 format! The default format is often A2000.

    Secondly, if someone doesn't have Access, it doesn't matter whether you give them a .mde or a .mdb, they can't use! In this case, you would need to bundle it with the Access runtime. This used to be part of the Office Professional Edition, but as of A2003, it is part of Visual Studio Tools.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  3. #3
    2 Star Lounger
    Join Date
    May 2006
    Location
    Portland, Oregon, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Save as MDE in Access 2003 (2003)

    Ah.... it's all coming back to me now. Thanks Mark.
    Now I know what I need to do.
    Char
    Charlotte Quiroz

  4. #4
    2 Star Lounger
    Join Date
    May 2006
    Location
    Portland, Oregon, USA
    Posts
    158
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Save as MDE in Access 2003 (2003)

    OK, I've been to Microsoft and followed all the links for "Visual Studio Tools for Microsoft Office System" and still cannot find how to get the RunTime for version 2003. Can someone help me, please?
    Charlotte Quiroz

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

    Re: Save as MDE in Access 2003 (2003)

    See Obtain and deploy the Access 2003 runtime.

    The runtime version of Access 2003 is actually included with Access itself (on the Office 2003 CD), but you need to acquire the Developer Extensions if you want to distribute it.

  6. #6
    Lounger
    Join Date
    Sep 2008
    Location
    Virginia, USA
    Posts
    27
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Save as MDE in Access 2003 (2003)

    I have Access 2003, not the developer edition. Do I have to buy Visual Studio in order to create a database that can be run without MS Access? If so, can you be specific re edition, etc. of Visual Studio needed? Thanks.

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

    Re: Save as MDE in Access 2003 (2003)

    You can download the Access2007 runtime for free from Microsoft website.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  8. #8
    Lounger
    Join Date
    Sep 2008
    Location
    Virginia, USA
    Posts
    27
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Save as MDE in Access 2003 (2003)

    MS site says Access 2007 is a prerequisite. Will this actually work with Access 2003?

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

    Re: Save as MDE in Access 2003 (2003)

    I don't understand how Access2007 is a prerequisite. You can have a client download and install the Access2007 runtime, and they will be able to run any database you can create with Access2003, including .mde databases.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Save as MDE in Access 2003 (2003)

    According to Obtain and deploy the Access 2003 runtime - Access - Microsoft Office Online,
    <hr>For Access 2003, the Access runtime software is shipped with the Microsoft Office Access 2003 retail product, and the royalty-free Access runtime license is a component of the Access 2003 Developer Extensions. Even though the runtime software is included in the Microsoft Office Access 2003 retail product, the right to distribute the runtime is not included. You must purchase the Access 2003 Developer Extensions to obtain a royalty-free license to package and distribute the runtime.<hr>
    The Access 2003 Developer Extensions are/were available if you have a subscription to MSDN, and as part of the Visual StudioŽ Tools for the Microsoft Office System, but the Microsoft website doesn't make it easy to find out whether it's still available.

Posting Permissions

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