
accessing reports in access 2000 in VB with SQL2000 as backend
Create a Sql Specfic Query in Ms Access 2000 with the following procedure to
display sql server data.
You must create ODBC Data Source in Control Panel before follow the
procedure.
1.. In the Database window, click Queries under Objects, and then click
New on the Database window toolbar.
2.. In the New Query dialog box, click Design View, and then click OK.
3.. Without adding tables or queries, click Close in the Show Table dialog
box.
4.. On the Query menu, point to SQL Specific, and then click Pass-Through.
5.. On the toolbar, click Properties to display the query property sheet.
6.. In the query property sheet, set the ODBCConnectStr property to
specify information on the database to which you want to connect. You can
type the connection information, or click Build , and then enter information
about the server you're connecting to.
When you are prompted to save the password in the connection string,
select Yes if you want the password and logon stored in the connection
string information.
After creating above query, use the Access Report Wizard and select the
above query as your datasource.
I don't much use newsgroups.
Best Regards,
Luqman
Quote:
> Hv many reports in Access 2000.
> Now, hv moved all data to SQL 2000. But wish to use the reports created in
> Access 2000 ie need to use Access 2000 as front-end and SQL 2000 as
> back-end.
> All reports need to get data via Stored Procedures created in SQL 2000.
> How to do this? any example will be very helpful.
> --
> With Regards,
> Alagappan SL,