Wierdo compile error

[paulmcdonnell]

Hello guys, how's Tuesday...

I have a wierdo problem.

I get a compile error which give me the following error message...
"Function or interface marked as restricted, or the function uses an Automation type not supported in Visual Basic"

I need to use DAO 3.6 and the solutions I've looked at seems to point at DAO 3.5.

I'm trying to understand the problem.

Its basically saying It has a problem with DAO 3.6 (which is listed and is ticked in the registered)

so Im not sure where the problem is.



I found a web page that gives me the following sollution: but I'm using and need to use DAO 3.6.

Problem is I have 12 PC's working fine it's just this one that doesn't and I need to use DAO 3.6


(A solution that I've read)...
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.


Can anyone help me with this it's a tad URGENT.

Cheers
Paul

 

[Mile-O]

What's wrong with using DAO 3.5 for that machine?

it's a tad URGENT

On a forum where people give their time to help others without charge nothing is urgent.

 

[paulmcdonnell]

Dao 3.5?

Hi there...

I'm not too hot with the DAO stuff and references but this is not listed in the references anyway. DAO 3.6 is and that's what i currently use.

Should DAO 3.5 be there is that the whole issue. If so how do i get it on.

Thanks