Another MS Access

[zzfive03]

Ok this is very frustrating..

I have my ASP page connecting to the MS Access DB, and I can do my select statments, but it wont let me update, delete or insert. Are there securitys on the Access database or something I am not doing rigth in my RS object? Here is the way I am doing it:

'DB Connect
Set DB = Server.CreateObject("adodb.connection&quot
DSNString = "PROVIDER=Microsoft.Jet.OLEDB.4.0;" & "Data Source=" & server.mappath("database/myDatabase.mdb&quot
DB.Open DSNString

SQL = "..whatever..."
Set RS = Server.CreateObject("adodb.recordset&quot
RS.Open SQL, DB

Any help would be great.

 

[codestorm]

And the error is ?

Also, action statements (e.g. update, insert, delete, create table) don't return recordsets, so trying to return them into recordsets just wastes resources. codestorm
Fire bad. Tree pretty. - Buffy
select * from population where talent > 'average'
<insert witticism here>

 

[Jonax]

Does the IUSR_MachineName-windows-account have write permit on the containing folder? This is not a bug - it's an undocumented feature...
;-)

 

[Jonax]

For the same reason you might want to have your db in a folder outside of the

http://wwwroot,

and only allow read/write and NOT exe... This is not a bug - it's an undocumented feature...
;-)

 

[zzfive03]

I found it, it was the folder security for the folder that held the on the file the .mdb