Gary Kjos
garykjos at gmail.com
Sat Feb 4 14:18:07 CST 2012
Ya done confused it John. ;-) Name, date, time, format - those things are all bad ideas to use for names on anything aren't they? Glad you figured it out. GK On Sat, Feb 4, 2012 at 1:58 PM, jwcolby <jwcolby at colbyconsulting.com> wrote: >>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? >>>> >>> > > -- > AccessD mailing list > AccessD at databaseadvisors.com > http://databaseadvisors.com/mailman/listinfo/accessd > Website: http://www.databaseadvisors.com -- Gary Kjos garykjos at gmail.com