Lost data from table

[fd1]

Hi All,
I just encountered a weird problem. I opened a table in an Access 2003 db in design view and added 2 new columns and saved it. After opening it, I realized that one of columns called "Date Created" (default value set to Now()) just dissapeared and got replaced by a column called Gen_Notes with some random numbers in it.
I went back in design view and tried to add the column "Date Created" again but it wouldn't let me saying "Cannot define field more than once".
The column is definitely not in the list, yet I can't recreate it so it must be hidden somewhere.
Can you please help in this matter, I need to restore that column back.

[FishVal]

Hi, there.

First of all, if I've understood it well, [Date Created] field is not visible in table design view, isn't it?
If so, then it could be well a kind of corruption. Try the following.

• Check whether it could be retrieved with query, either explicitely or within all fields (*) qualifier.
• Try to export the table to various destinations: other Access database, Excel spreadsheet, text file, SQL sever database etc.
• Try to fetch the data via Recordset.

Regards,
Fish.