How do I connect to an access database?

Lori Ivey shared this question 2 years ago
Answered

When I try to set up a connection to an Access database, I see it in the drop down list, but it is grayed out.

Comments (4)

photo
1

Hi Lori,


I smacked my head against the wall on this for a little while, as connecting to Access is particularly tricky due to its ODBC requirements that mandate additional 'moving parts'. (Yellowfin is great at working with JDBC compatible systems, but ODBC systems are decidedly more difficult.) We have an internal guide for connecting to Access, but I can't seem to get it to work properly. I need to clarify with my colleague in the UK who wrote it, just to make sure that I'm not missing anything. I'll chat with him first thing tomorrow, and I should have something back to you mid-day US time.


Stay tuned!


Thanks,

-Conner

photo
1

Hi Lori,


Good news, I've got it all sorted! Naturally the problem was that I misplaced a comma on one of the Yellowfin configuration files. I gave the guide a quick refresh so that it's a bit easier to follow, and made it public. You can find it here: http://community.yellowfin.bi/knowledge-base/article/how-to-use-ucanaccess-to-connect-to-access-databases-using-jdbc-only


If you run in to any snags or have any questions on getting things set up, please let me know!


Thanks,

-Conner

photo
1

This worked perfectly!!!  Thank you so  much.

Lori Ivey

MIS Specialist

Region 7 Education Service Center

1909 North Longview Street

Kilgore, TX 75662

Phone: (903) 988-6956

Fax: (903)-988-6965

/83910393b5f5e5a8154d2e81fd87dd8a

/eafce9c3161654f29168ee37a4f799af/de5dc65ee7a3745172890012b101f343

Check out our Facebook and Twitter pages for more details and info!

"Region 7 Education Service Center is committed to district, charter, and student success by providing quality programs and services that meet or exceed our customers' expectations."

The contents of this email and any attachments may include confidential information. If you have received this email in error, you are not authorized to reveal any of this information, and any use, reproduction or dissemination of the contents of the email is prohibited. If you are not the intended recipient, please immediately notify the sender by reply email or phone and delete this message and any attachments.

From: Yellowfin Support [mailto:support@yellowfin.bi]

Sent: Wednesday, March 15, 2017 10:33 AM

To: Ivey, Lori

Subject: New Comment in "How do I connect to an access database?"

photo
1

Hi Lori,


Excellent, glad to hear it! I'm going to go ahead and mark this question as answered, but you know how to get a hold of us if there is anything else that we can do for you :)


Thanks,

-Conner