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") %> |