Chaos!

  • Thread starter Thread starter Jim Bunton
  • Start date Start date
J

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
Click to expand...
"Function or interface marked as restricted, or the function uses an
automation type not supported by Visual basic"
 
Jim Bunton said:
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"
Click to expand...

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.
 
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
 
Back
Top