UNDO or UN-DELETE COLUMN(S)

[Guest]

A column was DELETED on the table in access (on a disk). How do I restore it???
It CAN be restored. Just need to know what to do already. Thank you.

 

[Rick B]

Data bases don't have COLUMNS, spreadsheets do.

I assume you mean that a field was deleted from a table and all the data
that lives in that field went with it.

If you have a backup of the database, just copy the table from you rbackup
to the working file.

If you have added data since that backup, then you would want to add the
field back to the table in design-view, then use an update query to update
all the existing records with the missing data from the 'backup' table. The
records from after the backup would have to be manually corrected.

Post back if you need help building the update query.

 

[Rick B]

One more thought, your users should not be working in the tables. They
should be using forms, queries, and reports only. Really, just forms and
reports.

Letting them access the tables bypasses all your edits and error checking
that you can build into forms. It also lets them mess up the tables (as you
have seen).

 

[Guest]

Thank you so much for writing/posting. Unfortunately, there is no backup of
the DB, in this case, spreadsheet. A representative at microsoft yesterday
told me she knew the answer but would have to charge me. I still do not know
what to do to retrieve or restore this column that was deleted. I wasn't able
to "undo" and the system didn't ask if you wanted to save your changes. Right
now the file is in a "hide" mode and I can't "unhide" it (yet). This was
originally done in properties. Is there anything I can do? I don't know why
they do not have a back up. Thanks again. T.

 

[Rick B]

Okay, you are confusing me. Is it a spreadsheet or a database? They are not
the same.

This newsgroup is for questions about datbases built in Microsoft ACCESS
(thus the "access" in the newsgroup name).

If this is a spreadsheet and you HID the column, that is not the same as
DELETING a column. If you hid a column in a spreadsheet, just highlight the
entire data base and right-click the column headins and select UNHIDE.

Please make sure you use the proper terminology when posting. deleting and
hiding are not the same. Spreasheet and database are not the same.

 

[Rick B]

lol - you got me doing it.

In paragraph three is should say...

....highlight the entire SPREADSHEET base and...

 

[Guest]

The Column was DELETED. The file is now HIDDEN. Sorry for the confusion. It
is a spreadsheet and unfortunately no one here (at this office) can help. The
representative at microsoft guided me to this site. He knew my question was
in reference to a disc. F:

 

[Rick B]

You are in the wrong newsgroup. This is a Microsoft Access newsgroup.

For help unhiding the file I suggest you post to a Windows newsgroup.

For help undeleting a column, post to an Excel newsgroup (Just FYI, I don't
think you will be able to get it back).

Good Luck.

 

[Guest]

Thanks Rick. I was unable to unhide the darn file very easily. It is the
colum that I'm trying to retrieve. The "undo" option was NOT an option and it
should have been. It also should have asked me if I wanted to save changes
and it didn't. This is ridiculous. The name on the cover of the file says
"Export-Customer Data Base"
I'm not only in the wrong newsgroup, I'm in the wrong office. No one here
even knows how it was created! I'll be back if I can find the original in the
DATABASE. Geeeees!! Thanks again.

 

[Guest]

(P.S.) I did use the right terminology but I am still in the WRONG newsgroup
which is where I was directed from a REP! Have a Great Day

 

[Guest]

I just did the same thing. Did you ever figure out how to retrieve it? I'm
going crazy trying to recover it.