[AccessD] Access and SQL Server

Stuart McLachlan stuart at lexacorp.com.pg
Thu Mar 3 15:23:38 CST 2011


Running on Win7 SP1 is not a problem.

Compile an application on Win7 SP1 and it may not run on earlier OSs

-- 
Stuart

On 3 Mar 2011 at 13:06, David McAfee wrote:

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