I have a database that was I think designed in Version 2 so it is quite old.
Access 2003 and 2007 can not modify the design of the v2 database without converting it. Visual Basic does not seem to recorgnise the converted database even though it is an MDB file. If I remove the field in V2 and then put it back I seem to loose the data in this column.
I'm at a loss as to how to change the length of text allowed in a field without loosing the data.

Any ideas?

smiler44

It sounds like you do *not* want to convert this db to a later version, correct? I also take it you do not have Access v2.

Hi RuralGuy, your right on all counts. If I could sure visual basic V5 would recognise the later versions of access I'd convert the database but either it cant or I cant make it.

Can I downwload version 2 for free from anywhere?

smiler44

Can I downwload version 2 for free from anywhere?I doubt it. Can you create the table you need in the db with the size field you want and then append the previous table into it?

sorry, append the previous table into it?

agh may have cracked it.
1. rename the field.
2. add new field with original field name
3. delete the renamed field
smiler44

Glad you were able to resolve your issue.