Odd - Access 2007 Showing Tab Characters in Passthrough Query SQL

[kjv1611]

There's a database originally created in a version of Access prior to 2007, I'm guessing 2000 or 2003, maybe. I edited a passthrough query using Access 2010 (have done this in the past several times with other databases) and now the user running Access 2007 is showing the tab characters in the passthrough query, where I do not see them in Access 2010.

I don't know whether or not this is causing the current other issues, or whether it just seems odd, but if it's a setting in Access, I imagine it can be enabled/disabled. I can't trouble-shoot it very well, b/c I am waiting on permissions to one of the SQL databases in the passthrough query before I can actually test it at my desk.

Thanks for any references or suggestions.

 

[genomon]

whether or not this is causing the current other issues

What issues? Are the tab chars somehow causing code to fail?

Gluais faicilleach le cupan làn

 

[smedvid]

I have a similar issue when I place T-SQL Code in a database table, but my code still works. My solution was to remove all the hard carriage returns... and have the T-SQL appear as a single line of text... htwh,

Steve Medvid
IT Consultant & Web Master

 

[kjv1611]

I don't think it's causing the code to fail, though I've not been able to look at it for a while.

I guess it's just a differences quirk between '07 and '10.

 

[genomon]

We have a bunch of tab chars in SQL Server tables that cause no problems; seems they got there through ASP data entry forms.

Gluais faicilleach le cupan làn

 

[kjv1611]

Just an update since never really "closed" it I suppose. This appears to just be a quirk diff with some queries between '10 and '07 or perhaps between '10 and previous versions. It didn't cause any actual issues itself.