Simon,
You could try something like this:

lcConnectionStr = "DRIVER={Microsoft Access Driver (*.mdb)};" +;
                  "Dbq=< PathAndDatabase.mdb >;" +;
                  "Uid=Admin;" +;
                  "Pwd=< YourPassword >;"

lnAccess = SQLSTRINGCONNECT(lcConnectionStr)

?SQLEXEC(lnAccess, "SELECT * FROM < YourTable >", "< SomeAlias >")

HTH
>Does anybody have experience of opening a passworded Access database in VFP to allow my application to import the data? Any feedback much appreciated.