By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,397 Members | 1,467 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,397 IT Pros & Developers. It's quick & easy.

Lost data from table

P: 38
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.
Sep 25 '08 #1
Share this Question
Share on Google+
1 Reply

Expert 2.5K+
P: 2,653
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.

Sep 26 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.