strange problem, need suggestion

[anouly]

Hi all,

I am having a strange problem in my Access code. On my Windows 2000 and Access97. Every my application executes this statement "set db= currentDb()" it would cause my application to close down automatically without any error message prompted. On the other hand, the same code works fine with Access97 on windows 98 machine.

Can anyone point out the reason as well as giving me suggestion please?

Thank you a lot.

--Anouly.

 

[willir]

References

You are probably missing the reference to DAO.

Use ALT-F11 to open up VBS coding window
From menu, "Tools" -> "References"

Add "Microsoft DAO 3.6 Object Libarary"

When you install Access 2000 and XP, Mirco$oft installs the ADO reference and not the DOS reference - a hint that they want developers to move on to the more versatile ADO. But there is a lot of code, and some may say convenience with DAO.

Richard

 

[anouly]

Thank you Richard, I'll have a try.


--Anouly