Recovering table - Microsoft Access / VBA

news.dsl.pipex.com

Hi

Is it possible to recover a table if it has been deleted and before the mdb
file has been compacted?

Thanks

Regards

Nov 12 '05 #1

Subscribe Reply

1927

Wayne Morgan

If you haven't done anything at all since the delete, Undo will return it.
If you've gone beyond that, you'll need to restore from a backup or send the
file to a data recovery shop.

--
Wayne Morgan
Microsoft Access MVP
"news.dsl.pipex.com" <jo**@nospam.infovis.co.uk> wrote in message
news:40*********************@news.dial.pipex.com.. .

Hi

Is it possible to recover a table if it has been deleted and before the mdb file has been compacted?

Thanks

Regards

Nov 12 '05 #2

Tony Toews

"news.dsl.pipex.com" <jo**@nospam.infovis.co.uk> wrote:

Is it possible to recover a table if it has been deleted and before the mdb
file has been compacted?

Possibly.

Delete Records or Deleted Tables from Microsoft Access MDBs
http://www.granite.ab.ca/access/deletedata.htm

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm

Nov 12 '05 #3

Peter Miller

On Tue, 11 May 2004 01:35:22 +0100, "news.dsl.pipex.com"
<jo**@nospam.infovis.co.uk> wrote in comp.databases.ms-access:

Is it possible to recover a table if it has been deleted and before the mdb
file has been compacted?

Yes, it is entirely possible to recover not just one deleted table,
but all deleted tables and their data within a database that has not
been compacted, and this is true regardless of whether you have closed
Access since deleting the tables. It is true when Undo fails. It is
also true even when the solution Msft posted in the kb fails (that
solution applies to just a single deleted table in a limited set of
circumstances).

Peter Miller
__________________________________________________ __________
PK Solutions -- Data Recovery for Microsoft Access/Jet/SQL
Free quotes, Guaranteed lowest prices and best results
www.pksolutions.com 1.866.FILE.FIX 1.760.476.9051

Nov 12 '05 #4

Similar topics

6253

Help - Recovering a deleted job

by: Ryan | last post by:

Any ideas how I can recover a job that has been deleted (?) from SQL 7.0 ? We had one which was used on a regular basis which has now ceased to exists. I've spoken to the people responsible for the...

Microsoft SQL Server

2095

Recovering from transaction log deletion in 6.5

by: Charles Nadeau | last post by:

I was trying to relocate my transaction log to a bigger drive using sp_movedevice but I made a mistake in the syntax of the second parameter and put only the path, not the path and the file name....

Microsoft SQL Server

2306

Off - Topic... need help recovering inadvertently deleted mdb file off Windows XP machine

by: MLH | last post by:

I don't know how it happened. I have hundreds of hours worth of work invested in a file I foolishly named DB9.mdb. I was intending on renaming the file soon. But I neglected to do so before...

Microsoft Access / VBA

307

Recovering table

by: Robert | last post by:

Is there any way to recover a table after you delete it from Access? Robert

Microsoft Access / VBA

4575

Recovering data from corrupted table. Urgent Help!!

by: ruben20 | last post by:

Hi: Is there any way to recover data from a corrupted table? I can only run SELECTs on certain WHERE conditions. I cannot vacuum, pg_dump, I've deleted the indexes and try to reindex, always...

PostgreSQL Database

1774

Recovering deleted rows

by: Hamvil | last post by:

Hi, I have a table with a primary key defined with the auto_increment option. I've incidentally deleted some rows from this table and I would like to know if it is possible to recover that...

MySQL Database

1551

Recovering A Table

by: Sheldon | last post by:

Someone here at work was out and her backup, apparently, erased a very important table. While the Help Desk is trying to locate a backup tape, I was wondering if there is a way to get the table...

Microsoft Access / VBA

3634

Recovering gracefully from a realloc() failure

by: Philip Pemberton | last post by:

Hi, I'm currently playing around with a little spam filter for my Linksys NSLU2 (I would have used Spamassassin but that's slow even on my 2GHz Athlon64 - on a 266MHz XScale it's likely to be...

C / C++

1076

Recovering data out of dataset from client

by: TiGeR79 | last post by:

Hello, I've written a webservice which returns a dataset containing just one table with two columns. One colum holds a string while te second holds an image serialized into a byte array. This...

.NET Framework

1406

Recovering tables from DB2 V2

by: FearlessFerret | last post by:

I have a database instance from DB2 V2 under AIX 3.2.5. I want to dump all the tables in this database, but don't have a running DB2 V2 instance. Assume I have access to any number of 'modern'...

DB2 Database

7134

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...

General

7014

Changing the language in Windows 10

by: Hystou | last post by:

Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...

Windows Server

7229

Maximizing Business Potential: The Nexus of Website Design and Digital Marketing

by: jinu1996 | last post by:

In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

Online Marketing

6905

The easy way to turn off automatic updates for Windows 10/11

by: Hystou | last post by:

Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...

Windows Server

7395

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

by: tracyyun | last post by:

Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...

General

5485

AI Job Threat for Devs

by: agi2029 | last post by:

Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...

Career Advice

3108

Trying to create a lan-to-lan vpn between two differents networks

by: TSSRALBI | last post by:

Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The...

Networking - Hardware / Configuration

1429

transfer the data from one system to another through ip address

by: 6302768590 | last post by:

Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated ...

C# / C Sharp

667

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP