Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Toronto, Ontario, Canada
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Compile to executable (2002)

    This might be a very stupid question, so bare with me. <img src=/S/confused.gif border=0 alt=confused width=15 height=20>
    I was wondering if it's possible to compile an Access database into an executable, along the same lines as you would in VB.

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

    Re: Compile to executable (2002)

    No, that is not possible. Alternatives:

    1. MDE
    If you use Access 2002 database format, you can create an MDE database from your MDB database. In an MDE database, all Visual Basic code is "compiled" and the source code is stripped away, so the size of an MDE is smaller than that of the corresponding MDB. You can't view or edit the design of forms, reports and modules in an MDE database. Creating and editing tables and queries is still possible.
    Notes:
    If you decide to use an MDE, you must keep the original MDB, for if you ever need to modify a form, report or module, you will have to do so in the MDB, then generate a new MDE.
    Access 2002 can't create an MDE from a database in Access 2000 format.

    2. User-level security
    Applying workgroup-based security lets you define different roles in a database - owner, developer, user, ... See moderator <!profile=WendellB>WendellB<!/profile>'s website (link in his profile) for a tutorial on security with lots of useful links.

    3. VB6
    If you want to create a VB6 application, you'll have to do a lot of work, since VB forms are very different from Access forms. There are some conversion tools, but you'd probably have to rebuild the entire application from scratch.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2003
    Location
    Toronto, Ontario, Canada
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Compile to executable (2002)

    Thanks again for the input Hans.
    The reason I was asking was because one of my clients has create a large Access database and he wants his end users to be able to use it without having Access installed on each of their computers. I told him I didnt think it was possible unless he converted it to VB (which would require a great deal of work, and also happend to be your 3rd alternative).

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

    Re: Compile to executable (2002)

    Actually there is a way to do what you ask if you have the Developer's version of Office. With it you can create what is called a "runtime" version of the database, so that the user doesn't have to have Access installed. There are some potential complications, such as what if the user does have Access installed, and possible conflicts with other applications that install dlls. See <post#=303819>post 303819</post#> for some added info on the subject and the pitfalls.
    Wendell

Posting Permissions

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