converting accdb to mdb

[Andy74]

Hello Everybody,

I have some issues in converting an accdb front end go mdb front end (because some users have old access version). When converted it doesn't compile anymore and stops in some events like rst.lastmodifed where rst is a dim recordset variable.

Any clues?

thanks

andy74

 

[llkhoutx]

Make sure that you has the DAO reference checked.

 

[Andy74]

Thanks, that is there. Microsoft DAO 3.6 objects library! The error I get is 461

 

[llkhoutx]

The error generally indicates what's wrong.

http://office.microsoft.com/en-us/access-help/HV080755902.aspx

 

[Andy74]

thanks, but the same code compiles with an older version. I normally work on a accdb file and when I distribute (only 2 users over 50 cannot open the accdb) I have to "downgrade" it to mdb. I think there may be some corruption issues. I have tried to decompile/compile with no results. Apparantly there is no reason for the stop, references are ok.