I have an Access 2007 database that is linked to tables stored in an
Interbase/Firebird (version 1.5) database. Any fields with zero
length strings in them are displayed as garbage (eg: "Â緪ꔒ䃣4 "). I do
not think the problem is with the ODBC driver, because other
applications that use the same driver do not show these problems.

Unfortunately, I cannot change the data in the linked table, because
it is generated by a third party application, and may cause problems
if I change any of the data stored in the linked table. Does anyone
have any ideas to how I can correct this problem, as it is getting
quite serious now.

cheers
Olly

What happens when you put in the criteria of ="" in a query?

How about Len([TheFieldName]) in the field of a query?
--
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


"Olly" wrote:

> I have an Access 2007 database that is linked to tables stored in an
> Interbase/Firebird (version 1.5) database. Any fields with zero
> length strings in them are displayed as garbage (eg: "Â緪ꔒ䃣4 "). I do
> not think the problem is with the ODBC driver, because other
> applications that use the same driver do not show these problems.
>
> Unfortunately, I cannot change the data in the linked table, because
> it is generated by a third party application, and may cause problems
> if I change any of the data stored in the linked table. Does anyone
> have any ideas to how I can correct this problem, as it is getting
> quite serious now.
>
> cheers
> Olly
> .
>

Jerry

Searching by ="" returns 12 results, way less than the fields with
garbage in them.
Searching by len returns an integer grater than zero, but not
necessarily the same length of the string displayed. It is either
equal to or grater than the length of the string displayed.

cheers
Olly

On Mar 1, 7:55Â*pm, Jerry Whittle
<JerryWhit...@discussions.microsoft.com> wrote:
> What happens when you put in the criteria of ="" in a query?
>
> How about Len([TheFieldName]) in the field of a query?
> --
> Jerry Whittle, Microsoft Access MVP
> Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
>
>
> "Olly" wrote:
> > I have an Access 2007 database that is linked to tables stored in an
> > Interbase/Firebird (version 1.5) database. Â*Any fields with zero
> > length strings in them are displayed as garbage (eg: "Â緪ꔒ䃣4 "). Â*I do
> > not think the problem is with the ODBC driver, because other
> > applications that use the same driver do not show these problems.
>
> > Unfortunately, I cannot change the data in the linked table, because
> > it is generated by a third party application, and may cause problems
> > if I change any of the data stored in the linked table. Â*Does anyone
> > have any ideas to how I can correct this problem, as it is getting
> > quite serious now.
>
> > cheers
> > Olly

Bump, any chance of getting a response?

cheers
Olly

On Mar 2, 11:42Â*am, Olly <news201...@olly86.co.uk> wrote:
> Jerry
>
> Searching by ="" returns 12 results, way less than the fields with
> garbage in them.
> Searching by len returns an integer grater than zero, but not
> necessarily the same length of the string displayed. Â*It is either
> equal to or grater than the length of the string displayed.
>
> cheers
> Olly
>
> On Mar 1, 7:55Â*pm, Jerry Whittle
>
>
>
> <JerryWhit...@discussions.microsoft.com> wrote:
> > What happens when you put in the criteria of ="" in a query?
>
> > How about Len([TheFieldName]) in the field of a query?
> > --
> > Jerry Whittle, Microsoft Access MVP
> > Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
>
> > "Olly" wrote:
> > > I have an Access 2007 database that is linked to tables stored in an
> > > Interbase/Firebird (version 1.5) database. Â*Any fields with zero
> > > length strings in them are displayed as garbage (eg: "Â緪ꔒ䃣4 "). Â*I do
> > > not think the problem is with the ODBC driver, because other
> > > applications that use the same driver do not show these problems.
>
> > > Unfortunately, I cannot change the data in the linked table, because
> > > it is generated by a third party application, and may cause problems
> > > if I change any of the data stored in the linked table. Â*Does anyone
> > > have any ideas to how I can correct this problem, as it is getting
> > > quite serious now.
>
> > > cheers
> > > Olly

On Fri, 5 Mar 2010 03:11:37 -0800 (PST), Olly <news2010-(E-Mail Removed)> wrote:

>Bump, any chance of getting a response?
It sounds to me like the ODBC driver for Interbase is defective. Have you
reported this symptom to whoever developed the driver?

I don't know what I - or any of the other volunteers here - can do, since I
don't have Interbase (or a whole lot of spare time, for that matter).
--

John W. Vinson [MVP]

Thanks for your reply. But there is no issue with the ODBC driver,
because other applications use the same driver without seeing the
unexpected data. Which to me indicates a problem with Access itself.

cheers
Olly

