By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
446,400 Members | 953 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 446,400 IT Pros & Developers. It's quick & easy.

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

P: n/a
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.

Nov 13 '05 #1
Share this Question
Share on Google+
6 Replies


P: n/a
Try to decompile the database (command-line switch /decompile)

dkintheuk wrote:
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.


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

Nov 13 '05 #2

P: n/a
Er... gonna sound dumb now but how do I do that?

Thanks.

Nov 13 '05 #3

P: n/a
Ok... found out how... easy really.

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

Argh!

Still could use some help here...

Nov 13 '05 #4

P: n/a
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!

Nov 13 '05 #5

P: n/a
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:
Er... gonna sound dumb now but how do I do that?

Thanks.


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

Nov 13 '05 #6

P: n/a
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>

Nov 13 '05 #7

This discussion thread is closed

Replies have been disabled for this discussion.