[AccessD] Continous form based off a recordset

maybe your mis-remembering right :D

according to the doc's any ado (for adp) which derives from sqlserver is 
updatable in forms, and in an mdb, if it derives from access it is 
updatable, otherwise not...


to side step the problem I dumped into an mdb w/ passthrough queries... 
now the question in mind is... How would you or someone:


Launch the form in a 2nd MDB that is NOT linked?.. or does it need to 
become linked? (refrences)

A sticking point is that the final adp is converted to an ADE, so I'd 
have to convert the MDB to MDE, which just bites.. :(  anyone have code 
to automate that part ;o)



Charlotte Foust wrote:

>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