Re: Can see deleted data in MDF & Backup
Elmo,
Have them use scripts (these can be generated from Enterprise Manager (2000)
or Managment Studio (2005)) to create another database. Then use the data
import wizards to import the remaining data from their database into the new
database. Only the data will come over, not the pages that still contain
undeleted fragments of sensitive data.
Then they can send you the new database.
RLF
"Elmo" <Elmo@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0351943A-B16E-4351-B3C6-12A5BBC5B7B2@xxxxxxxxxxxxxxxx
I have a customer who need to send us their database but wont do so because
of sensitive info contained in it. They have tried deleting and truncatng
the data but you can still see the data if you open the mdf or backup with
a
text editor?
.
Relevant Pages
- Re: Any tips on working with a database that you did not create?
... am new to Access and taking over an entire database. ... In fact it had been thrown together using wizards ... Look through the queries and spot whether any of them are anything other ... Look at the reports. ...
(microsoft.public.access.gettingstarted) - Re: Any tips on working with a database that you did not create?
... am new to Access and taking over an entire database. ... In fact it had been thrown together using wizards ... Look through the queries and spot whether any of them are anything other ... Look at the reports. ...
(microsoft.public.access.gettingstarted) - Re: Any tips on working with a database that you did not create?
... I was given what looked like a "nearly finished" database which apparently represented a great deal of work. ... In fact it had been thrown together using wizards based on a wholly wrong table structure. ... Check to see if the database has "linked tables" - a common way of building a database is to put the tables in one file and all the queries, forms and reports in another, and link the two. ...
(microsoft.public.access.gettingstarted) - Re: Creating Forms is tedious
... wished the original writer had spent a lot less time making the ... but forms and other database objects ... >that appear sloppy often are sloppy. ... >wizards, and other fluff, and so have made it far more ...
(microsoft.public.access.forms) - Re: Any tips on working with a database that you did not create?
... looked like a "nearly finished" database which apparently represented a great deal of work. ... In fact it had been thrown together using wizards based on a wholly wrong table structure. ... Check to see if the database has "linked tables" - a common way of building a database is to put the tables in one file and all the queries, forms and reports in another, and link the two. ...
(microsoft.public.access.gettingstarted) |
|
