in Access97, when I have the RunSQL Method in a VBA
module, current access file can't compile functions.

Any tip ?

Thank you in advance.

Check menu Tools-references
should be no missing items
leave only items you realy use (+access, vba, dao)
if you use some activex control - reference should be also there

--
Alex Dybenko (MVP)
http://Alex.Dybenko.com