I am trying to change a field that currently has a data type of number and I want to change it to a date/time data type. When I try to do this, I get a message that says there isn't enough disk space or memory. I am working with a database that has about 100,000 records in it.

The problem is the way Jet actually handles this process. Create a new table with the field formatted as you wish. Then run an append query that copies rows from the old table to the new table.

Do you need to format the numeric field in the original table? If it is not a serial number, you will get very strange results in your date field.