Using Password Protected Access Database with Datadesigner

Hi,
I need to use a password protected access database with datadesigner in vb 6.

I do not know anything about workspaces and the software that i am designing will be used on several machines which will not share a single workspace file.

When i try to give a password in the connection property in data environment, i get an error stating the workgroup info file is missing.

Please help me on how to use the password protected access database with th data designer.

I am not using any library for data access.

Thanks

Please Friends, some one help me out.
If there isnt any way that what i need can be done, please say so , so that i may upgrade to ADO, although i already have coded so much that it would be a difficult task.