Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
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