Charlotte Foust
cfoust at infostatsystems.com
Wed Mar 3 10:30:57 CST 2004
I didn't think forms bound to an ADO recordset were updateable in 2000 period, MDB or ADP. Am I misremembering? Charlotte Foust -----Original Message----- From: Francisco H Tapia [mailto:my.lists at verizon.net] Sent: Wednesday, March 03, 2004 2:24 AM To: AccessD Subject: [AccessD] Continous form based off a recordset bottom line (SqlServer2000 + Access 2000 ADP) have a recordset in an ADP.. the data is from SqlServer and i've been looking at the code all day (march 2) till now Mar3rd at 2am.... it's a sproc that joins across a udf and some subqueries... bottom line Access doesn't see this as an updatable recordset... so I created a 2nd sproc that takes these parameters and dumps it to a #tempTable however this sproc is still NOT updatable :( wtf! ... so.. I dimmed my variable RS as an adorecordset but still I get issues because even if I create a disconnected RS, it cannot be bound to the form unless I push the activeconnection property to it which then gives me other issues well it's 230am (practically) and i'm probably gonna crash now due to exhaustion but if anyone can make sense and wants to drop me a line, thanks I appreciate it... :D -- -Francisco -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com