Database - General - 80040e14 Error

Hi, I'm trying to access a query in a access database where one of the field's is made with a module. This works fine offline but when I try and use it with my asp i get the following error:



The function Salutation is the one in the module in access.

Does anyone have any ideas why this is or what I can do about it?

Thanks Very Much!

please post your code here.

hi
i thinl 'Salutation' is function written in your asp code.in sql query u can use only built in function of access/sql server.u can not use function which written in asp.

its not an asp function, its a module in the access database.

See here: 80040E14 errors

Scroll about half-way down for the explanation.

Basically, ADO/JET can't call a function in an Access database.

Thanks for that, do you have any suggestions as to what I could do to get around it?

What does this Salutation function do? You probably can duplicate it in either ASP or within your actual query.

This is the code for the function:



It is called by this >> Salutation: Salutation([FirstName]) which is a field in the query.

Basicly it looks at the firstname field and if it has mr miss mrs or ms in it then it places it in a field called salutation. I couldnt find anyother way of doing it other then using alot of nested iif's as an expression which i wasn't really sure how to do.

You're placing it in a field on the ASP page or in a field in the database? Explain your logic a little, this most likely can be done through ASP.

Basicly I have a mailing list function that I used on another project that I want to re-use on another but the database design is diffrent. So what i'm doing is making a query which will take the data in my table and change it to look like the table which the mailing list functon query's will understand, naming the query the same as the table the sql will be looking for. I've got it all working apart from the salutation field which is what i'm using the module for. In the table for the first database there is a name field where as the mailing list functions need a salutation first name and last name field. In the query i have used expressions to seperate the first and last names but I couldnt figure out how to write an expression to sort out my salutation field problem so had to use a function. Is there anyway I could sort out the salutation problem with asp, if not then does anyone know how to write an expression to replace the function?

Thanks