.mdb file problem
-
we have been working on application which use ..mdb file to store the data ... now if any one copies the database from c drive opens it which is password protected make changes and overwrite it back on program files ... is there any way we can find this out ... if someone has touched the db ... file is password protected but in case person knows the password ... like if we made some mistake in some entry and we open the db correct the entry and save it and then overwrite it in program files ... the application keeps working normally after that ... Please let me know if there is any software or method to find that out .
-
we have been working on application which use ..mdb file to store the data ... now if any one copies the database from c drive opens it which is password protected make changes and overwrite it back on program files ... is there any way we can find this out ... if someone has touched the db ... file is password protected but in case person knows the password ... like if we made some mistake in some entry and we open the db correct the entry and save it and then overwrite it in program files ... the application keeps working normally after that ... Please let me know if there is any software or method to find that out .
Well for a start .mdb indicates you are using Access which is a single user tool. Why is someone able to copy the file from your machine! Oh wait you probably have it on a server and a number of clients use it - WRONG TOOL for the job. Move to SQL Server. Password protection is supposed to PROTECT your file, you are not managing your passwords well enough! You can make your folder readonly so they can copy but not return the file. Not sure if this will stop you writing to the database - test it. It seem you are using the wrong tool in a badly managed environment, it is unlikely this will have a happy ending.
Never underestimate the power of human stupidity RAH
-
we have been working on application which use ..mdb file to store the data ... now if any one copies the database from c drive opens it which is password protected make changes and overwrite it back on program files ... is there any way we can find this out ... if someone has touched the db ... file is password protected but in case person knows the password ... like if we made some mistake in some entry and we open the db correct the entry and save it and then overwrite it in program files ... the application keeps working normally after that ... Please let me know if there is any software or method to find that out .
Maybe this discussion could help you: oledb - Detect time of last change on a Microsoft Access database table - Stack Overflow[^]
-
Well for a start .mdb indicates you are using Access which is a single user tool. Why is someone able to copy the file from your machine! Oh wait you probably have it on a server and a number of clients use it - WRONG TOOL for the job. Move to SQL Server. Password protection is supposed to PROTECT your file, you are not managing your passwords well enough! You can make your folder readonly so they can copy but not return the file. Not sure if this will stop you writing to the database - test it. It seem you are using the wrong tool in a badly managed environment, it is unlikely this will have a happy ending.
Never underestimate the power of human stupidity RAH
Mycroft Holmes wrote:
You can make your folder readonly so they can copy but not return the file. Not sure if this will stop you writing to the database - test it.
It will. Making the folder read-only would even stop you reading the database, because this is MS Access. In order to open the database, it has to create a lock file in the same folder.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
-
Mycroft Holmes wrote:
You can make your folder readonly so they can copy but not return the file. Not sure if this will stop you writing to the database - test it.
It will. Making the folder read-only would even stop you reading the database, because this is MS Access. In order to open the database, it has to create a lock file in the same folder.
"These people looked deep within my soul and assigned me a number based on the order in which I joined." - Homer
It's been 15 years since I touched Access, does that represent short memory loss I wonder. While I think Access has it's place, the moment it moves to a server or shared drive it becomes the wrong tool for the job.
Never underestimate the power of human stupidity RAH
