Dreaded "Must Use Updateable Query"

[ewpatton]

I'm having trouble using OdbcConnection and OdbcCommand to make
updates to a System database. I can open the database in Access and
make changes, but executing a simple:

INSERT INTO LoginInfo DEFAULT VALUES

fails miserably. I have set Everyone to have all permissions to the
folder that contains the database so there shouldn't be any permission
problems. I remember in regular ASP one had to set the mode to 3, but
that parameter has been dropped in ASP.NET. How do I make changes to
this database?


Evan

 

[Guest]

I'm having trouble using OdbcConnection and OdbcCommand to make
updates to a System database. I can open the database in Access and
make changes, but executing a simple:

INSERT INTO LoginInfo DEFAULT VALUES

fails miserably. I have set Everyone to have all permissions to the
folder that contains the database so there shouldn't be any permission
problems. I remember in regular ASP one had to set the mode to 3, but
that parameter has been dropped in ASP.NET. How do I make changes to
this database?

Hi Evan

did you try to execute that sql in Access? I think Access doesn't
support "default values" clause

 

[=?ISO-8859-1?Q?G=F6ran_Andersson?=]

I'm having trouble using OdbcConnection and OdbcCommand to make
updates to a System database. I can open the database in Access and
make changes, but executing a simple:

INSERT INTO LoginInfo DEFAULT VALUES

fails miserably. I have set Everyone to have all permissions to the
folder that contains the database so there shouldn't be any permission
problems. I remember in regular ASP one had to set the mode to 3, but
that parameter has been dropped in ASP.NET. How do I make changes to
this database?

Have you checked that the mdb file is not write protected?