Try wrapping Question and Registration in brackets as well. If that doesn't work, copy your SQL into a new query in the target database within Access and see what error message it gives you, if any.
Dan -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of GLSmyth Sent: 24 June 2005 14:14 To: [email protected] Subject: Re: [ASP] No value given for one or more required parameters. Dave - Thank you for the response. I have never used brackets, though I normally write for SQL Server databases. I changed the statement to: Select Question From Registration Where [Username] = 'z' Unfortunately, this did not have any affect. Any other guesses as to what might be going on here? Thanks - george --- In [email protected], "David Smart" <[EMAIL PROTECTED]> wrote: > 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 --------------------------------------------------------------------- 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/
