Go Back   Access World Forums > Microsoft Access Discussion > Modules & VBA

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 09-14-2019, 05:41 AM   #16
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,380
Thanks: 87
Thanked 1,648 Times in 1,530 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Last updated object in a database

Some time ago I actually found the definition object that explained the flags and type used for data types using Object Browser and an explicit reference to the appropriate library. However, that was stored on my Navy computer and I retired in 2016. I thought I would not need that info so didn't forward the reference to my personal account. (Silly me for that mental lapse.) The definition exists. It is just phenomenally obscure.

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Old 09-16-2019, 11:44 AM   #17
Pat Hartman
Super Moderator
 
Join Date: Feb 2002
Location: Stratford,Ct USA
Posts: 28,165
Thanks: 15
Thanked 1,576 Times in 1,498 Posts
Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all Pat Hartman is a name known to all
Re: Last updated object in a database

I don't want to edit the MSysObjects table, I just want to be able to determine when the last database object was changed. I use a query based on MSysObjects
Code:
SELECT MSysObjects.Name, MSysObjects.DateUpdate, MSysObjects.Type, MSysObjects.Name & " -- " & MSysObjects.DateUpdate AS UpdateData
FROM MSysObjects
WHERE MSysObjects.Type In(-32768, 5,-32764, -32766)
ORDER BY MSysObjects.DateUpdate DESC;
But I have found that I can change forms and save them and this query will not reliably show the change.

The query does not include modules or tables because these seem to get updated when I don't change them.
__________________
Bridge Players Still Know All the Tricks
Pat Hartman is offline   Reply With Quote
The Following User Says Thank You to Pat Hartman For This Useful Post:
Tera (09-16-2019)
Old 09-16-2019, 05:41 PM   #18
Tera
Newly Registered User
 
Join Date: Feb 2019
Posts: 243
Thanks: 415
Thanked 19 Times in 18 Posts
Tera is on a distinguished road
Re: Last updated object in a database

Quote:
Originally Posted by Pat Hartman View Post
The query does not include modules or tables because these seem to get updated when I don't change them.
I've added a sub to my switchboard's On Unload event to determine if any object has been changed base on MSysObject table's LastUpdated field comparing to the last back up date/time.
If anything is found it shows a msg of all updated objects and backs up the database.

I haven't seen anything suspicious since I've deployed this, but will have an eye on the list to see if what you say is true for Office 365 too.

Thanks for the alert.


Last edited by Tera; 09-16-2019 at 08:02 PM.
Tera is offline   Reply With Quote
Old 09-16-2019, 07:48 PM   #19
The_Doc_Man
Happy Retired Curmudgeon
 
Join Date: Feb 2001
Location: Suburban New Orleans, LA, USA
Posts: 14,380
Thanks: 87
Thanked 1,648 Times in 1,530 Posts
The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold The_Doc_Man is a splendid one to behold
Re: Last updated object in a database

Actually I dug this up from a rather circuitous method:

https://access-programmers.co.uk/for...d.php?t=103811

Pat Hartman and I answered a question for a user looking at database objects. We of course each answered from a different viewpoint.

(The circuitous method was that I was following a link from StackOverflow.)

__________________
I'm a certified grandpa (3 times now) and proud of it.
Retired over one year and survived being home all day with the wife. She must really love me.
If I have helped you, please either click the thanks or click the scales.
The_Doc_Man is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
RESOLVED: Updated field names in backend split database - forms not working HGCanada Forms 1 02-20-2018 08:51 AM
Database or Object read only and Type Mismatch error for a Serial Number Database surferdude800 Modules & VBA 16 06-17-2015 07:14 AM
Question updated database won't save zuzana General 4 02-26-2013 05:52 AM
Updated Date and Updated by User muralikreddy General 4 12-27-2008 03:49 AM
How to distibute an updated backend database? DocD General 1 12-01-2002 12:01 PM




All times are GMT -8. The time now is 09:29 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World