trying to find away to trak or log objects usage

[itm]

Hi,


I am particularly looking to see if a user opened a table or query and send it to a log file or a table. I know how get the windows user and the computer name, I just have not been able to find a way to detect if these objects are open or closed. I thought that I may be able to do something with the object ID in the MSsysObject table, but I have not found away; and I am using MS access 2007.
Any ideas if this possible would be really appreciate.
Thank you

[John_G]

Hi -

It's never a good idea to allow your users to open tables or queries directly - access should always be through forms (or code). It would then not be too difficult to track who does what, using VBA.

None of the properties of tables relate to "last user", so you are probably going to have to use VBA.

John

[itm]

Yah I know but the problem is that I have not found a way to hide them fromthe user. Anything that they are supposed to go into is on the form, but they could still go into the side menue and go into them through there. I mad an accde but they still could access the tables, queries and forms. So I thought that is we could track it, we could try to controll it.

Any thoughts how I could lock out the users from these objects? If I cannot track it?
Thank you

[redbull]

So I see this... you want to hide the navigation options of your app. If your users are on 2003, this is what you do.

Tools ~> Startup
Once here, you set them on a custom menu... this will remove the top menu...

Next step
With code, on your primary form... Add this form load or current code.

Private Sub Form_Current()
Application.CommandBars.DisableAskAQuestionDropdown = True
DoCmd.Maximize
Application.CommandBars.DisableCustomize = True
End Sub

Alright So that will eliminate the Database window, because your form will open in maximize.
----------------------

Now I designed my program in 2003, when people started opening the app in access 2010... some of them were seeing things they should not....

SO I went into every form/table/query/etc/etc right clicked, and marked all as hidden. On your machine, go into your preferences and enable to view hidden objects... but by default this is disabled... so the standard user will not be able to see anything.

-----------------------

Tracking your app.... I do this, however I only track things the users are supposed to click.. usage metrics etc etc.. It involves the Front end, and a back end. The back end is basically a table that the front end sends an insert query too whenever a button is clicked. If you want to get more in depth about this let me know... but the tricks above should resolve some (or all?) of the issue your having.