Chaos!

[Jim Bunton]

Access 97
Windows 2000
(HAVE RECENTLY HAD TO REINSTALL WINDOWS)
Now access 97 databases not running correctly!

EG on compile
code:-
Set cdb = CurrentDb

error

"Function or interface marked as restricted, or the function uses an
automation type not supported by Visual basic"

 

[Dirk Goldgar]

Access 97
Windows 2000
(HAVE RECENTLY HAD TO REINSTALL WINDOWS)
Now access 97 databases not running correctly!

EG on compile
code:-
Set cdb = CurrentDb
"Function or interface marked as restricted, or the function uses an
automation type not supported by Visual basic"

A quick search of the Microsoft KnowledgeBase for that error message and
product Access 97 turned this article up at the top of the list:

http://support.microsoft.com/default.aspx?scid=kb;en-us;303829
ACC97: Error Message: "Compile Error: Function or Interface Marked
as Restricted, or the Function Uses an Automation Type Not Supported in
Visual Basic"

That sure sounds like your problem to me. The article explains what to
do to fix it.

 

[Jim Bunton]

Thanks for the reply to my posting:
The article referred to is indeed the answer and it is a straightforward
article to follow and implement
[will also take the implied advice and have a search in the MS Knowledge
Base in future 'similar' circumstances!]

Jim