[AccessD] Table vs View Recordsource

[Anita Smith]

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