Within Excel, I'm trying to use a password protected Access DB. From the data tab, selecting "From Access," after I locate the DB, a "Database Password" box pops up. Entering the database password just refreshes the screen.
After attempting several times, I decide to connect to the same database, located on a different drive with the password removed. Everything works fine.
I'm thinking this is bug within Microsoft. Has anyone come up with a solution? I'm assuming I need to write a connection string, but I'll need some assistance.
Thanks in advance!!
After attempting several times, I decide to connect to the same database, located on a different drive with the password removed. Everything works fine.
I'm thinking this is bug within Microsoft. Has anyone come up with a solution? I'm assuming I need to write a connection string, but I'll need some assistance.
Thanks in advance!!