Report error

[Gox]

Hi all!

My MS Access application (create version: 2k Access) running on PC with
2003 Office.
I work with oracle ODBC driver.
Everything is fine except one report (other report run well). This
report brings back error:

3012. Object <name> already exists.

All reports is created by same way and use same mechanism.

Any suggest? Jet problem maybe?

Thanks!

[Tim Marshall]

Re: Report error

Gox wrote:
[color=blue]
> 3012. Object <name> already exists.
>
> All reports is created by same way and use same mechanism.
>
> Any suggest? Jet problem maybe?[/color]

You haven't given us enough information.

You need to look at and consider the following to narrow down your area
of concern:

1) what code is being run with any part of this report?

2) what query/SQL is associated with the report?

We have no idea what any of this could be.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me

[Gox]

Re: Report error

Tim Marshall wrote:[color=blue]
> 1) what code is being run with any part of this report?[/color]

Tim thanks for reply.

I call report from form and I use only this:

stWhere = ""
stDocName = "My_report"
DoCmd.OpenRepor t stDocName, acPreview, , stWhere

[color=blue]
> 2) what query/SQL is associated with the report?[/color]

This is a potential problem because I create dynamic query regarding
parameters on form.
First of all, I run my function queryIsExist(My QueryName) /true-false.
If exist delete query and after that create new query with same name.
If not exist don't delete, only create new query with same name.

This is a main part of function:

For Each dcm In dcms
If dcm.Name = MyQueryName Then
queryIsExist = True
Exit Function ' Quit function once form has been found.
End If
Next

This query is Record Source of report.

On my environment (WinXP-office 2k, and Win2k-office 2k) report run well.

I hope, I gave some more information.

Regards,
Gox