Webmaster Forum / ASP / Database Access / June 2008

I'm working on a rooms reservation system based on Access 2003 and then
realize an ASP web page to manage it.
I need a little help in creating the DB since my ideas aren't so clear.
First of all what I need is very simple:

here is a simple form. it works well in my system. I hosted my site. but i
get the error
Microsoft OLE DB Provider for ODBC Drivers error '80004005'
[Microsoft][ODBC Driver Manager] Driver's SQLSetConnectAttr failed

I'm trying to get information about a way to read an XML file within an
ASP page an then save data into an Access table...
Thanks for your support
Paolo

Right now I have a full text search going like this:
SELECT top 25 id, question, answer from [answers] WHERE
CONTAINS(question, '""" & search & """')
where "search" is the variable holding the form value the person typed

The code below results in a reported syntax error near the keyword "Select".
I copied most of this from a perfectly functioning application I worked on a
couple of years ago, that still works, just changing the references. I can't
see what it is referring to. The line number ...

I can't seem to figure out how it's done. I know it has to be something
fairly simple.
I know how to open an excel file, but I'd like to open it, insert values and
save it with a different name and password protect.

Been having a weird issue for the past few months -- might have started when
I moved my asp.net application to framework 3.5 so I could start using Linq
to Sql. When I open my application in VS2008 and click run, it ALWAYS
returns back to me in about 30 seconds saying there was a ...