Connecting Tech Pros Worldwide Forums | Help | Site Map

Data migration problem: Report sticks to old table name

Florifulgurator
Guest
 
Posts: n/a
#1: Nov 13 '05
Hello,

trying to clean up other´s mess...

I´ve replaced some tables (previously linked to another Access DB)
with renamed tables linked to a PostgeSQL DB (removed spaces and
Ümlauts in names, secured referential integrity).

There´s one (probably more) report that doesn´t get the new name:

The report is opened via a 1-line macro when clicking a button in a
form. I replaced the table name in every report/form element, any VB
code, and any query.
Yet, when pressing the button, the report asks for a parameter value in
that old table.
Ignoring that by pressing OK, I mostly get a report with lots of #Error
messages. Sometimes (mere chance?) I get the correct report.


despairingly,
Martin


Tom van Stiphout
Guest
 
Posts: n/a
#2: Nov 13 '05

re: Data migration problem: Report sticks to old table name


On 27 May 2005 05:40:38 -0700, "Florifulgurator"
<martin.gisser@argovision.de> wrote:

It's easy to forget about the grouping levels. Design the report and
select View / Sorting and Grouping.

-Tom.

[color=blue]
>Hello,
>
>trying to clean up other´s mess...
>
>I´ve replaced some tables (previously linked to another Access DB)
>with renamed tables linked to a PostgeSQL DB (removed spaces and
>Ümlauts in names, secured referential integrity).
>
>There´s one (probably more) report that doesn´t get the new name:
>
>The report is opened via a 1-line macro when clicking a button in a
>form. I replaced the table name in every report/form element, any VB
>code, and any query.
>Yet, when pressing the button, the report asks for a parameter value in
>that old table.
>Ignoring that by pressing OK, I mostly get a report with lots of #Error
>messages. Sometimes (mere chance?) I get the correct report.
>
>
>despairingly,
>Martin[/color]

Florifulgurator
Guest
 
Posts: n/a
#3: Nov 13 '05

re: Data migration problem: Report sticks to old table name


Thanks!

Closed Thread