Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • 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

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

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