VS ASP.NET access rights problem

[eric_knapper]

Hi

I have a problem trying to modify an access database while running via debug from visual studio (asp.net webform). I can read from the access db ok but insert/update and deletes do not work it just complains about the SQL used however the SQL is ok if i execute it directly within access itself.

I'm wondering if this is a modify access rights problem if so how do you grant the correct rights when it's running off a temporary web in the localhost?

Thanks
Eric.

 

[eric_knapper]

I tried to insert into a new dummy test table and it works fine maybe the table name or one of the column names I was using in the original table is a reserved word or something. I was using a table name of 'Usr' which had three columns of Idx (autonumber primary key), User and Pass.

Anyway I've modified the original table to use different names and it's running.

Eric.