OZmium Sports Betting and Horse Racing Forums

OZmium Sports Betting and Horse Racing Forums (http://forums.ozmium.com.au/index.php)
-   Horse Racing (http://forums.ozmium.com.au/forumdisplay.php?f=5)
-   -   Database help - deleted accidentally!! Please advise!! (http://forums.ozmium.com.au/showthread.php?t=12527)

Duritz 9th February 2006 06:50 PM

Database help - deleted accidentally!! Please advise!!
 
Hi guys. I'm a fool. I am building this access DB (racing of course), I have a version from 12 hours ago on my laptop, and the version which just finished, ready to use, from just now, on my PC. So, I've gone to transfer the PC version onto the laptop, because I no longer need the 12 hour ago version, and guess what, I've transferred the 12 hours ago version over the top of the new one instead.

Idiot.

So, on laptop and PC now are the 12 hour ago version only!!!

Can I recover it?? Anyone help??

Punter76 9th February 2006 07:28 PM

About 4 months ago I lost everything, had it all on a USB Card, and it
played up and deleted everything.

Suicide was an option, 6 months of data gone in a second.

Duritz 9th February 2006 07:37 PM

Thankyou Punter76, for those words.

crash 9th February 2006 07:37 PM

It's there. It can't get off the HD. Try a system restore to a point before the new download over the top. Worth a shot.

Duritz 9th February 2006 07:53 PM

Thanks Crash, just had a look, the time it picked for today's system restore was only ten minutes ago, and yesterday's is too long ago.

Thanks though, any other thoughts?

lomaca 9th February 2006 08:33 PM

Quote:
Originally Posted by Duritz
Thanks Crash, just had a look, the time it picked for today's system restore was only ten minutes ago, and yesterday's is too long ago.

Thanks though, any other thoughts?


System restore does NOT restore lost data on any hard drive!
It will restore system settings, ie programmes etc. (if you are lucky)

Re. Access.
Depends what you have done? imported, copied ?
In this case depending on your settings it will import the DB with the same name
but adding a number to the and of it like "MyDb1" if you already had MyDb.
However if you have run a query to replace the lot then you lost the lot.
No way to recover.

Duritz 9th February 2006 08:49 PM

I have copied over the top of the original one. Say the DB was called "racing.mdb", then I had a copy of "racing.mdb" on the PC, and on the laptop. The PC version was the current one, the laptop version the older one. So, I accidentally copied over the PC version with the older laptop version. So now the current racing.mdb is seemingly gone, replaced by the older racing.mdb.

lomaca 9th February 2006 09:10 PM

Quote:
Originally Posted by Duritz
I have copied over the top of the original one. Say the DB was called "racing.mdb", then I had a copy of "racing.mdb" on the PC, and on the laptop. The PC version was the current one, the laptop version the older one. So, I accidentally copied over the PC version with the older laptop version. So now the current racing.mdb is seemingly gone, replaced by the older racing.mdb.

I have no time to find the settings now, but if I import or copy any DB or table on my comp. it will simpy copy it with the same name and an additional number, that is I can copy it three times and I will get the original MyDb, MyDb1, MyDb2 and MyDb3.
Your settings are obviously different, sorry in this case you lost it, but be happy it was 12 hours only.
Incidentally I have set my Access so, that I will get no warning when I delete a table, bad idea if you are not careful.

PS just re-read your post again, you are not talking Access at all, you are talking Windows Explorer, sorry, in this case you have overwritten the file. (the fact it was a database means nothing) if you had done nothing in the meantime, you could just go back to the same folder and repeatedly press "control/z" to undo what you have done. I suspect it is too late for that?

Duritz 9th February 2006 09:16 PM

Thanks Iomaca.

lomaca 9th February 2006 09:25 PM

Quote:
Originally Posted by Duritz
Thanks Iomaca.

control and the letter z at the same time sorry if I offended you by this!


All times are GMT +10. The time now is 07:44 AM.

Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.