I have developed a client server database in Access 97 using. I wish to have a stand-alone VB 6 app, which checks to see if any records are overdue (every morning at 1 am). It then gets the name and email address together with other relevant information and generates emails and sends them to whoever is responsible for the overdue records using Winsock/SMTP.

This works fine when using a standard Access 97 database, however, when I try the same thing with a database that has been secured with a *.MDW workgroup file then I get a message back saying, “Cannot find the workgroup file/ the workgroup file is opened exclusively by another user.” I am sending the user id and password when connecting to the database. I have been using ADO but I will use any method that works! I have tried it with the server end of the client / server databases and with my ‘normal’ test database and it works only when I don’t use a workgroup file i.e. I use they standard system.mdw and have the user admin with no password.

I imagine that I need to tell the app where to find the workgroup. I have tried putting it in the same directory as the server but with no success.

Help please!

Andrew