Web Development

Ask something
Discussion Locked

Closing Down MS Access database remotely

0 helpful
3 replies

by will

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have Office 97 running on Windows 98 clients, on an NT4 network. My problem is that I need to close an access database that is running all day on computer A, at the end of the day from computer B. I will ideally do this with VBA from within another access database as Computer B runs an 'End of Day' macro.

3 replies

by eschlangen

Create a table in the db on A that contains one true false field with one record. Link to this table in db B. Create a hidden form in A that opens on startup and that sets the value of the record to false. This same form should have a timer macro that checks the value of the record in the new table every 5 minutes (or whatever interval you want) and closes the application if it is set to true. When you want to close A, use the link in B to set that value to True. Then go home. Then next time the timer macro runs it will shut down A.

by will

Thank you so much. This answer was staring me in the face, but I couldn't see it because it was too close to the end of my nose!!

Once again, Thank you.

This discussion is closed to new replies.