[AccessD] Fascinating (but schtupid)

 >It worked just fine for a while, then suddenly didn't work.

Likewise, it was working fine for awhile then suddenly started the uesrname / password thing.

John W. Colby
Colby Consulting

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

On 2/4/2012 2:45 PM, Tina Norris Fields wrote:
> Aha! Yes, I did that very same thing a few years ago. It worked just fine for a while, then suddenly
> didn't work. "Name" is indeed a reserved word - changed it to "FullName" and had no more problems.
> T
>
> Tina Norris Fields
> tinanfields at torchlake.com
> 231-322-2787
>
>
> On 2/4/2012 2:18 PM, jwcolby wrote:
>> 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?
>>>
>>