Change reports properties using msysobjects

[Costinu]

Hello,

I have a problem and I don't know how to handle it.

I want to read and change reports recordsource using msysobjects
table, but I can update this table and I don't know what to update.

It seems I know nothing

Please help me!!

Costin Calnuschi

 

[Duane Hookom]

You can only change the SQL of the saved query a report is based on or open
the report and change the Row Source property.

 

[Costinu]

I want to change the report RecordSource only when is a SQL statement.
I want to create a query in database (this I know how to do it) with
the SQL statement of report and to change the RecordSource with the
name of the query.
The problem is that I have to do this using DAO. If I use Access
object is very simple. I search for 4 days and I think the solution is
to update system tables, but I don't have the permision to do this and
I don't know realy where I need to update.

Thank you.
Costin Calnuschi

 

[Duane Hookom]

You can't (and shouldn't) change system tables. I suggested two methods.