Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Output table to .mdb Access 2002-2003 file with password.

FernandoSantello
6 - Meteoroid

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:

 

FernandoSantello_0-1630332346473.png

 

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.

0 REPLIES 0
Labels
Top Solution Authors