cancel
Showing results for 
Search instead for 
Did you mean: 

Crystall 11r(2) slow with Microsoft Access

stephenstuntz
Explorer
0 Kudos

We have a Crystal 8 report that runs off a Microsoft Access database in 26 seconds. the same report on the same data runs in 3minutes and 20 seconds in Crystal X1 R(2). clearly i have set something up wrong. what should i look for?

Accepted Solutions (0)

Answers (2)

Answers (2)

stephenstuntz
Explorer
0 Kudos

I had tried new dao and ado connections but did not try odbc and a system dsn. the system dsn worked (report time 28 secs) so i will set up code to change database location to work thru dsn.

thanks for prompt response.

0 Kudos

Hi Stephen,

Open the report up in the Designer and do a Set Location to update the database driver info.

If that doesn't speed it up then try creating a ODBC System DSN to the MDB file and try again.

Don