[AccessD] Table vs View Recordsource

[Anita Smith]

John,

I vividly remember fighting the PK wars back then, but I can hardly remember what I watched on TV last night. Scary indeed!

I'm still plugging away at a couple of major projects but I'm desperately wanting to retire. Mind you, Australia has been locked down since March last year so I have nowhere to go. Can't even cross the border to the next state.

Glad to see you are still knocking about on AccessD.

Anita 



Anita Smith 
M: 0402 022 462

-----Original Message-----
From: AccessD <accessd-bounces+anita=ddisolutions.com.au at databaseadvisors.com> On Behalf Of John Colby
Sent: Sunday, 27 June 2021 09:04
To: Access Developers discussion and problem solving <accessd at databaseadvisors.com>
Subject: Re: [AccessD] Table vs View Recordsource

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