The structures have not changed.

I created a new blank report. I added all tables, but did not add
any fields, ran it, worked fine.

I then added 1 field from each table and ran it, got the Logon Failed.

I went back & removed the rpt_invtot table and ran it, ran fine.

Can you give me some more insight into exactly what 'Login Failed'
actually means?

Thanks





>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.
>>