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.
– 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.
