Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Report Builder 3.0 - MS Access Database as Data Source

Status
Not open for further replies.

kjv1611

New member
Jul 9, 2003
10,758
US
Can anyone here give me a clue as to how to link to a table or query in an Access database from within Report Builder 3.0?

I can get it to point to Access as a source, but how do I specify the database? I was using ODBC as the driver... or do I need to do something different?

Thanks for any references, links, whacks over the head, etc.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
 
Never mind, I was using the wrong driver. I was guessing ODBC, but needed to use OLE DB. So if anyone else runs into this, just use OLE DB, and you'll see MS Access listed.

"But thanks be to God, which giveth us the victory through our Lord Jesus Christ." 1 Corinthians 15:57
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top