Question How do I know that database window is accessed/opened?

[Khalid_Afridi]

Hi, all

can anyone tell me how do I know that database window is accessed on front End application linked with a back-end tables?

I have front end application on network using by 50 users which linked with back-end database. The back-end database however is password protected and front end is an accde fortmat moreover it's database window is also dissabled from being opening through Shift key.

however I want to create a function which alert me whenever a database window is accessed by un-authorized users, the function should store the username and his pc number in a hidden table. I have an Adminstrator from on my pc which monitors all the users loggedin to the database,their user names,pc numbers,loggedin times,loggedout time,sending messages to specific or all users,forcing all or specific user to loggout from the application etc...

in simple....

how do i know that database window is accessed/opened?

i can open the datbase window through VBA code with

DoCmd.SelectObject acTable, , True

but i don't need it. i can also store users information in a table using:

Dim sHostName As String
Dim sUserName As String
sHostName = Environ$("computername")
sUserName = Environ$("username")

I only want to know if is there any built in function when database window is accessed?


Thanks

Khalid Afridi

 

[HiTechCoach]

This may help:

Find out if the database container window is currently visible

What is someone links to the table in the front end from another database? Are you storing the back end passow3rd in the linked tables? If yes, then if you know where to look, you can get the password to the back end database.


TIP: I allow my front end to run only in runtime mode.

 

[Khalid_Afridi]

Thank you for your reply,
I have linked the tables in front end application with password storing linked tables. I then converted my Front End Application to runtime with Make ACCDE tools in accde format. I disable the database window to be opened with a function and password; its fine.

As far your TIP: I converted my front end application to accdr extension also by changing its extension. but if you re-change back to accde; its easily convertable to accde and vice-versa.

I try the link with API code and try to solve the problem but dont know how this fuction works.