Re: Password

You are using single quotes for empty password. Instead, use back quotes ``

Kamran

"Princy" <noname@xxxxxxxxxxxxxxxxx> wrote in message
news:E6FBF6AB-B3CD-4F96-B00F-1F99CE3A1BE8@xxxxxxxxxxxxxxxx
I tried this way from VFP and also within Access2003 SQL

cSql = "ALTER USER admin PASSWORD pass1 ''"
=SQLEXEC(cnnSinaiPay, cSql)

Error generated as "Syntax error in ALTER TABLE"

Is this the right way to use?

--
Regards

WT


"Kamran" wrote:

Hi,

If you want this programmatically then sending this statement using
pass-thru may work (substitute mypassword):

"ALTER USER admin PASSWORD mypassword ``"

Kamran

"Princy" <noname@xxxxxxxxxxxxxxxxx> wrote in message
news:C6C67469-7D40-408C-99C9-C4BE0434B566@xxxxxxxxxxxxxxxx
Friends,

How to reset or change the password of MS Access database using VFP?

The reason is that I tried to compact a MDB database and it does not
work
with password protection. So I need to remove the password and then
compact
and then set password back

Any help would be appreciated

--
Regards

WT





.

Relevant Pages

  • Re: Password
    ... still I am getting the same error "syntax error in ALTER TABLE ... IF SQLEXEC(cnnSinaiPay, cSql) <= 0 ... The reason is that I tried to compact a MDB database and it does not ...
    (microsoft.public.fox.vfp.forms)
  • Re: DBI Issue with MySQL query
    ... to compensate for both Perl and MySQL stripping escape characters. ... you say you get a malformed SQL syntax error. ... single quotes, double quotes, escaped ...
    (perl.dbi.users)
  • Re: DBI Issue with MySQL query
    ... Thank you all for all the suggestions and time you spent on my non-problem. ... to compensate for both Perl and MySQL stripping escape characters. ... you say you get a malformed SQL syntax error. ... single quotes, double quotes, escaped ...
    (perl.dbi.users)
  • Re: Infinite Loops and Explicit Exits
    ... Infinite Loops and Explicit Exits ... > For ALTER, there was and is a long transition period. ... Its deprecation in those contexts (which is ... No, it's a *syntax error* to use it there, unless it's actually in something ...
    (comp.lang.cobol)
  • Re: Change table date/time field to text field in code
    ... I am getting error 3293 Syntax error in ALTER TABLE ... > to use a Text type field to hold date/time data though. ... rather than allenbrowne at mvps dot org. ...
    (comp.databases.ms-access)