473,326 Members | 2,196 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,326 software developers and data experts.

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.

Nov 13 '05 #1
6 12742
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
Er... gonna sound dumb now but how do I do that?

Thanks.

Nov 13 '05 #3
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
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

9
by: Mark Twombley | last post by:
Hi, I'm just getting back into C++ and had a question about the best practice for assigning error numbers. I have been working in VB for sometime now and there you would start assigning error...
1
by: dawatson833 | last post by:
I want to set an alert for a specific table whenever an event has caused a deadlock to occur on the table. I understand how to set up an alert. But I don't know which error number to use for...
4
by: amywolfie | last post by:
Hi All: In FileMaker Pro, the error number for "no records found" is 401. What is the equivalent error number in Access (2003)? I want to capture for the "On Open" Event of a report. If...
1
by: Karen | last post by:
I have been getting this error on some of the frontends when attempting to create new records. I haven't been able to find a list of errors to even begin my troubleshooting. Can someone help? ...
2
by: Dixie | last post by:
I have an Access Error "Permission Denied" which is generated when I try to delete a folder with a locked file inside. Can anyone tell me the error number for this error? dixie
9
by: blacksmoke | last post by:
I got an error... when i wants to create database "usersinfo" Username is 'blacksmoke'... Commandline argumments are: mysql> select user(); : e.g., blacksmoke@localhost -------
11
by: RP | last post by:
If an exception occurs, how to get the error number. I mean, is there anything like ex.number?
8
by: adampierce | last post by:
I am trying to run a pretty simple select query in Access 2007, and I keep getting the error message "Reserved error (-1524); there is no message for this error." There are no linked tables in the...
6
doma23
by: doma23 | last post by:
Error number: -214217887 Description: Das Feld ist zu klein fur die Datenmenge, die Sie hinzufungen wollten. Versuchen Sie, weniger Daten einzufugen. Hi, I've made a particular tool by using...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
1
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
1
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.