ASP Online Implementation Modify the field type of an Access database

Source: Internet
Author: User
Tags modify reference access database access
Data | database | online |access| field type

Arisisi (alixixi.com) in doing a client project, the program has been delivered and uploaded to the customer's netcom space, but our development team is using a telecommunications line, the dozens of m size of the data transfer is very slow.

In an adjustment, because the field design is too short, you need to modify the database field type, but the database is very large, if downloaded, it is estimated that half a day to download, the modification is completed and then uploaded ...

So, decided to modify the field of AC Library online, looked up some data, wrote the following code, easy to realize the original text type of the field into a memo-type, all problems to solve!

The following code can be provided to you for reference, the table named vote eselect1~8 Several fields into the Notes long text file field, the MSSQL library can be modified by its own reference.

The following is a reference fragment:
<!--#include file= "conn.asp"-->
<%
Conn.execute ("ALTER TABLE vote ALTER COLUMN Eselect1 Longtext")
Conn.execute ("ALTER TABLE vote ALTER COLUMN ESELECT2 Longtext")
Conn.execute ("ALTER TABLE vote ALTER COLUMN ESELECT3 Longtext")
Conn.execute ("ALTER TABLE vote ALTER COLUMN ESELECT4 Longtext")
Conn.execute ("ALTER TABLE vote ALTER COLUMN ESELECT5 Longtext")
Conn.execute ("ALTER TABLE vote ALTER COLUMN ESELECT6 Longtext")
Conn.execute ("ALTER TABLE vote ALTER COLUMN ESELECT7 Longtext")
Conn.execute ("ALTER TABLE vote ALTER COLUMN ESELECT8 Longtext")
%>



Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.