[AccessD] Continous form based off a recordset

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





More information about the AccessD mailing list