Access - Workgroup file

[AGP]

I have a VB6 application that connects an Access 2000 database using Microsoft Jet.OLEDB.4.0. I have added a password to the database, however whenever I try and connect to the database I receive the following error message:

workgroup file is missing or exclusively locked by another user.

my connection string is as follows:

cn.ConnectionString = "Provider=Microsoft.jet.OLEDB.4.0; Data Source=" & App.Path & "/appointments.mdb; User Id=admin; password=mypassword"

Is there anyway that I can have a simple password protected database, without having to bother about workgroup files? I am sure I have done this before! The reason I do not want to use a workgroup file is that I wish to create my own security.
many thanks.

 

[CajunCenturion]

AGP - I see from your profile that you've asked over 65 questions and have yet to indicate that you've received a helpful response. I also see that you have not given of your time to participate in questions asked by others.

Tek-Tips is forum by and between professionals who freely give their time to help others in the profession. It is based on a give a take relationship, and everyone, like yourself, is a volunteer, giving of their own valuable time to participate. I invite you to become more involved, show some appreciation to those have given of their time to provide you help, and hope that you can find some time to return the favor by providing help to someone else.

What Tek-Tips is not is a free tech support site, a code swap shop, or a place where you can come in hope that you can get someone to do your work for you. Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[rorubin]

Um...tough room. . Okay open MSAccess goto tools->security and then to Workgroup Administrator. Take a look at the value for the workgroup file, you will find that it does not exist or cannot be reached from your computer, create a new one, or join an existing one and problem will go away.

If you have a default MDW and don't pass security parameters you will be logged in to an unsecure database.

Good luck.