[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
>