Doug Murphy
dw-murphy at cox.net
Thu Mar 3 13:00:20 CST 2011
Stuart, I missed that. What was the day of the message? Are you saying that an app will break if it uses ADO and is moved to a Win7 SP1 machine? Doug -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Stuart McLachlan Sent: Wednesday, March 02, 2011 12:53 PM To: Tony Septav; Access Developers discussion and problem solving Subject: Re: [AccessD] Access and SQL Server Did you see my posting about MS breaking ADO backward compatibility with Win7 SP1? :-) If you want tabs and sub-forms without binding your data , you have a lot of extra work to do :-( On 2 Mar 2011 at 5:40, Tony Septav wrote: > Hey All > I have got unbound forms, combo/list boxes, pass-through queries and > ADO connections all working. One question is why would you link to SQL > Server tables in Access when you can do everything with ptq and ADO in > Access? Another question is how do you handle subforms and tabs, do > you just simply link to SQL Server tables? From my research they say > to keep the data simplified on a main form and then allow the user > to pick a record and then display a more detailed form. The thing is > I like subforms and tabs, and use them where appropriate. Do I have > to do some rethinking here? -- AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd Website: > http://www.databaseadvisors.com > -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com