473,321 Members | 1,748 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,321 software developers and data experts.

recover deleted records in MS access database

I entered around 45000 records in a database. The database designed in MS access 2003. I deleted records most of them but accidentally I want to retrieve those records. Please guide me how to recover deleted records.Your cooperation in this regard is highly appreciated.

Thanking You

Dharmasiri
[e-mail address removed]
Jun 18 '13 #1
5 27410
Stewart Ross
2,545 Expert Mod 2GB
Access does not provide any way of retrieving deleted records. Once they are gone, your only hope of recovery is to use a backup of the database taken recently enough to have a copy of all the deleted records, or to recover a previous version of the database (if your operating system is set to provide this).

-Stewart
Jun 18 '13 #2
zmbd
5,501 Expert Mod 4TB
Stewart is correct in that generally, once deleted in MSA, that's it; however, if you are using 2010 (and sometimes the earlier versions) there may be hope provided some VERY SPECIFIC conditions are met:
How to: Recover Tables Deleted from a Database - Office 2010 This still may not recover your data; however, worth a shot.

(for the older versions: Recover Tables Deleted from a Database - Access 97 - once again, very strict conditions.)

I suspect however, given the age of the thread, that this information may be too late to help you - but it just may help the next person.

- I can not stress enough that one should never work on the production (in-use) version of the database - always a copy!

- I can not stress enough the need to have backup copies of the database. In fact, when I split the database to front/backend, the front end has code to periodically create a backup copy of the backend datafile --- and when deleting/updateing huge record counts (100+), the code first creates a backup - something to keep in mind.
Jun 19 '13 #3
Hello!

There are many Access users who are searching a free way to recover deleted records from MS Access database. So, I considered this issue and come up with this error-free solution. Here, click on the below mentioned link to know steps to recover unintentionally deleted records from Access database.

Steps to Recover Deleted Records From MS Access
Jul 4 '19 #4
NeoPa
32,556 Expert Mod 16PB
I'm going to make a call that this is acceptable, even though it could possibly be treated as spam.

It would be preferable if the related article were hosted on Bytes.com but nevertheless it is valuable information.

It includes a free utility but also explains the steps to take manually to get the same result.
Jul 4 '19 #5
isladogs
455 Expert Mod 256MB
This article may be of use to some of you:
Recover Deleted Database Objects
Mar 30 '23 #6

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

Similar topics

10
by: DaveDiego | last post by:
I've had a user delete one of the client records, I do have a version of the DB with all records intact before the deletion occured. Whats the best approach to getting all the related records in...
5
by: Grant | last post by:
Hi Is there a way to recover deleted records from a table. A mass deletion has occurred and Access has been closed since it happened Louis
1
by: KC | last post by:
I am using Access 2002, with a database template from MS Office. The Orders Management Database. I have tweaked this for use with our company. It is a small database with close to a 1000 records...
2
by: bd420 | last post by:
installation of their softwares? If there has NEVER been a backup of the Database (.mdf), Recovery Model Set to Full, and there has never been a backup of the Log (.ldf) files? Using the trial...
2
by: senthiltsj | last post by:
hi two days before arount 20,000 rows are manuly deleted, is there any way to recover it back. We have backup, that is 10 days old, Is there any way to recover only that 20,000 rows, Plz help...
2
by: Snonck | last post by:
Is is possible to recover deleted rows from a table from archive logs? For example, say you have a database with archive logging turned off. You create a table and populate it with records. You...
1
by: Astlik | last post by:
Hi, I was using phpmyadmin when, by mistake I deleted some rows from a table I didn't wanted to. I would like to know if anyone could help me recovering those records I deleted. I don't have any...
1
by: prairiewind via AccessMonster.com | last post by:
Throughout the year, I delete records which is a very common occurance in any database. However, from time to time, it would be nice to print off a list of the records that were deleted. Is it...
2
by: nano2k | last post by:
Hello I accidentaly ran a DELETE command against a table with a wrong WHERE clause. My database had no backup, but the recovery model was Full. I am using SQL Server 2005. Is there a way, or...
2
by: Jason7899 | last post by:
hi, there is any way to recover deleted records from a acess database? thanks a lot for your help )
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
1
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.