automatic updatation of database through ASP

[vabsjava]

how to execute the sql queries related to databases

[chirag1989]

hi
i m using insert into statement for inserting records in access database
but its showin me error and askin to use an updateable query
wat should i do ??

[idsanjeev]

Hi Chirag
chack in which mode your database is open. Mainly occurs when database is not open in admodeReadWrite so please chek it

use an updateable query

Thanks

[chirag1989]

Hi Chirag
chack in which mode your database is open. Mainly occurs when database is not open in admodeReadWrite so please chek it

use an updateable query

Thanks

actual i have made my database in access
this is my first project in asp so i dont know very much about
the default mode
can u just tell me where shoul i specify the mode
i mean is ther any thing i access where they ask for modes
or its just there in asp

[idsanjeev]

Hi chirag
Are you not refer link
Any way your mean is don't know about mode
let when you open a database there are two way siply when open database that is in readonly but you wants to add data so have to open in readwrite let see example from entry attachment file.
Let me know if any confussion
Thanks