adp project delete my data

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Right click on the table to open it.
Right click on the record and Filter by selection using Access interface.


I do not have any query to run it,
There is no other database activity at that time.

Any information is great appreciated,

Merci Beacoup,
 
Et comment sais-tu qu'il y a eu des données de perdu et que ce n'est tout
simplement pas un filtre quelque part qui serait resté actif?
 
After I had done the filter, the adp crashed.
I found that the tables were empty when I re ran the adp application.
It might be other database activity, but I could not find any.

I suspect the crashed of adp deleted the data.
That's why I asked that anybody has similar experiences,
If it is not, are there any possibility to happen like this?
Are there any way to investigate this issue?
It is critical to database to happen like this,

Thanks millions,
 
Personally, I'm very, very surprised that the crashing of an ADP application
deleted data and I cannot see in any way how this could happen.

ADP is a client application, running on the client side and never manipulate
the data directly on the server side. Instead, it manipulates the data by
asking the SQL-Server to perform the required change via standard queries.
The only effect a crashing could do on the server side would be to interrupt
and rollback any transactions currently opened by the ADP application itself
and leaves unaffected any other transactions, including those opened by
other ADP applications; even if these applications where running or not on
the same client machine.

Is it possible that these data have been written from inside a single big
transaction? If yes, then it's normal that all data written from this
transaction have been rolled back when the ADP crashed.
 
Back
Top