By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,476 Members | 1,376 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,476 IT Pros & Developers. It's quick & easy.

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

P: 2
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?
Dec 23 '10 #1
Share this Question
Share on Google+
2 Replies

Expert 100+
P: 903
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.

Dec 23 '10 #2

P: 2
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 :-(
Dec 23 '10 #3

Post your reply

Sign in to post your reply or Sign up for a free account.