Visual Data Manager (Alter Columns keeping their data)
I found another common problem, which is to resize a column or change any of its properties (or even add one more) keeping the data with no modification.
Anyway, searching for a decent solution I came across an ADOX approach (which sucked, by the way) and after some work I finished the project without using it at all.
I think ADOX is conflictive since it won't allow to set the default values nor it will allow to modify it is required property... At least all of this with Access 97.
So if you are searching for an easy and fast way to edit your database on Access 97 without losing your data give this project a try!
We miss you, friend... Rest in Peace, we will take care of the rest of it.
[vbcode]
On Error Me.Fault = False
[/vbcode]
- Silence is the human way to share ignorance
Tec-Nico