Results 1 to 14 of 14
  1. #1
    2 Star Lounger
    Join Date
    Jun 2004
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access compiler (2003)

    I am trying to find a compiler for an access database. Does anyone have any information on this matter. I wish to compile a database so access will not be needed to run it. They will only need the exe file. Thanks

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access compiler (2003)

    You can't compile an access application to an exe file. If you want to distribute your application your user will need the Access Runtime.
    See Microsoft Office Assistance: Obtain and deploy the Access 2003 runtime for more information
    Francois

  3. #3
    2 Star Lounger
    Join Date
    Jun 2004
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access compiler (2003)

    I have a database which was created in access 2003 and I am trying to make it accessible to users who have windows 98 and access 97. When I try to convert the database, it no longer will work with access 97, and I cant install access 2003 without updating to a newer version of windows. Will access 2003 runtime fix my problem?

    Thanks

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

    Re: Access compiler (2003)

    If your users have a Windows version that doesn't support Access 2003, it won't support Access 2003 Runtime either.

    Do you have any idea why your database doesn't work when converted to Access 97 format? Have you used features that were introduced in Access 2000 or later? Perhaps, it's as simple as setting the correct references in the Visual Basic Editor - references do not convert well downwards.

  5. #5
    2 Star Lounger
    Join Date
    Jun 2004
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access compiler (2003)

    I get errors when the database loads in access97. It tells me that the forms are not recognized and I need to recreate them?????

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

    Re: Access compiler (2003)

    It's hard to say what could cause this, but the use of features that were introduced after Access 97 seems most likely.

  7. #7
    2 Star Lounger
    Join Date
    Jun 2004
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access compiler (2003)

    All of my tables, queries, and forms convert except for 1 form. It tells me that the form is not recognized and to recreate or restore it. It also says that a library may be missing. Is there any easy way to convert the vb code to a 97 format without having to recreate the database? Thanks

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

    Re: Access compiler (2003)

    Open any module (in the Access 97 database)
    Select Tools | References...
    You may see one or more references starting with MISSING.
    Note which ones they are, then clear the corresponding check boxes.
    Click OK.
    Select Debug | Compile All Modules.
    If you get an error message "User-defined type not defined", you will have to find the Access 97 equivalent of one of the missing references and set it. The standard references in an Access 97 database are:
    - Visual Basic for Applications
    - Microsoft Access 8.0 Object Library
    - Microsoft DAO 3.5* Object Library
    Without knowing the design of the database it's impossible to give more specific advice.

  9. #9
    2 Star Lounger
    Join Date
    Jun 2004
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access compiler (2003)

    What is the Access 97 equivalent to the Microsoft Calendar Control 9.0 from access 2003. This is the library that is says is missing.

    Thanks

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

    Re: Access compiler (2003)

    Probably Microsoft Calendar Control 8.0. The 9.0 is in fact the Access 2000 version.

  11. #11
    2 Star Lounger
    Join Date
    Jun 2004
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access compiler (2003)

    If I use the package wizard in the Access 2003 Developer Extensions program, will I be able to run the database on the computers with windows 98 on them??

    Thanks

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

    Re: Access compiler (2003)

    According to Office Professional Edition 2003 System Requirements, you need Windows 2000 or Windows XP to run Office 2003. Windows 98 doesn't support Office 2003.

  13. #13
    2 Star Lounger
    Join Date
    Jun 2004
    Posts
    119
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Access compiler (2003)

    I can get the database to convert down to a Access 2000 version. I have found a version of Access 2000 runtime. Here is the issue. It says that if a full version of Access is already installed on the computer, there will be problems with using the older version of access. Is there any work around for this. The windows 98 machines have office 97 installed on them. If I install the access 2000 runtime will I have problems or what is you input??? Thanks

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

    Re: Access compiler (2003)

    I don't work with the Access Runtime myself, but there are other Loungers who do. Hopefully they can answer your questions.

Posting Permissions

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