Transfer tables from Access 2002 to SQL

[Scrambles]

Used upsizing wizard to transfer tables from Access 2002 to SQL. Now when I run my report in Access it only returns the first 100 sub reports in the report. There are 120 sub reports that make up this report. Is there a stored procedure that is blocking the other 20 sub reports from running? I get the header of the remaining 20 sub reports but nothing else, also I can print just the sub reports and that works fine.

Any help in this matter would be much appreciated.

Thanks Scrambles

 

[JayKusch]

May need to post this question in the Access Forum(s). This is a SQL Server forum.

Thanks

J. Kusch