[AccessD] A2K: Error 3251

Change snapshot to dbOpenDynaset

-----Original Message-----
From: accessd-bounces at databaseadvisors.com
[mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Darren DICK
Sent: Wednesday, January 21, 2004 12:18 AM
To: AccessD List
Subject: [AccessD] A2K: Error 3251


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