Hi Sami, does "remote" mean your local network or a hosting service on the Internet?

In a local environment, this is how I use OpenDatabase on a password-protected Access file:

    Dim ws As Workspace, db As Database, r As Recordset
    Set ws = CreateWorkspace("", "admin", "")
    Set db = ws.OpenDatabase("X:\My Documents\MyDB.accdb", False, False, ";pwd=plumbingplumbing")
    Set r = db.OpenRecordset("MyTable1")
    r.MoveFirst
    Etc.

As long as you have full access to the path in drive "X:" above, it should work.

I don't have access to any of Richard's courses so I can't give you help that pertains to his lessons.  He may have some other ways to do it.  Another way to open a database is via ADO.  The method I used above is DAO.

If your file is on the Internet via hosting service, cloud drive, and the likes, it may be impossible because OpenDatabase requires a local path, or something that looks like it: X:\xxxx\xxxx