delete table- help me out plz

[SalimShahzad]

dear gurus,

help me out please...

some one on our network has deleted some tables...is there any way to
trace when what date time it was deleted...as table was part of
relation ship..using access 2003/2002 but no records fouinds


can any one help support any way to find any details from system
objects

thanks
ur student
shahzad

 

[John Vinson]

dear gurus,

help me out please...

some one on our network has deleted some tables...is there any way to
trace when what date time it was deleted...as table was part of
relation ship..using access 2003/2002 but no records fouinds

Other than by getting out your backup disks/tapes and determining when
the table vanished, no. Access does not keep track for you.


John W. Vinson[MVP]

 

[Jason Marshall]

Restore your backup copy and if any data is missing, re-enter it all.

Have fun

 

[SalimShahzad]

dear gurus,

there is backup but the back has also over write..so i lost in one
marince isnurance class 8 years of data

is there any way to protect tables, i can protec vba codes...but when
any one press shift so it by pass all security...and open everything in
front to users...my jobs is at highest risks..plz can some one help me
how to secure protec our db...

regards,
shahzad

 

[Alex]

A few things would come to mind for me:

Convert your forms and code into an MDE. Then do one of these:

1: Install SQL server and have your tables reside there. You can set
securtity at that point. This should lock it down pretty good.

2: Remove all the tables from your MDB and put them in another. Link
the two together and then hide one on a network share somewhere where
nobody would think to look. Also make it invisible. People can get to
and modify the tables if they know where to look.

3: Put all the tables in another MDB and hide it on the network
somewhere. Link the tables to your system via an ODBC link. Users can
still modify the original if they know where to look, but most would
not think to look in the ODBC manager to find out where the original
actually is.

4: Keep good backups. Not good security, just peace of mind. You are
making good backups right now, aren't you?

There are others, but each of these should be able to be done with a
minimum of effort or investment.

Good luck!

Alex.

 

[SalimShahzad]

1 Million dollars idea...thanks a lots sir...appreciated i will try
this and update you soon.

thanks once again
shahzad