Problems with Access/VBA applciation written for Access 97 using now with Access 2007

[Ron Taylor]

I have inherited an Access 97 database with a VBA front end. I know nothing about VBA front ends, but can work with Access

The system is vital to our organisation. At some point I will look at re-writing the full thing in Access 2007 as the VBA does nothing that Access currently does not. But we have time issues

We have updated SOME of our machines to Windows 7 (64 bit), Access 2007. When i run the VBA Application, to fires up OK, and most of it works fine. However some of the options are returning an error message

Run time error 2-2147217904 (80040e10)
Microsoft[ODBC Microsoft Access Driver] Too few parameters Expected 1

Now,the system works fine on the older machines, and I do not have access to the original code (Though I can work with the underlying database)

I am hoping there is something I can do with the new machines to make this work

Any ideas?

[mshmyob]

If you cannot access any code then the chances are you will not be able to do anything.

It sounds like a query problem, which would be only accessable from code.

I did a search on google and one person found that this was caused by anti virus software interferring with macros in the app. Maybe try disabling any anti virus software if you have any and see if that helps.

cheers,

[Ron Taylor]

Thanks. I checked the virus software, and still occurs when it does not run. I fear it is to do with the coding so probably nothing I can do :-(