Error on Access Query

[angela.y.austin]

I have tables linked to an archive. I have a query built with parameters that prompt the user for input.

I receive the following error after input (46972): "Reserved error (-2029); there is no message for this error."

When I run the query and equal the criteria to 46972, I can retrieve the rows.

Any suggestions?

 

[John W. Vinson]

I have tables linked to an archive. I have a query built with parameters that prompt the user for input.

I receive the following error after input (46972): "Reserved error (-2029); there is no message for this error."

When I run the query and equal the criteria to 46972, I can retrieve the rows.

Any suggestions?

Correct the error in the query.

If you would like help in doing so, please open it in SQL view and post the
SQL text to a message here so we can see it.

It would also help to indicate something about the nature of the archive: is
it an Access database, a text file, SQL/Server, cuneiform tablets...?

--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[angela.y.austin]

Hi John,

Thank you for the reply.

Here is the query when it works -- no prompts:

SELECT dbo_F0115.WPAN8 AS [Customer No], dbo_F0115.WPPHTP AS [Phone Type], dbo_F0115.WPAR1 AS Area, dbo_F0115.WPPH1 AS Phone
FROM dbo_F0115
WHERE (((dbo_F0115.WPAN8)="469762"));

Here is the query that does not work -- with prompts/criteria:

SELECT dbo_F0115.WPAN8 AS [Customer No], dbo_F0115.WPPHTP AS [Phone Type], dbo_F0115.WPAR1 AS Area, dbo_F0115.WPPH1 AS Phone
FROM dbo_F0115
WHERE (((dbo_F0115.WPAN8)=[Enter address]));

Angie

 

[angela.y.austin]

I'm connecting to Optim archived tables. I know the ODBC is working correctly because I can pull data when my where clause states a specific text. Only an issue when I try to create a prompt for the users to enter parameters.

 

[angela.y.austin]

Hi John,

Thank you for the reply.

Here is the query when it works -- no prompts:

SELECT dbo_F0115.WPAN8 AS [Customer No], dbo_F0115.WPPHTP AS [Phone Type], dbo_F0115.WPAR1 AS Area, dbo_F0115.WPPH1 AS Phone
FROM dbo_F0115
WHERE (((dbo_F0115.WPAN8)="469762"));

Here is the query that does not work -- with prompts/criteria:

SELECT dbo_F0115.WPAN8 AS [Customer No], dbo_F0115.WPPHTP AS [Phone Type], dbo_F0115.WPAR1 AS Area, dbo_F0115.WPPH1 AS Phone
FROM dbo_F0115
WHERE (((dbo_F0115.WPAN8)=[Enter address]));

Angie

 

[angela.y.austin]

Hi John,

Thank you for the reply.

Here is the query when it works -- no prompts:

SELECT dbo_F0115.WPAN8 AS [Customer No], dbo_F0115.WPPHTP AS [Phone Type], dbo_F0115.WPAR1 AS Area, dbo_F0115.WPPH1 AS Phone
FROM dbo_F0115
WHERE (((dbo_F0115.WPAN8)="469762"));

Here is the query that does not work -- with prompts/criteria:

SELECT dbo_F0115.WPAN8 AS [Customer No], dbo_F0115.WPPHTP AS [Phone Type], dbo_F0115.WPAR1 AS Area, dbo_F0115.WPPH1 AS Phone
FROM dbo_F0115
WHERE (((dbo_F0115.WPAN8)=[Enter address]));

Angie

 

[John W. Vinson]

Hi John,

Thank you for the reply.

Here is the query when it works -- no prompts:

SELECT dbo_F0115.WPAN8 AS [Customer No], dbo_F0115.WPPHTP AS [Phone Type], dbo_F0115.WPAR1 AS Area, dbo_F0115.WPPH1 AS Phone
FROM dbo_F0115
WHERE (((dbo_F0115.WPAN8)="469762"));

Here is the query that does not work -- with prompts/criteria:

SELECT dbo_F0115.WPAN8 AS [Customer No], dbo_F0115.WPPHTP AS [Phone Type], dbo_F0115.WPAR1 AS Area, dbo_F0115.WPPH1 AS Phone
FROM dbo_F0115
WHERE (((dbo_F0115.WPAN8)=[Enter address]));

Try using an explicit Parameter and properly bracketing the fieldname:


