AFIAK, there is no limit. One thing to make sure is that the structure of the table doesn't change from the one used to create the report. Crystal keeps track of fields by location in the table, not by name.
>I have removed all table, and re-added them one at a time. I found
>1 of the 9 tables that causes a Logon Failed.
>
>There are no records, but other tables have no records.
>
>I copied a table that was working to another location, renamed it
>'Test' and added it to the report, without using any fields.
>
>I got the Login Failed. I created a brand new table, called
>invtotal.dbf, added, and got login failed.
>
>Is there a limit to the number of tables I can add? I cannot seem
>to add more than 8 tables.
>
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer