Reserved error (-3007); there is no message for this error.

M

Mark Burns

I get the above error message when opening a report (preview)

The query uses a parameterized crosstab query (between {Enter Date1:] amd
[Enter Date2:]) outer joined to another parameterized query (same parameters
and useage).

The crosstab query's fields are used in the outermost group summary band of
the report bound to text boxes (the field names are consistent as they are
table-derived form a pull-down combobox)

Any help/advice (other than "Don't do that if it hurts")?

PS. the query runs absolutely perfectly on its own.
Access XP w/ SP-2

- Mark
 
M

Mark Burns

PPS. Changing the query to eliminate the outer join (converting to an inner
join) had no effect on the error.

Mark Burns said:
PS. The error appears after Access prompts for the parameter values.

Mark Burns said:
I get the above error message when opening a report (preview)

The query uses a parameterized crosstab query (between {Enter Date1:] amd
[Enter Date2:]) outer joined to another parameterized query (same parameters
and useage).

The crosstab query's fields are used in the outermost group summary band of
the report bound to text boxes (the field names are consistent as they are
table-derived form a pull-down combobox)

Any help/advice (other than "Don't do that if it hurts")?

PS. the query runs absolutely perfectly on its own.
Access XP w/ SP-2

- Mark
Click to expand...
Click to expand...
 
Y

Yuan Shao

Hi Mark,

Thanks for your post. According to your description, I understand when you
open a report using crosstab query with parameters, you encountered the
following query:
"Reserved error (-3007); there is no message for this error."

What is the version of Access on your side? Please apply the latest version
of Service pack firstly for your version of Jet engine. For Access 97, the
version of Jet engine is 3.5, for Access 2000 or later, the Jet engine is
4.0.

Does it fix your problem? If not, I would like to know what the SQL
statements of the crosstab query are. It is appreciated that you can
provide a sample query showing this problem in the northwind.mdb sample
database so that I can fully understand what your concern is.

Thank for posting in community.

Sincerely,

Michael Shao
Microsoft Online Partner Support
Get Secure! - www.microsoft.com/security
This posting is provided "as is" with no warranties and confers no rights.
 
M

Mark Burns

Replies inline:

"Yuan Shao" said:
Hi Mark,

Thanks for your post. According to your description, I understand when you
open a report using crosstab query with parameters, you encountered the
following query:
"Reserved error (-3007); there is no message for this error."

What is the version of Access on your side?
Click to expand...

Access 2002 (ver. 10.4302.4219) SP-2
Please apply the latest version
of Service pack firstly for your version of Jet engine. For Access 97, the
version of Jet engine is 3.5, for Access 2000 or later, the Jet engine is
4.0.
Click to expand...

Referencing: DAO360.DLL Ver.:03.60.2521.8 (3/15/1999 12:00AM)

Loaded: MSJet40.DLL Ver.:4.00.7328.0 (9/8/2003 9:56PM)
Does it fix your problem? If not, I would like to know what the SQL
statements of the crosstab query are. It is appreciated that you can
provide a sample query showing this problem in the northwind.mdb sample
database so that I can fully understand what your concern is.
Click to expand...

I may not be able to duplicate in it Northwind because I'm not that familiar
with that sample DB.
If you want, I may be able to mock up a version of our db that illustrates
the problem though.
(It'll have to be treated confidentially, of course, so please eMail me
privately if you want me to do that.)
Thank for posting in community.
Click to expand...

Thanks for being here to answer!
 
Top