Password can be found in notepad.

[baguley]

Hi

I have a front-end back-end database that has a password on the back-end but not on the front-end.

By opening the front-end in notepad I can find the password for the back-end.

I tried encrypting the front-end but without a password you can unencrypt it without any trouble leaving me in the same place.

Is there any way of stopping people from finding out the password without putting a password on the frontend.

If not does anyone know a way that I can protect a split database.

Thanks in advance

Dave

 

[Travis]

The best method I found was a C++ DLL or a Visual Basic DLL.

You then reference the DLL from your code to get the Password.


An easier way may simply be to turn the front-end into an MDE for distribution.

 

[Phredd]

Help with Passwords

Can I get some advise / help on creating a password using this method...

Thanks

 

[Travis]

Which method.

C++?
Visual Basic?
Making the MDB file an MDE?

 

[Phredd]

Setting a password in a DLL with VB.

 

[Travis]

Create a VB ActiveX DLL.


Add one procedure to the Class Module

It only needs one procedure.


Example:

Public Functions GetPassword(byVal strPassCode as String) as String
Select case strPassCode
Case "XYZ": GetPassword="PASSWORD"
Case Else : GetPassword=""
End Select

End Function

Then in your Application call it by using the CreateObject Method on the DLL. Then simply call the DLL Objects GetPassword Function to retrieve the password.


See articles on creating/referencing VB ActiveX DLL's from the Microsoft Knowledge base for more indepth information.