Close an access database from another program

[hk1]

I'm working on building a system that will allow me to close a user's database. We have too much trouble with users leaving databases open overnight.

1) Does anyone have a suggestion how to do this or a method they have tried that worked or didn't work?

2) Would it be possible for me to design something in VB6 that runs on the computer and can "talk" to an Access database without using text files? How can an outside program talk to an Access database?

In my preliminary plans I figured I'd use the Winsock control to listen on a UDP port for a close request and then the program would use an intelligent method to close the database.

 

[pbaldy]

It's from within rather than from without, but I've used this:

http://www.peterssoftware.com/fsd.htm

 

[hk1]

Thanks. I think I'll go the "from within" route but I believe I'll use UDP with a Winsock Control. This allows me to accomplish it without any timers and without the network activity involved in checking the shared backend for a boolean record value.