How to change user password in Access?

Andrey Welmer

Delphi Developer

Tue, 01 May 2001 03:00:00 GMT

How to change user password in Access?

Friends,

With MSSQL I have sp_password stored procedure to change the password of
current database user, how can I do this in a MS Access database? There are
some BDE, ODBC or DAO function to do this?

Thanks in advance...

--
---------------------------------------------------------
Andrey Welmer
http://www.rn.senac.br
From Brazil, sorry about the english
---------------------------------------------------------

Wood

Delphi Developer

Tue, 01 May 2001 03:00:00 GMT

Re:How to change user password in Access?

If you are using DAO 3.5, you can do it through DAO using the
NewPassword function of an Access Database OLE object.

Woody

Quote

Andrey Welmer wrote in message <72h7mo$f...@forums.borland.com>...
>Friends,

>With MSSQL I have sp_password stored procedure to change the password
of
>current database user, how can I do this in a MS Access database?
There are
>some BDE, ODBC or DAO function to do this?

>Thanks in advance...

>--
>---------------------------------------------------------
>Andrey Welmer
>http://www.rn.senac.br
>From Brazil, sorry about the english
>---------------------------------------------------------

Andrey Welme

Delphi Developer

Fri, 04 May 2001 03:00:00 GMT

Re:How to change user password in Access?

Thanks,

Someone can send a code sample to me? Installing Microsoft Data Components
2.0, DAO 3.5 is installed too?

--
---------------------------------------------------------
Andrey Welmer
http://www.rn.senac.br
From Brazil, sorry about the english
---------------------------------------------------------
Woody escreveu na mensagem <72hs81$g...@forums.borland.com>...

Quote

>If you are using DAO 3.5, you can do it through DAO using the
>NewPassword function of an Access Database OLE object.

>Woody

>Andrey Welmer wrote in message <72h7mo$f...@forums.borland.com>...
>>Friends,

>>With MSSQL I have sp_password stored procedure to change the password
>of
>>current database user, how can I do this in a MS Access database?
>There are
>>some BDE, ODBC or DAO function to do this?

>>Thanks in advance...

>>--
>>---------------------------------------------------------
>>Andrey Welmer
>>http://www.rn.senac.br
>>From Brazil, sorry about the english
>>---------------------------------------------------------

Wood

Delphi Developer

Fri, 04 May 2001 03:00:00 GMT

Re:How to change user password in Access?

If no one sends you any, email me and I will send you a function that
you can use for this.

Woody

Quote

Andrey Welmer wrote in message <72p3rk$p...@forums.borland.com>...
>Thanks,

>Someone can send a code sample to me? Installing Microsoft Data
Components
>2.0, DAO 3.5 is installed too?

>--
>---------------------------------------------------------
>Andrey Welmer
>http://www.rn.senac.br
>From Brazil, sorry about the english
>---------------------------------------------------------
>Woody escreveu na mensagem <72hs81$g...@forums.borland.com>...
>>If you are using DAO 3.5, you can do it through DAO using the
>>NewPassword function of an Access Database OLE object.

>>Woody

>>Andrey Welmer wrote in message <72h7mo$f...@forums.borland.com>...
>>>Friends,

>>>With MSSQL I have sp_password stored procedure to change the
password
>>of
>>>current database user, how can I do this in a MS Access database?
>>There are
>>>some BDE, ODBC or DAO function to do this?

>>>Thanks in advance...

>>>--
>>>---------------------------------------------------------
>>>Andrey Welmer
>>>http://www.rn.senac.br
>>>From Brazil, sorry about the english
>>>---------------------------------------------------------

Andrey Welme

Delphi Developer

Mon, 07 May 2001 03:00:00 GMT

Re:How to change user password in Access?

Thanks for help,

I'll contact you...
--
---------------------------------------------------------
Andrey Welmer
http://www.rn.senac.br
From Brazil, sorry about the english
---------------------------------------------------------
Woody escreveu na mensagem <72pb51$q...@forums.borland.com>...

Quote

>If no one sends you any, email me and I will send you a function that
>you can use for this.

>Woody

>Andrey Welmer wrote in message <72p3rk$p...@forums.borland.com>...
>>Thanks,

>>Someone can send a code sample to me? Installing Microsoft Data
>Components
>>2.0, DAO 3.5 is installed too?

>>--
>>---------------------------------------------------------
>>Andrey Welmer
>>http://www.rn.senac.br
>>From Brazil, sorry about the english
>>---------------------------------------------------------
>>Woody escreveu na mensagem <72hs81$g...@forums.borland.com>...
>>>If you are using DAO 3.5, you can do it through DAO using the
>>>NewPassword function of an Access Database OLE object.

>>>Woody

>>>Andrey Welmer wrote in message <72h7mo$f...@forums.borland.com>...
>>>>Friends,

>>>>With MSSQL I have sp_password stored procedure to change the
>password
>>>of
>>>>current database user, how can I do this in a MS Access database?
>>>There are
>>>>some BDE, ODBC or DAO function to do this?

>>>>Thanks in advance...

>>>>--
>>>>---------------------------------------------------------
>>>>Andrey Welmer
>>>>http://www.rn.senac.br
>>>>From Brazil, sorry about the english
>>>>---------------------------------------------------------

Other Threads

1. How to change user password in IB Database 5.6 without SYSDBA password

2. Interbase Password and User add/change via Delphi?

3. How to change User's password

4. Changing User Password in Oracle 8

5. Change user IB password from application.

6. SQL links: Informix: change User/Password ?

7. Change User Password

8. Change User Password

9. How to change user passwords in app

10. Using SQL to change User's Password