Eg., The client db is password protected. They did not want to share their password. Still I need to connect to the client db through vba coding and retrieve certain information.
Is it possible to connect to an access db (accdb) without passing the password information in the db connection string? I am trying to connect to the client .accdb file from an Access Project file (adp)