[AccessD] Access and SQL Server

David McAfee davidmcafee at gmail.com
Thu Mar 3 15:06:46 CST 2011


What is the exact problem?

I am not experiencing any problems with any of our ADPs using A2010 on
W7SP1.

I use a lot of ADO calls on my unbound forms.

D



On Thu, Mar 3, 2011 at 11:00 AM, Doug Murphy <dw-murphy at cox.net> wrote:

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