Hello,
i'm working on a site that uses asp vb and access as a database. There is a table that contains Greek words written in caps and lowercase, some characters with accents. Now, this table needs to be searched but if in the fields with Greek characters you search for lowercase letter "a" with accent, the results will have those records that contain letters with accent, meanwhile the "a" without accent is ignored. The same happens regarding capital and lowercase characters. So i decided to build a query that replaces all characters to capitals and then all capitals with accent to those with no accent. Then i would pass the searched word in the same manner to the database to retrieve all possible results. But the Replace function does not work with JET connections (like ms access) so it returns the error Undefined function "Replace". I made an extra make-table query to create a table containing this field, so the search works fine since it doesn't have to work with the "Replace" function. It works ok, but i need run this make-table query either automatically e.g. every day or when the administrator of the site inserts new items to the original table or maybe by simply clicking on a link to "tel" the access to run the make-table query in the background.
Do you have any ideas, if it's possible to do that or any other, more elegant solution?
Thank you for your patience...
*** UPDATE ***
Maybe it's complicated so please let me re-try:
I need to run a make-table table in an access db by clicking a link on a webpage. Is there any general code to do this? I need it to do it without returning any questions like "the table will be deleted" e.t.c.
i'm working on a site that uses asp vb and access as a database. There is a table that contains Greek words written in caps and lowercase, some characters with accents. Now, this table needs to be searched but if in the fields with Greek characters you search for lowercase letter "a" with accent, the results will have those records that contain letters with accent, meanwhile the "a" without accent is ignored. The same happens regarding capital and lowercase characters. So i decided to build a query that replaces all characters to capitals and then all capitals with accent to those with no accent. Then i would pass the searched word in the same manner to the database to retrieve all possible results. But the Replace function does not work with JET connections (like ms access) so it returns the error Undefined function "Replace". I made an extra make-table query to create a table containing this field, so the search works fine since it doesn't have to work with the "Replace" function. It works ok, but i need run this make-table query either automatically e.g. every day or when the administrator of the site inserts new items to the original table or maybe by simply clicking on a link to "tel" the access to run the make-table query in the background.
Do you have any ideas, if it's possible to do that or any other, more elegant solution?
Thank you for your patience...
*** UPDATE ***
Maybe it's complicated so please let me re-try:
I need to run a make-table table in an access db by clicking a link on a webpage. Is there any general code to do this? I need it to do it without returning any questions like "the table will be deleted" e.t.c.
Last edited: