[AccessD] Access and SQL Server

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




More information about the AccessD mailing list