[AccessD] Fascinating (but schtupid)

It seems the issue behind the problem is that I used "Name" as the field alias back in the view in 
SQL Server.  Name is almost certainly a reserved word in Access.  When I changed the alias to 
something else the problem went away.

John W. Colby
Colby Consulting

Reality is what refuses to go away
when you do not believe in it

On 2/4/2012 1:14 PM, jwcolby wrote:
> I am working on an Access database which uses ODBC links back to tables as well as views. Everything
> was working fine until I created a view which appends a FirstName + ' ' + LastName to create a name
> field, for use in a combo. I have a couple of dozen views which I link into the FE but this is the
> only one so far where I do this append kind of thing. I use these views to sort the data out at the
> sql server end and populate my drop down combos in various forms.
>
> When I bind the combo to this view and open the form, a SQL server login form opens several times.
> You know the one I mean, the login form which asks whether to use trusted connection or a SQL Server
> username / password. The view itself is fine, I can click on the view and see the data, no login
> form etc.
>
> If I bind the row source to the corresponding table and do the append thing inside of Access I also
> do not get the login form popping up.
>
> So, bind to a view without this field append happening back in SQL Server, no problem.
> Bind to a table and do the field append in the FE itself, no problem.
> Open the view with the field append happening in SQL Server, no problem.
> Bind to a view with this append happening back in sql server, log in box pops up, several times.
>
> Check this out, if I relink just that view, the error goes away... until I close the database and
> re-open it and then the error is back. Relink the view, gone, close re-open and it's back.
>
> Of course it took me awhile to figure this out.
>
> Doncha just love Access?
>