MS Access trouble

[Wessam Bahnassi]

Greetings,

I'm trying to insert values into an MDB with ASP.NET 1.1, and the OleDb Jet
4 provider.
However, whenever I issue and INSERT INTO statement I get the exception:
"Operation must use an updateable query."

This is my code:

string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
connString += Server.MapPath("db\\records.mdb");
connString += ";"
OleDbConnection connection = new OleDbConnection(connString);
connection.Open();

OleDbCommand dbCmd = new OleDbCommand("INSERT INTO DSKSB_Demos ",conn);
dbCmd.CommandText += "(Platform,Company,Title) VALUES (win32,sci,mr)";
dbCmd.ExecuteNonQuery(); // Exception...
conn.Close();

If I only read data then no errors occur. The MDB file is not set to
Read-only.
It's a normal file put in c:\inetpub\wwwroot\mysite\db

How can I overcome this exception?
Thanks for any help...

 

[Juan T. Llibre]

Give the ASP.NET account read/write/change permissions
over the c:\inetpub\wwwroot\mysite\db\ directory.



Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================

 

[Wessam Bahnassi]

Sorry if it is too obvious, but how do you grant the ASP.NET account these
permissions?

Thanks a lot!

 

[Rob Schieber]

Greetings,

I'm trying to insert values into an MDB with ASP.NET 1.1, and the OleDb Jet
4 provider.
However, whenever I issue and INSERT INTO statement I get the exception:
"Operation must use an updateable query."

This is my code:

string connString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=";
connString += Server.MapPath("db\\records.mdb");
connString += ";"
OleDbConnection connection = new OleDbConnection(connString);
connection.Open();

OleDbCommand dbCmd = new OleDbCommand("INSERT INTO DSKSB_Demos ",conn);
dbCmd.CommandText += "(Platform,Company,Title) VALUES (win32,sci,mr)";
dbCmd.ExecuteNonQuery(); // Exception...
conn.Close();

If I only read data then no errors occur. The MDB file is not set to
Read-only.
It's a normal file put in c:\inetpub\wwwroot\mysite\db

How can I overcome this exception?
Thanks for any help...

Wessam,

I think you need tick marks around your string literals:
(win32,sci,mr) should be ('win32','sci','mr')

 

[Will Chamberlain]

Right-click on the folder containing the database and change the
security settings to read, write, modify, or whatever combination you
need to complete the task.

 

[Juan T. Llibre]

From within Windows Explorer, right-click the directory
and select the "Properties" link; then select the "Security" tab.

If you don't see a "Security" tab, you might be running FAT32
( hopefully not... ) and you might need to convert your file system
to NTFS.

FAT32 file systems don't allow setting ACLs.



Juan T. Llibre, ASP.NET MVP
ASP.NET FAQ : http://asp.net.do/faq/
Foros de ASP.NET en Español : http://asp.net.do/foros/
======================================

 

[Wessam Bahnassi]

Thanks to all of ya guys. No I'm running NTFS, and I setup the permissions
and everything is now running file...

Thanks again