2. ASPRunnerPro General questions
  3. [SOLVED]  Current Recordset does not support updating. This may be a limitation
This topic is locked
[SOLVED]

 Current Recordset does not support updating. This may be a limitation

9/28/2010 4:47:30 AM
ASPRunnerPro General questions
K
 kcloy23x author

Hi There,
I have this error when trying to save a record, please help!!!
<<< Record was NOT added >>>
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
I have extracted out the txt of dbconnection.asp
<%

strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("db\RegistrationSDL.accdb") & ";Jet OLEDB:Database Password=;Password=;User ID="

%>
Sergey Kornilov admin 9/28/2010

You may want to ask your web hosting company what connection string for MS Access they recommend to use.
Another thing - make sure IIS user has write write permissions on database directory.
C
 		clig 9/28/2010



Hi There,
I have this error when trying to save a record, please help!!!
<<< Record was NOT added >>>
Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype.
I have extracted out the txt of dbconnection.asp
<%

strConnection = "Provider=Microsoft.ACE.OLEDB.12.0;Data Source=" & Server.MapPath("db\RegistrationSDL.accdb") & ";Jet OLEDB:Database Password=;Password=;User ID="

%>


and not a complex view with joins that may not be updatable through the provider...