Results 1 to 6 of 6
  1. #1
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Error messages (Access 97)

    I am trying to follow a tutor in Access 97, but I keep getting error messages such as "Compile Error: Function or interface marked as restricted, or "The function uses an Automation type not supported in Visual Basic" or "ActiveX component can't create object."

    The first one came from a "canned" program with the tutorial and the second came when I tried to run the wizard to create a new data base.

    Simultaneously with these problems, an old application which has been running without problems is now failing with a "Compile error syntax error."

    Should I try to reinstall the Access package?

    The tutorial ran several months ago, and the application has run for probably two years.

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

    Re: Error messages (Access 97)

    Syntax errors on compilation usually indicate - apart from syntax errors, of course <img src=/S/grin.gif border=0 alt=grin width=15 height=15> - that a reference has gone astray. Open any module and select Tools/References.... If a reference says MISSING: ..., uncheck it. Try to compile all modules again.

    The problems with the tutorial could also be caused by a missing reference, but there are some other possibilities. Have a look at ACC: Error Message: ActiveX Component Can't Create Object.

  3. #3
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error messages (Access 97)

    I went through the procedures which you recommended. I did have a file marked "Missing". I recheckde the tick box in Tools/Reference, and the "Missing" message is gone. Then I reinstalled Access successfully, as suggested in the knowledge base. The wizard files, *.mde were reinstalled.

    The errors still occur. Basically, whenever I try to use the wizard to create a new db, I get the message "ActiveX component can't create object."

    Any other ideas? Thanks for the patience.

  4. #4
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error messages (Access 97)

    How do you recompile the modules? What should I have checked in the Tools/Reference window you mention?

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

    Re: Error messages (Access 97)

    The debug menu has 3 compile options. You reopen the decompiled database from a session of Access not started with the /decompile switch, go to the VBE, and compile and save all modules. The References should be to the libraries that are required by your code.
    Charlotte

  6. #6
    4 Star Lounger
    Join Date
    Apr 2001
    Location
    Guatemala City
    Posts
    515
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Error messages (Access 97)

    Many thanks. The information from the ACC Error Message page let me fix it.

Posting Permissions

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