Can't save change of Data Type.

[JeffGrant]

Hi All,

Today I wanted to change a data type from Short Text to Date/Time as it is a link field to another table.

Unfortunately Access is throwing up the error that I can't save the file, not enough memory or disk space.



A Dr Google search suggested change the win MaxLocksPerFile registry entry to something more than 9500. I changed it to 10000, but it made no difference.

Is the number of 10000 too small or is this not the right solution?

At the end of the day, I need to change the data type so I can link the two tables.

All suggestions are gratefully received.

[CJ_London]

Is the number of 10000 too small or is this not the right solution?

suggest use 20000 or 30000, perhaps more

An alternative way which does not involve messing with the registry is to create a new field and have a query to update it with the date text from the original field - something like

UPDATE myTable
SET newdatefield=cDate(oldTextfield)

then you can delete the old field and rename the new field

[JeffGrant]

Thanks Ajax. Worked a treat. cheers.