avoiding MS Access database modified time
-
Hi all, I have a MS-Access database. Whenever I open the database its modified date and time will be changed. I want whenever a change in the database ( by modifying records or tables ) then only the DB date and time should be changed. How to control by not modifying date and time, when only database is opened or accessed? How to do this?
-
Hi all, I have a MS-Access database. Whenever I open the database its modified date and time will be changed. I want whenever a change in the database ( by modifying records or tables ) then only the DB date and time should be changed. How to control by not modifying date and time, when only database is opened or accessed? How to do this?
I can't understand enough your question, can you explain more technically?
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com
-
Hi all, I have a MS-Access database. Whenever I open the database its modified date and time will be changed. I want whenever a change in the database ( by modifying records or tables ) then only the DB date and time should be changed. How to control by not modifying date and time, when only database is opened or accessed? How to do this?
You are not going to be able to manage the modified time of a file (your DB) from within the file, it will be in use by another process. If you need to track the changes made WITHIN the database then you are going to have to build the logging infrastructure to manage that and it will not be via the modified date of the database file.
Never underestimate the power of human stupidity RAH
-
I can't understand enough your question, can you explain more technically?
I Love T-SQL "Don't torture yourself,let the life to do it for you." If my post helps you kindly save my time by voting my post. www.aktualiteti.com
Yaah, Whenever we just open and close the database. The date and time of the database will be modified. I don't want this. ( date and time modification ). If I have changed the database ex: By adding new records or tables, or deleting records or tables then only the database modified date and time should be changed. how to do this?
-
Hi all, I have a MS-Access database. Whenever I open the database its modified date and time will be changed. I want whenever a change in the database ( by modifying records or tables ) then only the DB date and time should be changed. How to control by not modifying date and time, when only database is opened or accessed? How to do this?
You could possibly get and store the date before opening the file and restore it after closing. But I doubt it's worth the trouble.