[AccessD] A2K: Error 3251

If you are opening dbOpenSnapshot, you are creating a temporary 
recordset that is a "Snapshot" of the table at a given point  in time 
- it is not the table itself, so you can't update records in it.  

Open it as the default (dbDynaset)

On 21 Jan 2004 at 16:17, Darren DICK wrote:

> Hi All
> This should be simple
> 
> I have some code updating a table of records
> 
>     Dim selSQL As String
>     Dim rs     As Recordset
>  
>     selSQL = "SELECT tblMyTable.* FROM tblMyTable;"
> 
>     Set rs = db.OpenRecordset(selSQL, dbOpenSnapshot)
> 
>          With rs
>              .Edit  <===Code Fails Here
>              !MyField = Me.txtMyControl
>              .Update
>          End With
> 
> The rror I get is...
> Error 3251: Operation is not supported for this type of Object
> 
> Any suggestions??
> 
> Many thanks
> 
> DArren
> 
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

 
-- 
Lexacorp Ltd
http://www.lexacorp.com.pg
Information Technology Consultancy, Software Development,System Support.