:confused::confused:A VB6 program sets the recordsource to a query throught the program prior to extracting report. This is working fine if it is used on the machine with Access-2003, while the same does not return data with Access-2007.
What could be the reason?

What file format are you using - ACCDB or MDB? I doubt VB6 would work with ACCDB files since it is a completely different format and, it even had troubles with Access 2000 until the Jet 4.0 update.