Most queries work and the linked server stored procedures work so it's not likely to be on the SQL Server side.
Are you using the same drivers and same configurations with Crystal as you are with the Linked Server?
You could have limited permissions on MAS or if you have a default catalog, database on MAS - can't remember how that one works - which can limit what is returned even if you do have permissions in other areas.
Sue
Yep, they are both using the same DSN. I guess i should call Sage and ask them about the default catalog/database permissions? The last time i talked with them about something unrelated they didn't really get me anywhere as far as being able to see the tables.