Using Access as Data Source for Report Server

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Does anyone have any experience using Access with report server (SQL Server
2005)? I can't find much on the Report Server boards.
I can link using Microsoft.Jet.OLEDB 4.0 in my connection string and I can
see the tables, but none of the columns. I think it may be due to the
security on my Access DB. (The instructions I have say to use "Admin" as user
name and leave the password blank.) The .mdw file sits on a different drive
altogether. How much do I have to open up my Access db to be able to link it?
Thanks for your help or any direction you can give me.
 
With Access trying to connect to SQL Server 2005 you should either use the
SQL Native Client ODBC driver or make sure to turn on Named Pipes in your
configuration.
--
Bob Larson
Access World Forums Super Moderator
Utter Access VIP
Tutorials at http://www.btabdevelopment.com
__________________________________
If my post was helpful to you, please rate the post.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SQL Server Reporting Services Reports in Access 4
Problems w/ Report using ADODB.Recordset as Source 1
Access 2007 Reporting Versus Crystal Reports 2
Problem with linked server from SQL Server to Access 2003 database 2
How to change the control source in a report 1
Web service's XML result as a Data Source for a report ? 1
Access Reports not working 0
Filtering subreports on main report 0

Back
Top