Change Access password using SQL query

[pslpsl]

I want to add/modify/delete my Access DB password using an SQL query sent by a Delphi application through ODBC.

The following doesn't work : "ALTER DATABASE PASSWORD new, old".

Does anyone has got an idea to do it ?
Thanks

 

[mp9]

You don't need the comma between

new

and

old

(I think).

Also, if there wasn't an old password, you need to include a

NULL

, i.e.

ALTER DATABASE PASSWORD new NULL

Hope this helps.

http://www22.brinkster.com/accessory/

 

[pslpsl]

I have the following error message :

[Microsoft][Pilote ODBC Microsoft Access] Instruction SQL non valide; 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' ou 'UPDATE' attendus.

 

[pslpsl]

I have the following error message :

[Microsoft][Pilote ODBC Microsoft Access] Instruction SQL not valid; 'DELETE', 'INSERT', 'PROCEDURE', 'SELECT' or 'UPDATE' expected.