I have a huge MS Access database in which requests are added at regular basis as in almost every minute.I have to modify the data type of one of the coloumns in this database,but i cant copy the database to my system and make this change and then put it back.So i want to make the changes through ASP code.I had written the following code to do the same but this is not working.
Expand|Select|Wrap|Line Numbers
- <%@Language=VBScript
- Dim conn,rs,sConnection
- Set conn=Server.CreateObject("ADODB.Connection")
- sConnection = "Provider=Microsoft.Jet.OLEDB.4.0;" & _
- "Data Source=" & Server.MapPath("../fpdb/taxireq.mdb") & ";" & _
- "Persist Security Info=False"
- conn.Open(sConnection)
- conn.execute("ALTER TABLE Request_detail MODIFY Namecon Memo")
- response.write("done")
- conn.close
- %>
Please suggest some changes which would help me in making the required change
Thanks in advance!!