Results 1 to 11 of 11
  1. #1
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access RunTime (XP)

    Office 97 was easy, Office 97 ODE would make a stand alone, executable file from an Access97 database. This let me distribute database access to users without the need for an Access license for each user.

    I now have Access XP but no Office XP ODE, how can i move on this. I do have a full Enterprise Edition VS .Net installation. Do i need to go through VS training to understand how i could upgrade the Access 97 database to XP and still deploy a run time version??

    Any pointers on what options i have open to me greatly received.


    Fatherjack.

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

    Re: Access RunTime (XP)

    Since Microsoft no longer sells Office XP, it may be hard to come by the ODE, but it is still possible. See the series of posts starting at <post#=375958>post 375958</post#>.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access RunTime (XP)

    There ar eno copies available (to my knowledge) in the UK as there were issues with java something or others and the product got pulled.

    Do you know whether VS .Net will create an executable from an Access DB?

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

    Re: Access RunTime (XP)

    Sorry, don't know anything about that. I hope that someone else will be able to answer this.

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

    Re: Access RunTime (XP)

    The "executable" you're talking about is an installer, not a true applicaton executable. VS.Net includes the access extensions for building an installer, but you can't use them to build an XP or 97 installer.
    Charlotte

  6. #6
    Super Moderator WebGenii's Avatar
    Join Date
    Jan 2001
    Location
    Redcliff, Alberta, Canada
    Posts
    4,066
    Thanks
    2
    Thanked 5 Times in 5 Posts

    Re: Access RunTime (XP)

    He can purchase installer software - A quick google shows lots of hits. But what about the runtime? Is that included with VS.Net?

    curious
    [b]Catharine Richardson (WebGenii)
    WebGenii Home Page
    Moderator: Spreadsheets, Other MS Apps, Presentation Apps, Visual Basic for Apps, Windows Mobile

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

    Re: Access RunTime (XP)

    The runtime license works with VS.Net and is part of the Visual Studio Tools for the Microsoft Office System, which can be purchased and installed separately from VS.Net, since it comes with a standard version of VB.Net. The runtime license is for 2003.
    Charlotte

  8. #8
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Cornwall, England
    Posts
    393
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access RunTime (XP)

    OK, some of this is starting to go over my head <img src=/S/confused.gif border=0 alt=confused width=15 height=20>

    Firstly, Charlotte, sorry for posting in the VB forum too, i wasnt sure where would be more appropriate so tried both. <img src=/S/sorry.gif border=0 alt=sorry width=15 height=15>

    I have a Access97 Front End for an Access97 Back End and users with Office 97 Standard licenses. I have Office97 ODE so created an installer (correct time to use the word??) that compiled a run time version of the FE. This allowed anyone on our network who needed the FE to install it and work with the data using an executable file (.exe.) rather than a normal access (.mdb) file.

    We have, as a company, moved from Office97 to OfficeXP. However i am now stuck with the 97 FE and BE that need to be upgraded or i will have to always have to have a PC on which to develop and create the installer in Office97.

    As part of the upgrade i have moved from VS6 to VS.Net. Our software supplier tells me that VS.Net can be used in the place of OfficeXP ODE.

    Is VS.Net going to be able to allow me to upgrade the FE and BE with AccessXP and then create and installer package that will work in the same way as i had in the 97 format?

    If VS.Net will do the business once the FE and BE are upgraded, what files will i need to include, where do i get a good instruction manual for VS.Net!?

    In short, help, what options do i have ! <img src=/S/toilet.gif border=0 alt=toilet width=24 height=26>

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

    Re: Access RunTime (XP)

    I know it's confusing, particularly with the move from ODE to VS.Net for the packaging tools, but let me see if I can make it clearer.

    <UL><LI>The packaging wizard builds an installer to install the Access runtime files, along with your application mdbs. This is NOT a compiled version of the application.
    <LI>97 front and back ends can be converted to 2002, but may need some tweaking, particularly if you have used things like pipe concatenation, which doesn't work in XP. Conversion does not require the developer tools, it's built into XP.
    <LI>You must have the developer edition/runtime license for each particular version. You can't build a 97 installer with the XP developer, and you can't build one with the VS.Net tools. You CANNOT build an XP installer with VS.Net because the runtime is for Access 2003, not XP. The file *format* is irrelevant, it's the Jet engine that counts.
    <LI>There is a huge learning curve in VS.Net, although Access 2003 isn't all that different from 2002 because it hasn't adopted .Net as its programming language.
    <LI>There is no longer a "developer edition" of Office, and the Access runtime now comes with Visual Studio Tools for the Microsoft Office System, fondly referred to as VSTO, which includes the Microsoft Office Access 2003 Developer Extensions with Microsoft Office Access Runtime license.
    <LI>The VSTO is part of VS.Net and is also available as a separate product, which you can buy without buying Visual Studio.Net, but it won't solve the problem of deploying Access XP runtimes.[/list]I would suggest you look to the internet to try an find a set of XP developer tools because your only alternative is to distribute a 2003 runtime installer.
    Charlotte

  10. #10
    2 Star Lounger
    Join Date
    Mar 2004
    Location
    Portland, Oregon
    Posts
    173
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access RunTime (XP)

    I've been following this thread as I, too, am dealing with Access XP runtime. My client is currently using Access 2000 runtime. I have the Office XP developer edition, but cannot find any reference on the CD to Access Runtime.

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

    Re: Access RunTime (XP)

    Did you install the Developer Tools? It's a separate CD.
    Charlotte

Posting Permissions

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