Helloo... i want to insert data in ms Access database . But it's always
failed.
At my Data Source i use  : server.mappath  (" \BukuASP\BabVI\database.mdb")
and database I save at D:\inetpub\wwwroot\BukuASP\BabVI\database.mdb. But
it's failed and  this is the error comment  :

System.Data.OleDb.OleDbException: Operation must use an updateable query

But if i move database.mdb at other directory like
E:\BukuASP\BabVI\database.mdb or D:\Inetpub\database.mdb. --> it's success

If I use select SQL command :
  myString = "SELECT * from DataUser "  and my data source = server.mappath
(" \BukuASP\BabVI\database.mdb")
--> it's success.


Why ??

This is my listing program :

  Sub Page_Load(Sender As Object, E As EventArgs)
    Dim myConnection As OleDbConnection
    Dim myCommand As OleDbCommand
    Dim insertstring AS string
    insertstring = "INSERT INTO DataUser (Username, Email, Pass, S_Question,
S_Answer) Values
('Grasindo', 'Gra@y...', 'dasd', 'Namaku', 'Gras')"
    myConnection = New OleDbConnection(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &

server.mappath("\BukuASP\BabVI\database.mdb") &";" )
    myConnection.Open()
    myCommand = new OleDbCommand(insertstring, myConnection)
    response.write (insertstring)
    myCommand.Executenonquery()
    myConnection.Close()
  End Sub

Thank you,

Handoyo







_________________________________________________________

Do You Yahoo!?

Get your free @yahoo.com address at http://mail.yahoo.com

> Helloo... i want to insert data in ms Access database . But it's always
failed.
At my Data Source i use  : server.mappath  (" \BukuASP\BabVI\database.mdb")
and database I save at D:\inetpub\wwwroot\BukuASP\BabVI\database.mdb. But
it's failed and  this is the error comment  :

System.Data.OleDb.OleDbException: Operation must use an updateable query

But if i move database.mdb at other directory like
E:\BukuASP\BabVI\database.mdb or D:\Inetpub\database.mdb. --> it's success

If I use select SQL command :
  myString = "SELECT * from DataUser "  and my data source = server.mappath
(" \BukuASP\BabVI\database.mdb")
--> it's success.


Why ??

This is my listing program :

  Sub Page_Load(Sender As Object, E As EventArgs)
    Dim myConnection As OleDbConnection
    Dim myCommand As OleDbCommand
    Dim insertstring AS string
    insertstring = "INSERT INTO DataUser (Username, Email, Pass, 
S_Question,
S_Answer) Values
('Grasindo', 'Gra@y...', 'dasd', 'Namaku', 'Gras')"
    myConnection = New OleDbConnection(
"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" &

server.mappath("\BukuASP\BabVI\database.mdb") &";" )
    myConnection.Open()
    myCommand = new OleDbCommand(insertstring, myConnection)
    response.write (insertstring)
    myCommand.Executenonquery()
    myConnection.Close()
  End Sub

Thank you,

Handoyo



Typically, with Access, which is a file, and not a Database Server, you 
should make sure that the user logged-in to your app has write privledges 
to that directory or specific file using NTFS. Obviously, without write 
privledges, you can't insert (write) data to the .mdb file. Assuming, you 
are using 2000 or XP with NTFS not FAT32, you would probably see that the 
Everyone Group has write permissions on the InetPub Folder, but not your 
BabVI folder. That would be my first guess.



_________________________________________________________

Do You Yahoo!?

Get your free @yahoo.com address at http://mail.yahoo.com