GLSmyth wrote: >Ret = OpenCommand(objCommand, "LAKS") > > I'm curious as to what this does? I take it that it's a sub in your connection file that sets up the connection for the command object, but I'm wondering why you assign it to a variable?
Other random thoughts: Have you tried objCommand.CommandText = "Select [Question] From [Registration] Where [Username] = 'z'" rather than assigning it to a variable. I mean, you may have the only machine on which VBScript is case sensitive! ;-) Have you tried using LIKE instead of "="? Have you tried saving the query in Access, and using it like a stored procedure? Can you find out what version of the MDAC is running on each server (I think that there's a way of doing it with code). Sorry I've got no concrete ideas, but I usually find it's worth trying anything once you get to this stage with a problem. manzo --------------------------------------------------------------------- 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/
