Hi, my name is XXXXX XXXXX I will try to assist you today with your problem, please let me know when you are ready
HI Pam, ready!
Hi, first of all did you work on the database for a long time, I ask because it may have saved along the way which we may be able to restore. Also what is the name of your database please
Hi, no I was not working on it a long time. I just opened it up to delete someone who we had been notified had just died. I copied this person from the main database (called OSA:Table) onto our list of deceased members (which we keep so that they can be mentioned at the AGM), and then tried to delete the entry from OSA:Table but instead deleted the whole Dec-11 (deceased in 2011) file.
so its the table you have deleted rather than the database is that correct?
Sorry I don't understand the difference. I am not trained in Access, just inherited the software and files when the previous person was taken ill, and I am trying to look after it until he is better. The main database is OK and I ahve been able to delete the deceased person. However the other file, perhaps a table or a sub-database, containing the people who have been deleted during 2011, is gone.
ok, thank you it seems you have deleted the table. Have you closed the database since you deleted the table, unfortunately if you have it may not be retrievable as usually the only way you can restore a deleted table is before you close the database.
I haven't closed the database, I realised that doing anything to it may be a bad thing, so it is still open and I have not done any actions on it.
ok can you first try just simply pressing ctrl z which is the simple undo command
thats ctrl and z at the same time
OK have tried and nothing happened
which version of access are you running do you know
Microsoft Access 2003
please can you bear with me a moment, there may be a way we can do this. I just need to check something first. Also can you please save your database using a different name to a different location but do not close it.
I may be about 10 minutes
Thanks, XXXXX XXXXX copy
I am still looking at some code that we can use to retrieve this please bear with me
I have some code that we can use to try and restore the table it is a little complicated is the procedure, do you want to try it?
i'll try it
OK thats' been done
Type or paste the following code in the module that you have just created:
just bear with me
dont copy the text,
just need to find a way to get the code to you in the correct line formats,,,, this window doesnt allow it
You have my email address - would that help?
Your above two requests did not reach me, so I logged out and in again, and now have seen them. Yes, I have now pasted the code into the module.
There is no option that says immediate window - where should I look?
Yes, it has opened at the bottom
OK thanks for your help. I am devastated at my error - I am in so much trouble.