Member Avatar for haylau
haylau 0 Newbie Poster

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?

  • 1 Contributor
  • 0 Replies
  • 71 Views
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.