AboutScottgem Expertise I can answer almost all types of questions relating to Microsoft Access usage and application design. My strengths are database and interface design.
Experience I've been designing databases for over 15 years working with dBase, FoxPro, Approach and Access.
Organizations Author of Microsoft Office Access 2007 VBA Techncial Editor for Special Edition Using Microsoft Access 2007 and Access 2007 Forms, Reports & Queries From Que Publishing
Is it possible for me to find out the IP or Computer name or the current person in a database? We use Access 2000 and I have a time out implemented so the user has to be active in the database or it will close down in 30 mins, the Project manager doesn't want that to be any lower but I am still having issues with people being in it when updates to the data are needed, it is important that everyone is pulling correct information. If I knew who was in it I could call and make sure they are still using and that they are using up-to-date data, thank you in advanced for any of your ideas.
It can actually send a meesage to all users who have the database open. You can include that as part of your shut down routine to send a message a few minutes before shutdown.
Hope this helps,
Scott<>
Microsoft Access MVP 2007
Author: Microsoft Office Access 2007 VBA
