have a very specific function that I need a solution for, using VB6. Here’s the problem… I have an Access 2000 database sitting on a Windows 2000 file server. This database is accessed by numerous clients (users) throughout the day. The client software is particularly poorly written, in that it leaves connections open to the database (probably by not closing recordsets, etc) and as such, there is always an LDB (Access Locking File) accompanying the MDB (Access Database) at the end of the day. Overnight, by running a scheduled task, the database is compressed and moved to another area. If there is a lock on the database (as described above), this process does not happen because Access will not allow a locked database to be compressed. I need a programmatic (VB6) way of releasing the locks on the database. Before I go any further, I should point out that the client (user) code, or the scheduled task that compresses the database CAN NOT be changed. If they could, then I wouldn’t have this problem and I wouldn’t be here! In short, I just need to release the locks on the database, programmatically and across a network. Currently, this is being done each night manually from “Computer Management / System Tools / Shared Folders / Open Files??. From here, I can locate each user that has a lock on the database, right-click on the file and select “Close File??. Once I’ve done this for each client user, the database no longer has any locks and the compress process can succeed. The VB6 utility, which you will write for solving this problem, will run on a Windows 2000 Application Server but the database is sitting on a different file server (so there are security issues to solve). I “believe?? the answer lies within the NETAPI. If you think you can solve this quickly, and deliver a fully tested utility (written in VB6), then the job is yours.
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done. 2) Complete ownership and distribution copyrights to all work purchased.
## Platform
Windows 2000 Server