PARAMETERS [Enter Address] Text;
SELECT dbo_F0115.WPAN8 AS [Customer No], dbo_F0115.WPPHTP AS [Phone Type],
dbo_F0115.WPAR1 AS Area, dbo_F0115.WPPH1 AS Phone
FROM dbo_F0115
WHERE ((([dbo_F0115].[WPAN8])=[Enter address]));

Not sure that will help but I've never seen just this error and have not used
Optin archives - what exactly are these???
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[angela.y.austin]

Nope, same error. Any other suggestions?

We are using Optim software to archive/retire JD Edwards data.

Hi John,
Thank you for the reply.
Here is the query when it works -- no prompts:
SELECT dbo_F0115.WPAN8 AS [Customer No], dbo_F0115.WPPHTP AS [Phone Type], dbo_F0115.WPAR1 AS Area, dbo_F0115.WPPH1 AS Phone

FROM dbo_F0115

WHERE (((dbo_F0115.WPAN8)="469762"));
Here is the query that does not work -- with prompts/criteria:
SELECT dbo_F0115.WPAN8 AS [Customer No], dbo_F0115.WPPHTP AS [Phone Type], dbo_F0115.WPAR1 AS Area, dbo_F0115.WPPH1 AS Phone

FROM dbo_F0115

WHERE (((dbo_F0115.WPAN8)=[Enter address]));

Try using an explicit Parameter and properly bracketing the fieldname:





PARAMETERS [Enter Address] Text;

SELECT dbo_F0115.WPAN8 AS [Customer No], dbo_F0115.WPPHTP AS [Phone Type],

dbo_F0115.WPAR1 AS Area, dbo_F0115.WPPH1 AS Phone

FROM dbo_F0115

WHERE ((([dbo_F0115].[WPAN8])=[Enter address]));



Not sure that will help but I've never seen just this error and have not used

Optin archives - what exactly are these???

--



John W. Vinson [MVP]

Microsoft's replacements for these newsgroups:

http://social.msdn.microsoft.com/Forums/en-US/accessdev/

http://social.answers.microsoft.com/Forums/en-US/addbuz/

and see also http://www.utteraccess.com

 

[John W. Vinson]

Nope, same error. Any other suggestions?

We are using Optim software to archive/retire JD Edwards data.

Sorry, that means nothing to me and I have no idea what might be wrong. I
suggest you contact Optin tech support.
--

John W. Vinson [MVP]
Microsoft's replacements for these newsgroups:
http://social.msdn.microsoft.com/Forums/en-US/accessdev/
http://social.answers.microsoft.com/Forums/en-US/addbuz/
and see also http://www.utteraccess.com

 

[Gloops]

I have tables linked to an archive. I have a query built with parameters that prompt the user for input.

I receive the following error after input (46972): "Reserved error (-2029); there is no message for this error."

When I run the query and equal the criteria to 46972, I can retrieve the rows.

Any suggestions?

Hello,

An error number is handy is this, that you can search it on Internet.

Generally, the number is expressed in hexadecimal.
If you put -2029 in the Windows calculator, and then click on "Hex", you
get FFFFFFFFFFFFF813.

The last eight characters will do.

So I searched "error FFFFF813" and obtained

------
http://www.windowsbbs.com/windows-vista/69321-irql_not_less_or_equal-bugcheck-error.html
BugCheck A, {fffff813, 2, 1, 81cb772b}

Probably caused by : memory_corruption ( nt!MiInsertPageInZeroList+24c )
------


I suggest you verify the state of your RAM, for instance with a program
as memtest.

If this confirmed to be the problem, on Internet you find videos about
how to change the RAM modules.

If memtest tells everything is OK, we are back at John's answer about
calling Optim's support. Good idea to provide them information about
this test and its results.

 

[Gloops]

Gloops wrote, on 15th August 2012 09:20 UTC + 2 :

If you put -2029 in the Windows calculator, and then click on "Hex", you
get FFFFFFFFFFFFF813.

Perhaps it is clearer if I precise that you must use the display menu to
get the scientific display, that proposes coding numbers in hexa, octal,
decimal or binary.

With the version that is proposed with Windows XP, the F5 key is the
shortcut for hexadecimal, F6 gets back to decimal, F7 gives you the
octal, and F8 the binary. You can observe that the active keys are
different according to the selected numbering base.

In case you do not know what this means :
http://www.purplemath.com/modules/numbbase.htm