I have a very large very old access database. It is currently 13 megs without any records (the records are kept on a network drive so mutliple users can access it). The problem is, over the years I have created forms, queries, and reports that are one time deals. To make makers worse some of my TEMP queries are linked to forms because I found them useful. Short of deleting stuff I don't think I need and crossing my fingers is there a way to find "LAST ACCESSED" information inside ACCESS?
2007-01-03 05:52:05 · 2 answers · asked by escapefromspringfield 2 in Computers & Internet ➔ Programming & Design
I guess I should also ask (for a best results answer) is there any tips or hints that would make my life easier. Beside not being an idiot and not keeping my database clean to start with.
2007-01-03 06:10:14 · update #1
No.
2007-01-03 05:56:44 · answer #1 · answered by Anonymous · 1⤊ 0⤋
Yes, it would require writing code in a module to list all table names whose data has been edited within a given date range.
I would pose your question on this forum as well for more detailed help in writing the code.
This a forum for database programmers who use MS Access.
http://www.utteraccess.com
Hope that helps. Good Luck! :)
2007-01-03 22:00:52 · answer #2 · answered by ean12967 2 · 0⤊ 0⤋