Running a make table from Crystal?

[Delboy14]

Crystal Reports 8.5, Access XP

Hi,
I have a problem that my database is growing so large that subsequently running reports on it is taking far too long. I was wondering if there was a way to run a make table query (In Access) from Crystal, passing in an ID as a parameter, this would allow me to run many subsequent queries from this smaller record set, and include data from this quickly into the report.

 

[synapsevampire]

You can write to a NEW table directly from Crystal, there are some gotchas, as it won't append nor overwrite if you use ODBC, so you'll have to clear the old one first.

You could also write to another file format directly (which will allow for overwriting) and have that linked in your Access database.

I'd think that letting Access create the new table would be optimal.

BTW, if the database is getting sluggish, consider moving on to SQL Server or a real database, Access is NOT a Mission Critical database, and once it starts getting sloooooow, my experience is that it starts to crash with greater frequency.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com