[AccessD] Table vs View Recordsource

[Arthur Fuller]

The move to ADP was the most wonderful thing that ever happened to me, and
its death was most tragic. I have a theory: it was to good, so they had to
kill it to save sales of SQL server.

On Sat, Jun 26, 2021 at 7:04 PM John Colby <jwcolby at gmail.com> wrote:

> Anita, I am immensely gratified to hear that you too can not remember the
> events from last week.  You do realize that many of us were fighting the PK
> wars 25+ years ago on AccessD.  Scary really.
>
> On Thu, Jun 24, 2021 at 7:35 AM Anita Smith <anita at ddisolutions.com.au>
> wrote:
>
> > Hi Stuart,
> >
> > You are a star!!
> >
> > Your question catapulted my brain into action.
> >
> > When first setting up the ODBC Data source  I had a 3 different drivers
> to
> > choose from (which I had long forgotten as I did this way back last
> week).
> > Lo and behold, I must have chosen a dodgy one.
> >
> > I have now connected using one of the others and I am back in business.
> >
> > Anita
> >
> >
> >
> >
> > Anita Smith
> > M: 0402 022 462
> >
> > -----Original Message-----
> > From: AccessD <accessd-bounces+anita=
> > ddisolutions.com.au at databaseadvisors.com> On Behalf Of Stuart McLachlan
> > via AccessD
> > Sent: Thursday, 24 June 2021 19:43
> > To: Access Developers discussion and problem solving <
> > accessd at databaseadvisors.com>
> > Cc: Stuart McLachlan <stuart at lexacorp.com.pg>
> > Subject: Re: [AccessD] Table vs View Recordsource
> >
> > I assume the BE is SQL Server, please correct me if I'm wrong.
> > What version?
> > Specifically, what ODBC driver?
> > 32bit or 64bit Office and ODBC dirver?
> >
> > On 24 Jun 2021 at 7:58, Anita Smith wrote:
> >
> > > Due to the discontinuation of the humble ADP - I have found myself in
> > > the dire predicament of being tasked with converting some of my
> > > projects from ADP to ODBC.
> > >
> > > Much to my horror I can no longer use my stored procedures as record
> > > sources for my editable forms. I then thought I´d use views as I´m
> > > thinking they would work reasonably fast.
> > >
> > > Here comes my query:
> > > When I bind a form to a table my date fields work like a charm.
> > > However when I bind a form to a view, Access spits the dummy on my
> > > date fields saying it can´t convert nvarchar to smalldatetime bla bla.
> > > Is this normal behaviour?
> > >
> > > I have found myself wading around in date issues up to my eyeballs
> > > that I never had to give a second thought to in my ADP´s.
> > >
> > > Furthermore I have two smaller ODBC projects where this does not
> > > happen and for the life of me I can´t glean any difference between
> > > those that work with views and the current one I´m working on that
> > > doesn´t.  I´m definitely getting too old for this!
> > >
> > > Anyone out there why knows what gives?
> > >
> > > Anita from down under
> > >
> > > Anita Smith
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > https://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
>
>
> --
> John W. Colby
> Colby Consulting
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> https://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>


-- 
Arthur