Hello, good day for everyone. First of all, thank you for your time.
I'm trying to output one of my Alteryx tables to a specific table on my Access .mdb database. I want to bring to attention that it isn't an .accdb database, but an .mbd, using Access 2002-2003.
So far I can output my Alteryx table to my database, but only if my file does not have a password, but I need to have one. How can I set up the password, so Alteryx can access my file? So far my output tool is like this:
The error I keep getting is as follows: "Error: Output Data (80): Error opening connect string: Microsoft JET Database Engine: Invalid Password.\3031 = -124782449"
I know the password, just need directions to where input it. Thank you for the time you spent to read, and I really appreciate any help.