Output table to .mdb Access 2002-2003 file with password.
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Database Connection
- Workflow
