accessing reports in access 2000 in VB with SQL2000 as backend 
Author Message
 accessing reports in access 2000 in VB with SQL2000 as backend

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,



Sat, 17 Jul 2004 13:27:48 GMT  
 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,




Sat, 17 Jul 2004 23:40:54 GMT  
 
 [ 2 post ] 

 Relevant Pages 

1. Accessing reports in Access 2000 with SQL 2000 as Backend

2. Front end in Access 2000 / backend in access 97

3. Close Backend Database - Access 2000

4. Problem With VB6 App With Access 97 Backend Running On Windows 2000 Pro

5. Problem With VB6 App With Access 97 Backend Running On Windows 2000 Pro

6. Importing an Access 2000 table into another Access 2000 database with VB Code

7. Distributing VB/Access 2000 Apps to non Access 2000 owners

8. Access 2000 converted to Access 97 report query data type errors

9. Problem accessing Access 2000 tables from Crystal Reports 7 with SP1

10. accessing Access 2000 Report using VB6 ADO

11. VB.NET, Access 2000, Crystal Reports

12. VB 6.0 calling Access 2000 reports

 

 
Powered by phpBB® Forum Software