Search results

Hi all, ive got a search engine going thro my website in ASP/Access, and it works a real treat in ISS. Ive uploaded the ASP page and the database then gives me this - "Microsoft JET Database Engine error '80040e37' The Microsoft Jet database engine cannot find the input table or query...

Any ideas guys? Perhaps i over did it with my info in the last - i have 22 tables, each with 5 coumns of data. I need to create a query where i can merge all the date and 2 coulmns into one big column - any ideas on how to merge 2 columns? thx.

Any ideas guys? Perhaps i ever did it with my info in the last - i have 22 tables, each with 5 coumns of data. I need to create a query where i can merge all the date and 2 coulmns into one big column - any ideas on how to merge 2 columns? thx.

I have this going already - SELECT Item_Name, ID, Item_No From accessories UNION select Item_Name, ID, Item_No From bars; which does indeed use UNION to merge tables. BUT i must be able to merge columns from tables to one big column, so perhaps i was not toally clear in the first questions...

Hi all. Is there some way to merge 2 tables into one in a query? Is it possible? Thank u.

Hi all :) I have 22 tables in my Access database, which is my catalogue data. I have it set up on dreamweaver. Now tho, i need a search engine going thro it, i have a script in access/dreamweaver that works. Only thing is, that the script only works thro one table. Now, is there some way to...