Dumb question but do you have a userid or are you trying to connect as admin (in Access)?

The string '"Microsoft Jet Database; pwd=mypass")' would become '"Microsoft Jet Database;UID=; pwd=mypass")'