• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 316
  • Last Modified:

I need help accessing SQL Server from an Access application

Hi Experts,
I have to create an Access 2003 form and report that queries from a SQL Server 2005 database.  Can this be done? How can I do this?

Thanks in advance,
mrotor
0
mainrotor
Asked:
mainrotor
  • 2
4 Solutions
 
MINDSUPERBCommented:
Yes, it is possible. You may follow the link below to get some insights on how to do it.

http://office.microsoft.com/en-us/access-help/ways-to-work-with-sql-server-data-in-access-HA001034599.aspx

sincerely,
Ed
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Yes it can. Access is a great report writing tool for SQL Server databases.

Basic Steps:
1) Craete a ODBC connection to the SQL server datasbe in teh Control Panel.
2) Create linked tables to the SQL using the ODBC connection as the source.
3) create your query(s)
4) create your report(s) and form(s).




0
 
MINDSUPERBCommented:
Another approach that you may consider as well is a DNS-less connection as explained on the link below:

http://support.microsoft.com/kb/892490

Sincerely,
Ed
0
 
Jagdish DevakuSr DB ArchitectCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now