Problem after upgrading W98 to W2K

[baronvont]

Can anyone help out here? I get the following error message:

+++++++
Compile error:

Function or interface marked as restricted, or the function uses an automation type not supported in Visual Basic.

+++++++

The thing is that the compliler highlights this line...

Set db = CurrentDb

a basic command!!!

Has anyone else come across this? I did have a problem with missing references but have re-attached them.

Cheers
Georg

 

[baronvont]

Sorry - a bit more info (thought I had typed this in!!)- this is after I had upgraded from W98 to W2K. Still using Access 97 tho...

 

[baronvont]

OK got it!!

http://icc.ucdavis.edu/iccdocs/joes.htm

ERROR: ACC97 Win98 DAO 3.6 "Compile error: Function or interface marked as restricted, or the function uses an Automation type not supported in Visual Basic " error on the 'set db = currentdb() command'
FIX: Remove DAO 3.6 from Access 97, return to DAO 3.51. Click Start | Run, paste this in:
Regsvr32.exe "C:\Program Files\Common Files\Microsoft Shared\DAO\DAO350.DLL" and hit return. You should see a message that the library was successfully registered. The error will vanish.