Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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