I am running into the below error when running 4.1. The same project in 4.0 works like a champ! I want to use 4.1 because of the screen design feature. DB is MS Access.
The application table structure is:
Company
>Contact Problem occurs here. As a result, cannot test Contact History to see if the error occurs.
>>Contact History
Any ideas what the problem might be? Thank you!
Technical information
Error number -2147217904
Error description [Microsoft][ODBC Microsoft Access Driver] Too few parameters. Expected 1.
URL /sales prospect database/Contact_list.asp
SQL query select top 20 [Company ID], [Contact ID], [Salutation], [First Name], [Last Name], [Title], [Address 1], [Address 2], [City], [State], [Zipcode], [Phone], [Email] From [Contact] where ([Contact].[Company ID]=3)
Solution 1. your query contains parameters. Don't use query with parameters in ASPRunnerPro.