Not able to run the query in MS access

[sruthi das]

I want to get all the names when I give firstletter.Query is like this.Ex:When I give fname as 'a' in jsp
then all names starts with 'a' has to come.Here I am using MS Access
select Employee_FName from UserTable where Employee_FName like '"+fname+"%'";
here fname I am getting from jsp.
I am not able to run this query.

[David O'Meara]

It would be easier if you showed us the code rather than just the query.

Also, I once had a friend who's first name was D'arcy, can you try your code using his name please?