473,386 Members | 1,819 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

I need to Access 2003 to run reports on SQL 2005

I am tring to get Access 2003 to run reports on SQL 2005 and can not figure out how. I just made the move from VB development to database management and need help. Thanks
Oct 15 '07 #1
2 1048
nico5038
3,080 Expert 2GB
Just use ODBC to create linked tables and you can use these tables in Access like "regular" tables to create reports.

Nic;o)
Oct 15 '07 #2
Jim Doherty
897 Expert 512MB
I am tring to get Access 2003 to run reports on SQL 2005 and can not figure out how. I just made the move from VB development to database management and need help. Thanks
In considering your options look at the ADP Project format for Access which connects inherently with the access interface using UDL (universal data link) you have the stored procedures and views exposed directly within Access interface for you to manipulate client side, whilst all the processing is done server side.

You can build your reports then directly tied to server side views or stored procedures and pass any parameters directly to the server via the inputparamters properties of the report alternatively you could visually display your results first by the usual form display techniques and pass parameters to the report its a matter of design really.

Regards

Jim
Oct 17 '07 #3

Sign in to post your reply or Sign up for a free account.

Similar topics

1
by: JMCN | last post by:
hello does anyone know why is there a character limitation (255) in excel when i export from the reports object in excel access? if i created a macro using the transferspreadsheet action from...
0
by: Mark V | last post by:
I am trying out VS web 2005 beta addition with an Access Database. If I try to insert new data into any table in the database I continually get the following error; Seen similar on many...
2
by: nlc | last post by:
Hello, I've created a report but I need to have the headers vertical. I know in properties I can change the text to be vertical but I need the layout to be in the opposite direction. Does anyone...
1
by: Matthew Wells | last post by:
Whenever I work with reports in 2003, there is this excruciating 30 delay when I open the report or whn I change something in the property sheet. I have a report with three controls and no record...
4
by: amanda27 | last post by:
I am creating a database where an excel spreadsheet will be imported and then different information will be taken from that spreadsheet to give different reports and graphs. I am having a problems...
4
by: Scallywag | last post by:
Hi :) I have a user who is unable to open current reports, and when she tries to create a new report it gives the error: The wizard is unable to create your report. The user has Windows XP SP2,...
1
by: cslee168 | last post by:
Just finished Access 2003 with MDE file but then find out that I need Access 2003 Developer Extensions to deploy the runtime. I went to MSDN site and it talks a lot about it but I cannot find the...
1
by: sangoma | last post by:
Hi All, I created some MS Access 2003 reports with a nice colour scheme. When I click on the PDF button, the report is converted but none of the colours show. Any ideas why this is happening?...
2
by: PW | last post by:
Hi, We have a new client who says he can not preview or print an Access 2003 report on his Vista machine. They print on his XP machine. He says the screen just flashes. Other users using...
1
by: klinke1006 | last post by:
Hi, I have written several Access 2003 reports. These reports run properly for some of the users of the Access Application. For others a report that should display on one page displays on many...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: Sonnysonu | last post by:
This is the data of csv file 1 2 3 1 2 3 1 2 3 1 2 3 2 3 2 3 3 the lengths should be different i have to store the data by column-wise with in the specific length. suppose the i have to...
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.