Dreaded "Must Use Updateable Query"

  • Thread starter Thread starter ewpatton
  • Start date Start date
E

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
 
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?
Click to expand...

Hi Evan

did you try to execute that sql in Access? I think Access doesn't
support "default values" clause
 
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?
Click to expand...

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