User Profile
pottyponder
Copper Contributor
Joined 4 years ago
User Widgets
Recent Discussions
Unable to Import data from password protected Microsoft Access Database
Hi, I am trying to import data into excel from my Access database that is password protected. It worked fine with Excel 2016 and asked me to enter a password when it connects but now I have upgraded to 2021 it fails and I get the message below, We encountered an error while trying to connect details; "not a valid password." If I go to edit and advanced there is no where to input the password. Many Thanks Paul.17KViews0likes10CommentsRe: Employee's working days by entry
Thank you so much for your help on this, I have upgraded to Excel 2021 now and have the UNIQUE function as it was going to be a pain having to enter the additional helper column. The problem I now have is when I try to import the data from the mdb it fails with the error message "invalid password". The database is password protected and I know the password but there is no where to enter it. Many Thanks Paul.2.9KViews0likes5CommentsEmployee's working days by entry
Hi, I am trying to calculate how many days my employee's have worked each month from my transaction journal. Each day there are lines of entries which all have an operator code in a specific column, I need to look at the end of each month and see how many days each employee has worked. Any help would be greatly appreciated. Kind Regards Paul.Solved3.4KViews0likes15Comments
Recent Blog Articles
No content to show