Access to SQL Server 2000 1

[SSchimsky]

Hi,

I have a Crystal Report I created against an Access Database.

I am about to convert the Access Database into SQL Server.

How do I then change the Database the Crystal Report is looking at from the Access Database to the SQL Serer Database.

All the tables in the database will remain the same going from Access to SQL Server. Basically I just need to change the Datasource, (Database), from Access to SQL Server....

Anyone know how?

Thanks

Steve

 

[SSchimsky]

BTW, I'm using Crystal Reports Version 9

Steve

 

[vidru]

Go to Database > Set Datasource Location, then use the lower window to browse to your new data source. Click on the replacement table in the lower window, then click the table it's replacing in the upper window, and click the 'Update' button. You'll need to repeat these steps for each table in each report.

Tedious? It is if you've got a lot of reports.

-dave

 

[SSchimsky]

vidru,

That looks like it'll do it! Thanks for the advice! I'll try it when I get to the office in the morning!

Thanks again.

Steve