On Mar 5, 5:20*pm, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
wrote:
> On Fri, 5 Mar 2010 03:11:37 -0800 (PST), Olly <news201...@olly86.co.uk> wrote:
> >Bump, any chance of getting a response?
>
> It sounds to me like the ODBC driver for Interbase is defective. Have you
> reported this symptom to whoever developed the driver?
>
> I don't know what I - or any of the other volunteers here - can do, sinceI
> don't have Interbase (or a whole lot of spare time, for that matter).
> --
>
> * * * * * * *John W. Vinson [MVP]

On Mar 8, 6:26*am, Olly <news201...@olly86.co.uk> wrote:
> Thanks for your reply. *But there is no issue with the ODBC driver,
> because other applications use the same driver without seeing the
> unexpected data. *Which to me indicates a problem with Access itself.
>
> cheers
> Olly
>
> On Mar 5, 5:20*pm, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
> wrote:
>
> > On Fri, 5 Mar 2010 03:11:37 -0800 (PST), Olly <news201...@olly86.co.uk>wrote:
> > >Bump, any chance of getting a response?
>
> > It sounds to me like the ODBC driver for Interbase is defective. Have you
> > reported this symptom to whoever developed the driver?
>
> > I don't know what I - or any of the other volunteers here - can do, since I
> > don't have Interbase (or a whole lot of spare time, for that matter).
> > --
>
> > * * * * * * *John W. Vinson [MVP]

Maybe a workaround can filter out the garbage. Try something like:

IIf(Len(IIf(FieldName IS NULL, "", FieldName) = 0, "",
IIf(Asc(Left(FieldName, 1)) < 32 Or Asc(Left(FieldName, 1)) > 127, "",
FieldName))

James A. Fortune
(E-Mail Removed)

On Mar 8, 2:23*pm, "James A. Fortune" <MPAPos...@FortuneJames.com>
wrote:
> On Mar 8, 6:26*am, Olly <news201...@olly86.co.uk> wrote:
>
>
>
> > Thanks for your reply. *But there is no issue with the ODBC driver,
> > because other applications use the same driver without seeing the
> > unexpected data. *Which to me indicates a problem with Access itself.
>
> > cheers
> > Olly
>
> > On Mar 5, 5:20*pm, John W. Vinson <jvinson@STOP_SPAM.WysardOfInfo.com>
> > wrote:
>
> > > On Fri, 5 Mar 2010 03:11:37 -0800 (PST), Olly <news201...@olly86.co.uk> wrote:
> > > >Bump, any chance of getting a response?
>
> > > It sounds to me like the ODBC driver for Interbase is defective. Haveyou
> > > reported this symptom to whoever developed the driver?
>
> > > I don't know what I - or any of the other volunteers here - can do, since I
> > > don't have Interbase (or a whole lot of spare time, for that matter).
> > > --
>
> > > * * * * * * *John W. Vinson [MVP]
>
> Maybe a workaround can filter out the garbage. *Try something like:
>
> IIf(Len(IIf(FieldName IS NULL, "", FieldName) = 0, "",

Try something more like something with a right parenthesis before the
'=' sign :-). Other parentheses might be needed or omitted.

James A. Fortune
(E-Mail Removed)

"Olly" <news2010-(E-Mail Removed)> wrote in message
news:46d094ea-e2e5-4104-aa64-(E-Mail Removed)...
I have an Access 2007 database that is linked to tables stored in an
Interbase/Firebird (version 1.5) database. Any fields with zero
length strings in them are displayed as garbage (eg: "Â緪ꔒ䃣4 "). I do
not think the problem is with the ODBC driver, because other
applications that use the same driver do not show these problems.

Unfortunately, I cannot change the data in the linked table, because
it is generated by a third party application, and may cause problems
if I change any of the data stored in the linked table. Does anyone
have any ideas to how I can correct this problem, as it is getting
quite serious now.

cheers
Olly

km)====


ùklippjbçÃ*"Olly" <news2010-(E-Mail Removed)> a écrit dans le message de groupe
de discussion :
46d094ea-e2e5-4104-aa64-46f825530a46...oglegroups.com...
> I have an Access 2007 database that is linked to tables stored in an
> Interbase/Firebird (version 1.5) database. Any fields with zero
> length strings in them are displayed as garbage (eg: "Â緪ꔒ䃣4 "). I do
> not think the problem is with the ODBC driver, because other
> applications that use the same driver do not show these problems.
>
> Unfortunately, I cannot change the data in the linked table, because
> it is generated by a third party application, and may cause problems
> if I change any of the data stored in the linked table. Does anyone
> have any ideas to how I can correct this problem, as it is getting
> quite serious now.
>
> cheers
> Olly