Actually I think you may need to list the other "optional" parameters as
in :

Set db = DAO.OpenDatabase("C:\_pms\dbforum.mdb", false,true,"MS
Access;PWD=mypassword")


Sorry havn't got time to test it. I seem to remember that the optional
parameters become mandatory when using connect.

Well that's what keeps life interesting.


--
tony h
------------------------------------------------------------------------
tony h's Profile: http://www.excelforum.com/member.php...o&userid=21074
View this thread: http://www.excelforum.com/showthread...hreadid=502862