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]

Gox wrote:

3012. Object <name> already exists.

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

Any suggest? Jet problem maybe?

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]

Tim Marshall wrote:

1) what code is being run with any part of this report?
Tim thanks for reply.

I call report from form and I use only this:

stWhere = ""
stDocName = "My_report"
DoCmd.OpenReport stDocName, acPreview, , stWhere

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

This is a potential problem because I create dynamic query regarding
parameters on form.
First of all, I run my function queryIsExist(MyQueryName) /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