Re: Accidental delete in linked table
- From: Tom van Stiphout <no.spam.tom7744@xxxxxxx>
- Date: Wed, 15 Mar 2006 07:16:15 -0700
On 14 Mar 2006 23:33:20 -0800, "jkw" <jkwraase@xxxxxxxxxxxxx> wrote:
The sql statement:
select count(*) from MyTable
will give you the number of rows in the table.
I think you're safe. If you normally see that prompt, no records have
been deleted yet. Access uses a transaction for such operations, and
the prompt essentially askes for CommitTrans or Rollback. If you
killed Access before that, no records have been deleted.
You could try this on a *test* table.
What are you running such queries against the production database
anyway? Do you like playing with your job? This is why developers work
on test databases! Go fix that TODAY.
-Tom.
Hi - I created a linked table via ODBC to a SQL Server database. The
table in SQL Server contained over 12,000,000 records. Later, I
started a "Delete" query. When I realized that I was deleting from the
SQL Server, I panicked and tried to stop the query. Esc didn't work,
so I killed Access with Ctrl-Alt-Del (task manager). Is there any way
to know if the query managed to delete any records in the SQL Server
database? I had not yet seen the "You are about to delete "x" records,
are you sure..." prompt. Can anyone advise? I need to decide if I
have to get the SQL Server database restored to the day before this
happened and then run all the data loads from that point until now.
Thanks!
.
- References:
- Accidental delete in linked table
- From: jkw
- Accidental delete in linked table
- Prev by Date: MS 2000 Secured Database
- Next by Date: Re: MS 2000 Secured Database
- Previous by thread: Re: Accidental delete in linked table
- Next by thread: Fresh Copy
- Index(es):
Relevant Pages
|
|
