I have an Access database that is password protected. Within Excel, if I try to use this database as a datasource, selecting from Access, the database password box opens. Entering the password and clicking ok, it just loops through that window. If I remove the password from the database, Excel is able to connect to the database. I need to keep the database secure.
Any suggestions?