Hi
Firsly the Lotus Notes SQL - When settimng up the ODBC connection: Select your name, descrtiption, server and database...then click on options and select the user name (in my case its a Notes ID file located on C:/Lotus/Notes/Data, then also enter the appropriate password
Secondly, I've had similar problems accessing Excel from CE10 (not CR10) which might be similar to the Access ODBC accessing issue. The solution was to select the UNC path in the ODBC connection, as opposed to the mapped path.
Cheers,
Etienne
EO
Hertfordshire, England