Smartgambler
Pro-Punter

Go Back   OZmium Sports Betting and Horse Racing Forums > Public Forums > Horse Racing
User Name
Password
Register FAQ Search Today's Posts Mark all topics as read

To advertise on these
forums, e-mail us.

Reply
 
Thread Tools Search this Thread Display Modes
  #1  
Old 9th February 2006, 06:50 PM
Duritz Duritz is offline
Member
 
Join Date: Dec 2004
Posts: 956
Default 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??
Reply With Quote
  #2  
Old 9th February 2006, 07:28 PM
Punter76 Punter76 is offline
Member
 
Join Date: Feb 2006
Posts: 36
Default

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.
Reply With Quote
  #3  
Old 9th February 2006, 07:37 PM
Duritz Duritz is offline
Member
 
Join Date: Dec 2004
Posts: 956
Default

Thankyou Punter76, for those words.
Reply With Quote
  #4  
Old 9th February 2006, 07:37 PM
crash crash is offline
Suspended.
 
Join Date: Jan 1970
Location: gippsland lakes/vic
Posts: 5,104
Default

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.
Reply With Quote
  #5  
Old 9th February 2006, 07:53 PM
Duritz Duritz is offline
Member
 
Join Date: Dec 2004
Posts: 956
Default

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?
Reply With Quote
  #6  
Old 9th February 2006, 08:33 PM
lomaca lomaca is offline
Member
 
Join Date: Jan 1970
Posts: 1,096
Default

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.
Reply With Quote
  #7  
Old 9th February 2006, 08:49 PM
Duritz Duritz is offline
Member
 
Join Date: Dec 2004
Posts: 956
Default

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.
Reply With Quote
  #8  
Old 9th February 2006, 09:10 PM
lomaca lomaca is offline
Member
 
Join Date: Jan 1970
Posts: 1,096
Default

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?

Last edited by lomaca : 9th February 2006 at 09:18 PM.
Reply With Quote
  #9  
Old 9th February 2006, 09:16 PM
Duritz Duritz is offline
Member
 
Join Date: Dec 2004
Posts: 956
Default

Thanks Iomaca.
Reply With Quote
  #10  
Old 9th February 2006, 09:25 PM
lomaca lomaca is offline
Member
 
Join Date: Jan 1970
Posts: 1,096
Default

Quote:
Originally Posted by Duritz
Thanks Iomaca.

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


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is On
Forum Jump



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


Powered by: vBulletin Version 3.0.3
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
©2008 OZmium Pty. Ltd. All rights reserved . ACN 091184655