Francisco H Tapia
my.lists at verizon.net
Wed Mar 3 04:23:36 CST 2004
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