Hi, I have a database driven website and post this once without getting anywhere. I hope this try could help me to fix the problem. The site is .asp. I read everything I could find about access 2003 in the site. I can connect to my database, read from it and search in it. However I *can not update the data in a table *can not insert new data in a table This is the codes that had worked in another host in the past. my codes filePath = Server.MapPath("db\*.mdb") '-------open connection to the database Set mYconnection=Server.CreateObject("ADODB.Connection ") mYconnection.Open("Provider=Microsoft.Jet.OLEDB.4. 0;DataSource=" +filePath) '-------------- getting data from the form DIM selectedId , pTid, todayId, Note selectedId = Session("pTiDforDetail") pTid = Request("id4report") todayId = Date() Note = CStr( Request("noteTxt") ) '-------------- starting to insert DIM Qinsert Qinsert = "INSERT INTO followTb" Qinsert = Qinsert & "(ID, ptID, dateOfvisit, noteforthisVisit)" Qinsert = Qinsert & "VALUES ('"&selectedId&"', '"&pTid&"', '"&todayId&"', '"&Note&"') " '--------------- in the table, ID and ptID are numbers and dateOfvisit is date Call mYconnection.Execute(Qinsert)
