Run a make-table query through an asp vbscript page

oistros

New member
Local time
Today, 10:56
Joined
Mar 3, 2011
Messages
1
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.
 
Last edited:
You can give Access a command to run a Macro while starting up. This command can be a function in which you drop a table and run a make table query and close the database.
Without ever seeing the Access application you can do what you want from a command line.
I am not sure but for diacritic characters you might want to explore the soundex function. Search the web for it.

HTH:D
 

Users who are viewing this thread

Back
Top Bottom