Accessing a secured Access 97database

[andrew_mckeon]

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

[Michael]

Hi Andrew

You need to tell ADO which xxx.mdw you are using.
You do this by editing the "System Database" field when setting up the ADO connection.
If you are using DSN's you will find it on the bottom half of the form after you click "Configure".
If you are using the "Build" option for an ADO data control then you will find it on the "All" tab.
Hope this is of some use.

PS Nice to see another Brit on here - I was beginning to think I was the only one!

[This message has been edited by Michael (edited 07-15-1999).]