i have an access database that connects via odbc to our as400. the program has worked fine for years. now any paremeter query that prompts you for the parameter gets an ODBC call failed. if i hard code the parameter into the query, it works fine. for example, [begin date] prompts you for a date, this doesnt work, now if i type in 20110201 in the query, it works. i have been pulling my hair out on this one. anyone have any help on this.
i am at my wits end on this one