I have an Access DB that I am updating using VB and I want to increase the field Size of a TEXT field from 50 to 200. Can anyone tell me how this is done
I was trying to use EXECUTE to do this but I can't find the correct command.
' Modify this line to include the path to Northwind
' on your computer.
Set dbs = OpenDatabase("Northwind.mdb"
' Add the Salary field to the Employees table
' and make it a Currency data type.
dbs.Execute "ALTER TABLE Employees " _
& "ADD COLUMN Salary CURRENCY;"
dbs.Close
Steve Medvid
"IT Consultant & Web Master"
What I've done in the past is add a new column, via ALTER, then UPDATE to populate the New column, then DROP the old Column... Essentially, 3 statements. I really wanted to insure that I did not lose any data, etc...
Steve Medvid
"IT Consultant & Web Master"
I am lazy and I was hoping I could do this with one command not 3, but I guess I spent more time trying to avoid the work than just getting it done. Thanks for your time I will do it that way.
faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions in the SQL Server forum. Many of the ideas apply to all forums.
Well BOB'S YOUR UNCLE that worked like a hot dam, I used db.execute to do run it. I missed the ALTER COLUMN in my original execute. Thanks a bunch I will remember that.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.