Error Number 3000: Reserved Error (-3002); there is no message for this error

Help...

I've been moving code about to tidy it up and this error is occuring.

I have tracked it down to a set querydef command, i have properly
specified a database and am using correct syntax for the set command
but this error is popping up.

Any ideas why?

Please help.......

Rob.

re: Error Number 3000: Reserved Error (-3002); there is no message for this error

Try to decompile the database (command-line switch /decompile)

dkintheuk wrote:
[color=blue]
> Help...
>
> I've been moving code about to tidy it up and this error is occuring.
>
> I have tracked it down to a set querydef command, i have properly
> specified a database and am using correct syntax for the set command
> but this error is popping up.
>
> Any ideas why?
>
> Please help.......
>
> Rob.
>[/color]

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html

re: Error Number 3000: Reserved Error (-3002); there is no message for this error

Er... gonna sound dumb now but how do I do that?

Thanks.

re: Error Number 3000: Reserved Error (-3002); there is no message for this error

Ok... found out how... easy really.

Unfortunately, there is no change in the behaviour of the code.

Argh!

Still could use some help here...

re: Error Number 3000: Reserved Error (-3002); there is no message for this error

I've now decomplied...
Then i exported all code...
Then i compacted and repaired the db
Then i reimported all the code
Then i compacted and repaired again

It still doesn't want to work!

re: Error Number 3000: Reserved Error (-3002); there is no message for this error

you either have to type it in manually, using the command prompt, or
pass the option via a desktop shortcut.

Personally, I add an action Decompile to the context menu in Explorer.
Find the options (I don't have an english version of Explorer here)
choose file types
navigate to Microsoft Access Database
klick Edit
edit the Open action, copying the path expression
add an action clicking New...
name it Decompile
paste the path expression;
make it end in
MSACCESS.EXE" /decompile "%1"
OK, close, close, OK, Apply, OK, OK, OK, close --- well you get the idea

Now you can rightclick any access database and choose Decompile

dkintheuk wrote:[color=blue]
> Er... gonna sound dumb now but how do I do that?
>
> Thanks.
>[/color]

--
Bas Cost Budde, Holland
http://www.heuveltop.nl/BasCB/msac_index.html

re: Error Number 3000: Reserved Error (-3002); there is no message for this error

Ok... here it is - i was being thick (no surprise there).

I had a problem in my SQL in that the SQL was designed to do a
TRANSFORM to create a nice crosstab query.

I later added an INTO command to the SQL to get the output into a temp
table.

This is not allowed for TRANSFORM queries. Just need to work in two
stages and take the output from the first query into a SELECT * FROM
query...

Simple really... <grumble>