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.
 
Back
Top