Using a Database created in a later version.

[SikhSioux]

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.

 

[mikebaldam]

Have you tried saving your macros as VB then Saving as an earlier version...?


Mike
________
RC161

 

[SikhSioux]

Reply

Have you tried saving your macros as VB then Saving as an earlier version...?


Mike

I haven't learnt any VB yet. Any clues on how to do that?

The most complicated funtions i have in my database are the date() and now() functions which i have used in the criteria row of a simple two table query.

 

[mikebaldam]

Just open your Macro and the choose File , Save As and then choose Module and Access will do the rest...

(My VB's about the same..)

Mike

PS.. I'm trying out your idea for concatinating the fields now..looks good so far..
________
drug testing