Page 1 of 1

password in access files

Posted: Mon Mar 26, 2007 2:28 am
by hgarcia
Does somebody knows how to put a password in this file type via fivewin and xharbour?
I can open read write and close the access table but i don't know how put a password to encrypt it

Thank for any help

Re: password in access files

Posted: Mon Mar 26, 2007 8:16 am
by Enrico Maria Giordano

Code: Select all

FUNCTION MAIN()

    LOCAL oJro := CREATEOBJECT( "JRO.JetEngine" )

    LOCAL cConStr1 := "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=mymdb.mdb"
    LOCAL cConStr2 := "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=newmdb.mdb;Jet OLEDB:Database Password=newpwd"

    oJro:CompactDatabase( cConStr1, cConStr2 )

    RETURN NIL
EMG

password in access files

Posted: Mon Mar 26, 2007 12:38 pm
by hgarcia
sorry but I tried your solution and I have an ole error in compacdatabase instruction called by tole the name of the error is "error jro.jetengine/16389 sure I'm making something wrong

Re: password in access files

Posted: Mon Mar 26, 2007 12:46 pm
by Enrico Maria Giordano
I don't know. My sample works fine here.

EMG