Compile Error on CurrentDB - Urgent

[dmh4ab]

I have one user of a database that gets an error "Compile Error. Function or interface marked as restricted, or the function uses an Automation type not supported in Visual Basic." The Access version is the same (97) and the references are the same. I even tried a re-install of Access but to no avail.
The following link produces the error:

Set qdf = CurrentDb.QueryDefs("RequestNo_ToolingTable")

The event is in a form load procedure called by clicking a button.

I'm about to go home for the day so I can tackle this afresh tomorrow. Any help would be greatly appreciated.

dmh4ab

 

[lameid]

Assuming you have a distributed Front End, copy over the user's front end off the source/ clean copy.

Otherwise open the database via the command line using the decompile switch...

msaccess.exe "c:\path\database.mdb" /decompile

 

[dmh4ab]

There is no front-end. It's just a database placed on a network so multiple users can access it.

I tried to decompile switch. When I did the recommended compile of save of all modules, it stopped on the same line and gave the same error.

dmh4ab

 

[dmh4ab]

For once it seems Microsoft has provided a working solution. (But I'm not holding my breath!).

Knowledge Base Article 303829 has solved the problem. It appears the problem was referencing DAO 3.6 and not DAO 3.51

http://support.microsoft.com/default.aspx?scid=kb;en-us;303829&Product=acc97

My apologies for not checking here first!

dmh4ab