VB.NET / ADO question
-
I needed to make a change to the size of a field in an access database so that it would store a path to an image. The field was a text field with a size of 50...I changed it to size of 255 which is the max. So now I cannot figure out what I need to update in my program so that it will pick up the new field size change. I keep getting an error that says I am violating the maxlength limit of the column. Any suggestions? Thanks
Tom Wright tawright915@gmail.com
-
I needed to make a change to the size of a field in an access database so that it would store a path to an image. The field was a text field with a size of 50...I changed it to size of 255 which is the max. So now I cannot figure out what I need to update in my program so that it will pick up the new field size change. I keep getting an error that says I am violating the maxlength limit of the column. Any suggestions? Thanks
Tom Wright tawright915@gmail.com
Did you save the change? Have you confirmed that the access database has the new size? When you change the data structure, the code will automatically pick up the change, as long as you rerun the program and the connection is recreated. Also, I would check the length of the path, which you are trying to save in the database.
VB Prog