Access 97 / VBA Users...

...should NEVER be allowed to touch EM, no matter how much T-SQL they know.
She sent 7800 records into an external "black-box" system -- records whose
status wee need to track.
And then she deleted them from SQL Server. Now she's talking to one of our
C# guys about using a hex editor to crack the LDF file format to extract the
records that were deleted and restore them.
PLEASE have more intelligent suggestions?
Anyone who's an MCDBA will recall the MOC 2072 course in database
administration. As a former MCT, I still have the CD for that course, if
anyone has a chapter or lesson for me to refer to?
Peace & happy computing,
Mike Labosh, MCSD
"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave MustaneSounds like the DBA needs to be a bit more stingy with the access
permissions and management needs to spend a bit more time peering over their
shoulders.
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:O9sXfhcxFHA.916@.TK2MSFTNGP10.phx.gbl...
> ...should NEVER be allowed to touch EM, no matter how much T-SQL they
> know.
> She sent 7800 records into an external "black-box" system -- records whose
> status wee need to track.
> And then she deleted them from SQL Server. Now she's talking to one of
> our C# guys about using a hex editor to crack the LDF file format to
> extract the records that were deleted and restore them.
> PLEASE have more intelligent suggestions?
> Anyone who's an MCDBA will recall the MOC 2072 course in database
> administration. As a former MCT, I still have the CD for that course, if
> anyone has a chapter or lesson for me to refer to?
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "When you kill a man, you're a murderer.
> Kill many, and you're a conqueror.
> Kill them all and you're a god." -- Dave Mustane
>|||> Sounds like the DBA needs to be a bit more stingy with the access
> permissions and management needs to spend a bit more time peering over
> their shoulders.
HAH! What DBA?!? Why do you think me, a developer is on this group so
much'! I'm just an MCSD code monkey, and I'm probably the one here that's
most qualified as a DBA.
Did that send a shiver up your spine?
--
Peace & happy computing,
Mike Labosh, MCSD
"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane|||Mike,
The MS-2072 curriculum is not going to help. If she could delete the
records in EM then she could do it in any app. So it is more of a
permissions issue here.
A fix...POINT IN TIME recoverability using the transaction log. Or possibly
one of the third-party log exploring tools (could help minimize data loss
after the DELETE occured).
HTH
Jerry
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:OHOXzDdxFHA.720@.TK2MSFTNGP15.phx.gbl...
> HAH! What DBA?!? Why do you think me, a developer is on this group so
> much'! I'm just an MCSD code monkey, and I'm probably the one here
> that's most qualified as a DBA.
> Did that send a shiver up your spine?
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "When you kill a man, you're a murderer.
> Kill many, and you're a conqueror.
> Kill them all and you're a god." -- Dave Mustane
>|||All good software engineers start out as common code monkeys but eventually
evolve into a DBA.
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message
news:OHOXzDdxFHA.720@.TK2MSFTNGP15.phx.gbl...
> HAH! What DBA?!? Why do you think me, a developer is on this group so
> much'! I'm just an MCSD code monkey, and I'm probably the one here
> that's most qualified as a DBA.
> Did that send a shiver up your spine?
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "When you kill a man, you're a murderer.
> Kill many, and you're a conqueror.
> Kill them all and you're a god." -- Dave Mustane
>|||> A fix...POINT IN TIME recoverability using the transaction log. Or
> possibly one of the third-party log exploring tools (could help minimize
> data loss after the DELETE occured).
Yes, that's precisely what I'm looking for. I just found it at Module 7,
page 20.
--
Peace & happy computing,
Mike Labosh, MCSD
"When you kill a man, you're a murderer.
Kill many, and you're a conqueror.
Kill them all and you're a god." -- Dave Mustane|||Some thoughts here... http://www.karaszi.com/SQLServer/in...
mes.asp
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"Mike Labosh" <mlabosh@.hotmail.com> wrote in message news:O9sXfhcxFHA.916@.TK2MSFTNGP10.phx.
gbl...
> ...should NEVER be allowed to touch EM, no matter how much T-SQL they know
.
> She sent 7800 records into an external "black-box" system -- records whose
> status wee need to track.
> And then she deleted them from SQL Server. Now she's talking to one of ou
r
> C# guys about using a hex editor to crack the LDF file format to extract t
he
> records that were deleted and restore them.
> PLEASE have more intelligent suggestions?
> Anyone who's an MCDBA will recall the MOC 2072 course in database
> administration. As a former MCT, I still have the CD for that course, if
> anyone has a chapter or lesson for me to refer to?
> --
> Peace & happy computing,
> Mike Labosh, MCSD
> "When you kill a man, you're a murderer.
> Kill many, and you're a conqueror.
> Kill them all and you're a god." -- Dave Mustane
>