If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Retriving deleted data from table
I selected all record in the table an press Delete. Haw can I retreve them.
Please help |
#2
|
|||
|
|||
Retriving deleted data from table
Check
http://www.everythingaccess.com/tuto...ries-in-Access -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "Andy" wrote in message ... I selected all record in the table an press Delete. Haw can I retreve them. Please help |
#3
|
|||
|
|||
Retriving deleted data from table
Since you deleted the records (note: not the table) I think your only way to
recover is to use a backup to get the records back (up until the time you made the backup) or to use a data-recovery service to get the records back (expensive but it could be worth it depending on the data). Do NOT compact the database. DO make a copy of it immediately. And put the copy in a safe place, so that if anything goes wrong - you will not make a bad situation worse. DO NOT use the copy - but if you need to start over make a copy of the copy and work on the copy. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Douglas J. Steele wrote: Check http://www.everythingaccess.com/tuto...ries-in-Access |
#4
|
|||
|
|||
Retriving deleted data from table
I agree. I did not delete the table, just all records in it. Ther is no
backup (She did not done, but she must). I still have a problem. I make a copy of database more of them. Then compact one of the copy and it a big difference. So, there must be data in original mdb. Is there any way to get data from the table? Thanks for help in advance Andy "John Spencer (MVP)" wrote: Since you deleted the records (note: not the table) I think your only way to recover is to use a backup to get the records back (up until the time you made the backup) or to use a data-recovery service to get the records back (expensive but it could be worth it depending on the data). Do NOT compact the database. DO make a copy of it immediately. And put the copy in a safe place, so that if anything goes wrong - you will not make a bad situation worse. DO NOT use the copy - but if you need to start over make a copy of the copy and work on the copy. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Douglas J. Steele wrote: Check http://www.everythingaccess.com/tuto...ries-in-Access |
#5
|
|||
|
|||
Retriving deleted data from table
THe only way I know to recover the deleted records is to use a data recovery
service that specializes in Access databases. You will need to contact one of them and send them an uncompacted version of the database. I don't have any recommendations on a service that can do this. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Andy wrote: I agree. I did not delete the table, just all records in it. Ther is no backup (She did not done, but she must). I still have a problem. I make a copy of database more of them. Then compact one of the copy and it a big difference. So, there must be data in original mdb. Is there any way to get data from the table? Thanks for help in advance Andy "John Spencer (MVP)" wrote: Since you deleted the records (note: not the table) I think your only way to recover is to use a backup to get the records back (up until the time you made the backup) or to use a data-recovery service to get the records back (expensive but it could be worth it depending on the data). Do NOT compact the database. DO make a copy of it immediately. And put the copy in a safe place, so that if anything goes wrong - you will not make a bad situation worse. DO NOT use the copy - but if you need to start over make a copy of the copy and work on the copy. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Douglas J. Steele wrote: Check http://www.everythingaccess.com/tuto...ries-in-Access |
#6
|
|||
|
|||
Retriving deleted data from table
Please see my post from back in 2007: http://groups.google.co.uk/group/mic...eted+ records Unfortunately you're probably out of luck on this one. If you contact me via our website (see below), I can check the file for you to see if there is anything that can be done in this case. Wayne Phillips http://www.everythingaccess.com On 14 Jan, 15:30, Andy wrote: I agree. I did not delete the table, just all records in it. Ther is no backup (She did not done, but she must). I still have a problem. I make a copy of database more of them. Then compact one of the copy and it a big difference. So, there must be data in original mdb. Is there any way to get data from the table? Thanks for help in advance Andy "John Spencer (MVP)" wrote: Since you deleted the records (note: not the table) I think your only way to recover is to use a backup to get the records back (up until the time you made the backup) or to use a data-recovery service to get the records back (expensive but it could be worth it depending on the data). Do NOT compact the database. *DO make a copy of it immediately. *And put the copy in a safe place, so that if anything goes wrong - you will not make a bad situation worse. *DO NOT use the copy - but if you need to start over make a copy of the copy and work on the copy. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Douglas J. Steele wrote: Check http://www.everythingaccess.com/tuto...ables-and-...- Hide quoted text - - Show quoted text - |
#7
|
|||
|
|||
Retriving deleted data from table
Thanks to all anyway.
I did it (www.everythingaccess.com). No undeleted data found. Case closed. I lose the data. I must type all again. Baaaaa. Let's go to work. Sh... Andy " wrote: Please see my post from back in 2007: http://groups.google.co.uk/group/mic...eted+ records Unfortunately you're probably out of luck on this one. If you contact me via our website (see below), I can check the file for you to see if there is anything that can be done in this case. Wayne Phillips http://www.everythingaccess.com On 14 Jan, 15:30, Andy wrote: I agree. I did not delete the table, just all records in it. Ther is no backup (She did not done, but she must). I still have a problem. I make a copy of database more of them. Then compact one of the copy and it a big difference. So, there must be data in original mdb. Is there any way to get data from the table? Thanks for help in advance Andy "John Spencer (MVP)" wrote: Since you deleted the records (note: not the table) I think your only way to recover is to use a backup to get the records back (up until the time you made the backup) or to use a data-recovery service to get the records back (expensive but it could be worth it depending on the data). Do NOT compact the database. DO make a copy of it immediately. And put the copy in a safe place, so that if anything goes wrong - you will not make a bad situation worse. DO NOT use the copy - but if you need to start over make a copy of the copy and work on the copy. John Spencer Access MVP 2002-2005, 2007-2009 The Hilltop Institute University of Maryland Baltimore County Douglas J. Steele wrote: Check http://www.everythingaccess.com/tuto...ables-and-...- Hide quoted text - - Show quoted text - |
Thread Tools | |
Display Modes | |
|
|