Ps: sorry by the ELi5 comment its more like i am 5 trying to explain things. Is this possible? if yes could you put me on tracks to solve it? If you’re willing to give up the convenience of local branches, make sure to consider online-only banks, which offer the best interest rates and lowest fees, according to the WalletHub Banking Landscape Report.
![create access checking account tracker create access checking account tracker](https://sm.pcmag.com/pcmag_au/photo/s/subby/subby_wdcg.jpg)
#CREATE ACCESS CHECKING ACCOUNT TRACKER PC#
Johan turns on the first pc used by Alex and he tries to log inĪccess checks if this pc is associated with another account (as well as prrevious checks), as it detects that alex was ising this pc it asks if he wants to end previosus session on this pc, if no back to login, if yes asocuates this pc with johan and at the same time unasociating alex.Īnother person is usng his user without being troubled by alex and johan actionsįrom this poit of view i think that i just want to check wich pc (or even windows user, as we are using windows) is accesing the form so i can have multiuser enviroment. WalletHub has details on 177 checking accounts from banks and credit unions across the country that may meet your needs.
![create access checking account tracker create access checking account tracker](https://cdn.shopify.com/s/files/1/0768/4399/products/packages-robot-coupe_dd2f300f-5b1a-4b8a-a605-01cab69df18a_large.jpeg)
(alex is kinda bad with pcs)Īlex turns on another pc, he tries to loginĪccess checks if alex is being used (it is being used), system ask is he wants to end the other session (it dont cares if is the same pc) and if not it gets back to login form, if yes access reasociates alex and pc and its permission deleting previous asociationĪlex keeps working as nothing happened (change mades before save button are not recorded) this ends sucefully/Īccess saves the hour and date of the last modification and checks pc that made it, chcks associated user and saves it (alredy figured this)Īlex forces pc shutdown (normal shutdown, disconnects the cable o anything that stop normal logout recognition. I really dont need to rely on logout let me explain what i want to archieve.Īccess asosiates A with any form of pc identification and of course its permissionsĪlex adds/edits/deletes a database, all of three funcions are made on button request (alredy done)Īccess check which pc made the changes, checks asosiated user and permission,returns msgbox and blocks saving if needed. Once you've defined those limits it is much easier to prescribe one approach. The most important thing is to figure out exactly what it is you need Access to do and with how much granularity. You would have to use more fields if you want to record who has opened the record for editing. And even this will only be the last edit, not the current. If you're trying to track changes at the record level this is a completely different issue and will require some custom fields like DateModified, ModifiedBy. You could also write your own login form but this similarly can't reliably track log outs.
![create access checking account tracker create access checking account tracker](https://cdn.shopify.com/s/files/1/0768/4399/products/alto-shaam_339652f0-cf2c-4ca4-82c8-2977c00a56df_large.jpeg)
#CREATE ACCESS CHECKING ACCOUNT TRACKER CODE#
You could also go to the properties of the Access file (or lock file) directly on the server to see who is accessing/locking the file in the moment which is hard to do in code and tedious by hand. Sure you can detect if a particular windows user is logged on, but how do you know when they've logged off? You can't rely on Access always exiting gracefully so it is not as simple as adding code to autoexec (for start) and unload (for exit). It might be difficult to track who is logged in.