get currentuser but how get password?

[Tiger__]

Hi,
I secured my database with the securityfeature of access itself. (Workgroupfile)
Now my problem is, i can retrieve the user who logged on to the application using the CurrentUser() method. But I also need to get the password to set my connectionstring. Isn't there a way to achieve this? Is there also a method to retrieve the password? Or another way?

Many thanks!

 

[DocZayus]

I was wondering the same thing...

I need the password, and also the group(s).

Access 2000.
Thank you.

 

[RCurtin]

Connect to secured Database through ADO

I have the same question. I have (finally!) secured my database. The back-end is located on the server and the frontend on the local drive along with the workgroup file.

So I did all that and some of my code stopped working because I was connecting to the tables through code..

WgName = "C:\DrawingsDB\DrawingsWorkGroup.mdw"      
    With conn
        .Provider = "Microsoft.Jet.OLEDB.4.0"
        .Open "data source=H:\DrawingDB\DrawingsDB_BE.mdb;jet oledb:system database=" & WgName, CurrentUser, "xyzPassword"
    End With

How do I open the connection using the current users password (so that I don't have to hard code it)?

Thanks in advance.

 

[RCurtin]

Connect to secured Database through ADO

I have the same question. I have (finally!) secured my database. The back-end is located on the server and the frontend on the local drive along with the workgroup file.

So I did all that and some of my code stopped working because I was connecting to the tables through code..

WgName = "C:\DrawingsDB\DrawingsWorkGroup.mdw"      
    With conn
        .Provider = "Microsoft.Jet.OLEDB.4.0"
        .Open "data source=H:\DrawingDB\DrawingsDB_BE.mdb;jet oledb:system database=" & WgName, CurrentUser, "xyzPassword"
    End With

How do I open the connection using the current users password (so that I don't have to hard code it)?

Thanks in advance.

 

[RCurtin]

Anyone have any ideas?

Maybe I should set up a special user with full permissions and put that username and password in the code? I will make an mde file so no one will be able to see the code anyways?

 

[KernelK]

Anyone figured this out

This is the same issue I am running into. Creating a master level account with full permissions for the code is feasible but I would still think that there should be a way to pass the current users info (including password) with the connection string.