Retrieving accidentally deleted field (lots of records)

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm working on sprucing up this database, and everything has been going well
until I accedentally deleted the wrong field. I didn't think it would be a
big deal- I could just use an append query from my backup. But things have
not proven to be so simple...

When I attempted to run the query, I got an error message saying that there
was "Not Enough Temporary Disk Space" to complete. I tried a few
troubleshoots that I found online, but nothing worked- same error every time.


I'm also unable to copy/paste, because I'm dealing with about 130,000 records.

HELP! THERE MUST BE A WAY!
 
have you done a compact and repair?? if you have i know for sure that
you are out of luck. if you have not there may be a chance.


i know that access doesn't delete records permanently until a compact
and repair i would have to assume the same would be true of columns. i
will do some research and see what i did with the info i had about
undeleting records and see if it is of use.

I'm working on sprucing up this database, and everything has been going well
until I accedentally deleted the wrong field. I didn't think it would be a
big deal- I could just use an append query from my backup. But things have
not proven to be so simple...

When I attempted to run the query, I got an error message saying that there
was "Not Enough Temporary Disk Space" to complete. I tried a few
troubleshoots that I found online, but nothing worked- same error every time.


I'm also unable to copy/paste, because I'm dealing with about 130,000 records.

HELP! THERE MUST BE A WAY!
Click to expand...


--
Charles E. Vopicka's (Chuck) : (e-mail address removed)

Database Management, GIS Specialist and Research Assistant

Forest Biometrics Research Institute
University of Montana - College of Forestry and Conservation
Missoula, MT 59812
United States of America

Phone:
(406)243-4526
(406)243-4264
(406)549-0647 (Home)

:-) HAVE A NICE DAY (-:

"UNLESS" (The Lorax, by Dr. Seuss)
 
Nope- I tried to compact/repair already, to no avail. I guess I have a big
task ahead of me...
 
Hi Jolene,

Something like this should do the job, working (of course) with a copy
of the database.

1) In the Database window, copy the existing table from which you
deleted the field (I'll call it T), and paste to create a new one
containing structure only.

2) Open the new table (I'll call it N) in design view and add in the
field you deleted.

3) Compact the database.

4) Create a query that left-joins T and its backup on the primary key,
and returns all fields from T plus the missing field from the backup,
for all records in T. WHen it's right, change it into an append query
that appends to N and run it.

5) Rename the tables to give T a new name and N the name T had. Delete
all relationships involving T and re-create them using N. Create any
necessary indexes on N.

6) Check any records in N that have a null value in the restored field:
these may have been added between the time the backup was made and the
field was deleted.

7) When everything is working, delete T and compact the database.
 
the compact and repair would permanently expunge the deleted materials.
that is why i had mentioned that if you had done that you would be out
of luck. i looked for the code i had to undelete stuff and it was only
for entire tables and it only worked in specific cases.


as for the error message you got i am unsure but i know that out of the
box Access defines a maximum number of record locks to 9500 (i think) i
sometimes have problems with that. may or may not be your problem as
well. the value can be changed but i doubt that is your problem.

Nope- I tried to compact/repair already, to no avail. I guess I have a big
task ahead of me...
Click to expand...


--
Charles E. Vopicka's (Chuck) : (e-mail address removed)

Database Management, GIS Specialist and Research Assistant

Forest Biometrics Research Institute
University of Montana - College of Forestry and Conservation
Missoula, MT 59812
United States of America

Phone:
(406)243-4526
(406)243-4264
(406)549-0647 (Home)

:-) HAVE A NICE DAY (-:

"UNLESS" (The Lorax, by Dr. Seuss)
 
Back
Top