ASP Programming
 
Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
User Name:
Password:
Remember me
Go Back   Dev Shed Forums > Programming Languages - More > ASP Programming
Reload this Page

Restoring Deleted Records

Discuss Restoring Deleted Records in the ASP Programming forum on Dev Shed.
Restoring Deleted Records ASP Programming forum discussing Active Server Pages coding techniques and problem solving methods. Use VBScript or Jscript to make dynamic web applications.

Reply
Add This Thread To:
  Del.icio.us   Digg   Google   Spurl   Blink   Furl   Simpy   Y! MyWeb 
« Previous Thread | Next Thread »  
Thread Tools Search this Thread Rate Thread Display Modes
 
Unread Dev Shed Forums Sponsor:
Stay one step ahead of the competition. Evaluate and give feedback on some of the hottest web development tools on the market today. Make your opinion heard! Click Here
  #1  
Old July 26th, 2003, 04:56 AM
benseri benseri is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jun 2003
Location: Israel
Posts: 102 benseri User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
Send a message via ICQ to benseri
Restoring Deleted Records
I noticed that a database that was used and afterwards all its tables were manually deleted, is larger (in kb) then a new empty database.

Does the database store deleted records?
How can I retrieve deleted records and tables from a database?

Thanks, Ben.




P.S

I wanted to know if ADO Connection and Objects are the same in ASP & PHP, are they?
Reply With Quote
  #2  
Old July 26th, 2003, 11:54 AM
Shad Shad is offline
Junior Member
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jun 2003
Posts: 24 Shad User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 0
What database are you using?
Reply With Quote
  #3  
Old July 27th, 2003, 04:43 AM
benseri benseri is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jun 2003
Location: Israel
Posts: 102 benseri User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
Send a message via ICQ to benseri
MSAccess.
Reply With Quote
  #4  
Old July 27th, 2003, 03:05 PM
victorpendleton victorpendleton is offline
Contributing User
Dev Shed Regular (2000 - 2499 posts)
  
Join Date: Jan 2003
Location: No es importante
Posts: 2,065 victorpendleton User rank is Private First Class (20 - 50 Reputation Level)victorpendleton User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 6 h 31 m 56 sec
Reputation Power: 8
Transactions in MS Access are atomic. You will not be able to issue a command to undo DML modifications.
The database size could be larger until the data has been `flushed`, written to disk.
...
ASP & PHP are distinctly unique. PHP is a script langauge with C/C++ and Java roots. While ASP is also a scripting language, but with Visual Basic roots.
Reply With Quote
  #5  
Old July 27th, 2003, 04:17 PM
benseri benseri is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jun 2003
Location: Israel
Posts: 102 benseri User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
Send a message via ICQ to benseri
So You are saying that there can not be restoring of deleted records at all in MSAccess?

If so that why is the database larger? what do you meen by 'flushed'?

I don't realy know what DML modifications means, but the way I delete records in my database is with SQL stament "DELETE". Is it an DML modification?

Thanks Anyway, ben.
Reply With Quote
  #6  
Old July 27th, 2003, 09:25 PM
victorpendleton victorpendleton is offline
Contributing User
Dev Shed Regular (2000 - 2499 posts)
  
Join Date: Jan 2003
Location: No es importante
Posts: 2,065 victorpendleton User rank is Private First Class (20 - 50 Reputation Level)victorpendleton User rank is Private First Class (20 - 50 Reputation Level) 
Time spent in forums: 6 h 31 m 56 sec
Reputation Power: 8
Yes, DELETE is an example of DML. Flush refers to when data in memory is written to disk. MS Access does not posses the ability to ROLLBACK TRANSACTIONS.
INSERT, UPDATE, DELETE are all examples of Data Modification Language syntax.
Reply With Quote
  #7  
Old July 28th, 2003, 03:01 AM
benseri benseri is offline
Contributing User
Dev Shed Newbie (0 - 499 posts)
  
Join Date: Jun 2003
Location: Israel
Posts: 102 benseri User rank is Just a Lowly Private (1 - 20 Reputation Level) 
Time spent in forums: < 1 sec
Reputation Power: 6
Send a message via ICQ to benseri
O.K, Thanks...
Reply With Quote
Reply

Viewing: Dev Shed Forums > Programming Languages - More > ASP Programming > Restoring Deleted Records

« Previous Thread | Next Thread »

Thread Tools  Search this Thread 
Search this Thread:

Advanced Search
Display Modes  Rate This Thread 
Linear Mode Linear Mode
Rate This Thread:


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 Off
View Your Warnings | New Posts | Latest News | Latest Threads | Shoutbox
Forum Jump


Forums: » Register « |  User CP |  Games |  Calendar |  Members |  FAQs |  Sitemap |  Support | 
  
 





© 2003-2008 by Developer Shed. All rights reserved. DS Cluster 1 hosted by Hostway.