Page 1 of 2 12 LastLast
Results 1 to 15 of 16
  1. #1
    DougieMend
    Guest

    Version of Access that compiles (???)

    I was told recently that there is a version of access out that will compile into an exe file. I was wondering if anyone on here had any knowledge of this. Any help would be appreciated.

  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: Version of Access that compiles (???)

    There is no version of Access that will compile into a .exe file. The best you can do is distribute the Access runtime with a database provided you have the Office Developer Edition.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Version of Access that compiles (???)

    I heard something at the XP launch about it becoming available when they finally go to Office.Net, but I wouldn't hold my breath.
    Charlotte

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

    Re: Version of Access that compiles (???)

    Jam tomorrow or lets see what we can leave out of this version to assist the user in deciding to purchase an upgrade to the next version.

  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: Version of Access that compiles (???)

    >>I heard something at the XP launch about it becoming available when they finally go to Office.Net, but I wouldn't hold my breath.<<

    Really! They didn't mention it at the XP launch event I attended. But then they hardly even mentioned Access at all, and no-one there from Microsoft knew anything about Access.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

  6. #6
    DougieMend
    Guest

    Re: Version of Access that compiles (???)

    Thanks for the help. I am developing a project that this would be a good solution to. If you hear any more, would you do me the favor of letting me know? I will be making the final decision on the tool to use in early October, so I will be researching this product until then. Thank you

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

    Re: Version of Access that compiles (???)

    Nothing will be available for several years at the earliest. Out of curiosity, why do you need an executable? Even a VB executable requires either VB or the VB runtime. That doesn't seem to me like any great advantage over Access and its runtime. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15>
    Charlotte

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

    Re: Version of Access that compiles (???)

    I could be thinking of something else, but I sure thought that was what someone said in response to a question. But I was faint from hunger since all they offered was junk food, none of which is allowed in my diet. <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Charlotte

  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: Version of Access that compiles (???)

    We did a little better at our Launch. We had choice of turkey or ham sandwiches, and a Big cookie, and an apple.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Version of Access that compiles (???)

    All right, so you ate better--but nobody mentioned Access! <img src=/S/tongue.gif border=0 alt=tongue width=15 height=15> <img src=/S/laugh.gif border=0 alt=laugh width=15 height=15>
    Charlotte

  11. #11
    DougieMend
    Guest

    Re: Version of Access that compiles (???)

    What the concern about the project I'll be developing is the speed issue.
    Access seems to be slower than than VB compiled and linked with an ADO. If
    what you're telling me is that Access can be compiled, and the runtime
    distributed, and the performance is equivalent, you'll have a very greatful
    admirer. I'm trying to find a way to develope this project in Access, so that
    I don't have to write all of the code from scratch. The project manager is
    concerned that it will be faster if I write it in VB. What is the actual
    capabilities of Access Developer? Thank you for any help you are able to
    provide.

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

    Re: Version of Access that compiles (???)

    There's a bit more overhead using the Access runtime, apparently because VBA has to run using the Access engine. However, the ADO connection should be the same speed regardless of whether it's running from Access or VB. A lot of VB fanatics insist that it's faster, forgetting that if you're using a Jet database, then Jet and not VBA is the limiting factor. I have not seen a huge difference in speed between them, and I miss a lot of handy features in VB that Access has.

    The developer edition merely gives you the packaging and deployment wizard (same as the one that comes with VB/Visual Studio), plus the license to distribute the Access runtime and the ActiveX controls that come with the developer edition. The VB runtime is probably already on most machines and that gives the illusion that VB executables are lean and mean. In fact, if you have to package the VB runtime, you are not looking at something that fits on a floppy.

    If you're going to use a lot of ActiveX controls, use VB. They seem to behave better in VB than in Access in my experience. On the other hand, Access reports are far richer than anything you can build in VB, and if you're going to use Access reports, it doesn't make much sense to do it from VB because you won't gain any speed in so doing. Access forms are also richer in features than VB forms. No, you can't attach a menu to them, but VB forms don't allow form headers and footers and subforms and can only be bound using datacontrols.

    If you're going to use ADO and you need bound forms, then VB might be the better way to go, binding the data with the ADO Datacontrol. On the other hand, if you're comfortable with unbound forms, you can use ADO recordsets with Access quite neatly.

    But if you're more comfortable with VB or with Access, then that should be the one you use if you're the one who has to write the application. It is more expensive to learn how to do something in an unfamiliar environment than it is to do something you already know in a familiar environment.
    Charlotte

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

    Re: Version of Access that compiles (???)

    How about the usual goodies Microsoft gives away as door prizes? OUrs were lousy this year. The "top" prize was a copy of WinME, which was booed! No copies of Office. Last one I went to, they gave away several copies of Office, and I won an Enterprise edition of C++.
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

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

    Re: Version of Access that compiles (???)

    They gave away an OfficeXP-ready natural keyboard instead of the Office they were supposed to give away. Whoopee! <img src=/S/sick.gif border=0 alt=sick width=15 height=15>

    We did get a full copy of MapPoint 2002, which I haven't even opened, and a trial version of Visio 2002 Standard. <img src=/S/shrug.gif border=0 alt=shrug width=39 height=15> And big deal, we got a coupon for $50 off the special edition of Office Professional. Since I use Developer, that was useless too.
    Charlotte

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

    Re: Version of Access that compiles (???)

    Yeah, we got the same free stuff, and it was as helpful to me as it was to you (I also use Developer). However, I still use the free pen (sometimes).
    Mark Liquorman
    See my website for Tips & Downloads and for my Liquorman Utilities.

Page 1 of 2 12 LastLast

Posting Permissions

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