Is it possible that the server has a different version of the JET engine? I don't like the way you're not putting your field and table names inside [] brackets - especially a field name of "username". It's possible that this is what's giving you grief. Try it with the brackets around the names.
Dave S ----- Original Message ----- From: GLSmyth To: [email protected] Sent: Friday, June 24, 2005 12:14 PM Subject: [ASP] No value given for one or more required parameters. I am having a strange problem. I am developing under PWS on Windows 2000 and when done with a program I move it to the server. This works quite well. I am using ASP, not ASP.NET and an Access database. I added a couple of fields to the database locally then uploaded the database to the server (the system is not yet live), so they should both be the same. A program that works just fine locally is giving me the following error: Microsoft JET Database Engine error '80040e10' No value given for one or more required parameters. /Administration/User/LostPassword.asp, line 53 Line 53 is trying to execute an SQL statement, which is simply: Select Question From Registration Where Username = 'z' I am not understanding why this might be happening. Just to make sure that the two databases actually were the same, I renamed the database locally and downloaded it from the server. The program works just fine locally. Any help that can be offered with this strange problem would be greatly appreciated. Cheers - george --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- ------------------------------------------------------------------------------ Yahoo! Groups Links a.. To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ b.. To unsubscribe from this group, send an email to: [EMAIL PROTECTED] c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service. [Non-text portions of this message have been removed] --------------------------------------------------------------------- Home : http://groups.yahoo.com/group/active-server-pages --------------------------------------------------------------------- Post : [email protected] Subscribe : [EMAIL PROTECTED] Unsubscribe: [EMAIL PROTECTED] --------------------------------------------------------------------- Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/active-server-pages/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
