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" <wb*******@inframez.org.use_dot_com_instead> wrote in message
news:uQ**************@TK2MSFTNGP15.phx.gbl...

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...

[Rob Schieber]

Wessam Bahnassi wrote:

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')

--
Rob Schieber

[Wessam Bahnassi]

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

Thanks a lot!

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:uc**************@TK2MSFTNGP09.phx.gbl...

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" <wb*******@inframez.org.use_dot_com_instead> wrote in
message news:uQ**************@TK2MSFTNGP15.phx.gbl...

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...

[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.

---
"Our enemies are innovative and resourceful, and so are we. They never
stop thinking of ways to harm our country and our people, and neither do
we." President George W. Bush

*** Sent via Developersdex http://www.developersdex.com ***

[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" <wb*******@inframez.org.use_dot_com_instead> wrote in message
news:OX*************@tk2msftngp13.phx.gbl...

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

Thanks a lot! "Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:uc**************@TK2MSFTNGP09.phx.gbl...

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" <wb*******@inframez.org.use_dot_com_instead> wrote in message
news:uQ**************@TK2MSFTNGP15.phx.gbl...

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 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 :)

--
Wessam Bahnassi
Microsoft DirectX MVP,
Lead Programmer
In|Framez
--
In|Structurez Arabic Gamedev Community
wwww.instructurez.com
"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:O%****************@TK2MSFTNGP09.phx.gbl...

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" <wb*******@inframez.org.use_dot_com_instead> wrote in
message news:OX*************@tk2msftngp13.phx.gbl...

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

Thanks a lot!

"Juan T. Llibre" <no***********@nowhere.com> wrote in message
news:uc**************@TK2MSFTNGP09.phx.gbl...

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" <wb*******@inframez.org.use_dot_com_instead> wrote in
message news:uQ**************@TK2MSFTNGP15.phx.gbl...
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...