Re: can't insert into MS-access
| From: | Joe Van Meer | Date: | Sat, 16 Feb 2002 14:27:08 +0000 |
| Subject: | Re: can't insert into MS-access | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-16992@lists.php.net to get a copy of this message | ||
Hi there, sounds like you do not have the proper read/write permissions on
that file.
HTH Joe :)
Penockio <penockio@hotmail.com> wrote in message
news:20020212174327.84317.qmail@pb1.pair.com...
> I can't use sql command "insert into " but I can use "select" and it
> condition.I use DSN that provide by ODBC and use MS-Access as source file.
> I found Warning: SQL error: [Microsoft][ODBC Microsoft Access Driver]
> Operation must use an updateable query., SQL state S1000 in
>
> and my code is " insert into order_trans_detail
> (order_id,cus_id,order_place) values
> ('02120200007','0071577722451188','548/12 payatai Road Patumwan')
> ;" all
> field is text field for database MS-Access .and I connect it through ODBC
by
> ms access driver use (DSN)c
>
>