difficult to advise in detail because it really depends how your system works. The below also does not stop users just opening the website manually
From an access and control perspective, in the first instance I would look at whether you can access and use the website using a web control. If you can then I would create a new popup and modal form with just the web control on and a label saying something like 'close form when finished with web app'. You might include another message warning against leaving it open unnecessarily. If web control doesn't work, include a hyperlink control so users can click on it to open the web app, or use some code in the popup open event to open the web page. Whilst the popup is open, users will not be able to use access so this should encourage them to close it to continue.
in your backend you will need a table something like
tblWebUtilisation
webPK autonumber
UserName text
StartDT datetime - default=now()
EndDT datetime
On your main form have a button captioned something like 'Use web app'
in the button click event code something like
Code:
dim rst as dao.recordset
set rst=currentdb.openrecordset("SELECT * FROM tblWebUtilisation WHERE EndDT is null")
if rst.eof then 'no users using web app so OK to open
currentdb.execute "INSERT INTO tblWebUtilisation (UserName) VALUES('" & environ("USERNAME") & "')"
docmd.openform "mypopupform"....
else
msgbox "User " & rst!username & " has been logged on since " & format(rst!startDT,"hh:nn:")
end if
rst.close
in the close event of the popup form, some code along the lines of
Code:
currentdb.execute("UPDATE tblWebUtilisation SET EndDT=Now() WHERE UserName='" & environ("USERNAME") & "' AND EndDT is Null")
You will not doubt need some management around the table if the popup form is not closed properly to 'unlock' it, otherwise users will not be able to continue.