Hello,
i have created a CD production scheduling database in Access 2000. Unfortunatley, my work place is only running Access 97 on the network. After converting the database to 97 i cannot open the database without getting errors on the network. The error message is a long the lines of
'the expression is too complicated. You need to make design changes.'
This is very strange because my database is based on Macros (no visual basic) with only a few simple functions used in conditional expressions.
I can go into specifics if required.

i have created a CD production scheduling database in Access 2000. Unfortunatley, my work place is only running Access 97 on the network. After converting the database to 97 i cannot open the database without getting errors on the network. The error message is a long the lines of
'the expression is too complicated. You need to make design changes.'
This is very strange because my database is based on Macros (no visual basic) with only a few simple functions used in conditional expressions.
I can go into specifics if required.