97 to 2003 difference in naming?

[Guest]

I am working in an environment where some people have 97 front ends, some
2003 front ends, all of which look at a 97 back end. In general it's working
fine.

I just created a report, saved it to a new database, converted that database
back to 97 and saved the report to the 97 front end.

The report works fine in 2003.

In 97 I can't even open it because of "Invalid bracketing of name
'[tblContrDet.AwdAmt]'"

When I click help on this error message, it is identified as error 3126.

I have tried every kind of bracketing change I can imagine, as well as
rebuilding the expressions containing this name with the build wizard.

Any ideas? Thanks

 

[Brendan Reynolds]

Should be [tblContrDet].[AwdAmt]

Some of the wizards and builders don't always get that right.

 

[Van T. Dinh]

Do you actually have Table named "tblContrDet.AwdAmt"? (note the period in
the middle.)

The conversion to A97 format is not 100% and may get the bracketing
incorrectly. I guess you need [tblContrDet].[AwdAmt] instead.

 

[Guest]

Thanks to both of you for your responses. I did finally manage to get it
fixed. Part of my problem was that the underlying query had come through
with glitched bracketing, and I was fixing the problem in the report only.
And when the fixes I tried (I tried the correct one first) didn't work, I was
getting increasingly fancy in terms of how I was describing this field, in
desperation.

Anyhow, Thanks.

Do you actually have Table named "tblContrDet.AwdAmt"? (note the period in
the middle.)

The conversion to A97 format is not 100% and may get the bracketing
incorrectly. I guess you need [tblContrDet].[AwdAmt] instead.

--
HTH
Van T. Dinh
MVP (Access)

I am working in an environment where some people have 97 front ends, some
2003 front ends, all of which look at a 97 back end. In general it's working
fine.

I just created a report, saved it to a new database, converted that database
back to 97 and saved the report to the 97 front end.

The report works fine in 2003.

In 97 I can't even open it because of "Invalid bracketing of name
'[tblContrDet.AwdAmt]'"

When I click help on this error message, it is identified as error 3126.

I have tried every kind of bracketing change I can imagine, as well as
rebuilding the expressions containing this name with the build wizard.

Any ideas? Thanks