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 database -
the design of the database is very simple.
I should also note that I ran the "compact and repair database" tool
and I am still getting the same error message.
Any thoughts?
Thanks!
8  17804 
"adampierce " <ap*******@gmai l.comwrote in message
news:f8******** *************** ***********@l1g 2000hsa.googleg roups.com...
>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 database -
the design of the database is very simple.
I should also note that I ran the "compact and repair database" tool
and I am still getting the same error message.
Any thoughts?
Thanks!
Just a guess.....
Do you have any field names that use "reserved" words?
Like:
Date, Name, Min, Max, Sum, Where, etc
Would you post the query?
Fred Zuckerman
Yes...They are definitely yes/no fields...I tried removing them one at
a time, and it turns out that if I remove all of them, the query runs,
but if I leave any of them in, it doesn't run. What is possibly even
more odd is that I can filter on these fields in some queries but not
in others. I even have a query where this type of WHERE clause works
when I run the query, but when I try to view it through a report
rather than in datasheet view, I get this same weird error message.
Does it have anything to do with the fact that I'm using Access 2007?
Thanks again for your help.
"adampierce " <ap*******@gmai l.comwrote in message
news:fd******** *************** ***********@i7g 2000prf.googleg roups.com...
Yes...They are definitely yes/no fields...I tried removing them one at
a time, and it turns out that if I remove all of them, the query runs,
but if I leave any of them in, it doesn't run. What is possibly even
more odd is that I can filter on these fields in some queries but not
in others. I even have a query where this type of WHERE clause works
when I run the query, but when I try to view it through a report
rather than in datasheet view, I get this same weird error message.
Does it have anything to do with the fact that I'm using Access 2007?
Thanks again for your help.
Next guess....
Check your references to see if any show as "Missing"
Ctrl+G, Tools -References
Otherwise, I'm stumped.
Sorry
Fred
How do I know if a reference is missing? When I look at references, I
get a list of available references, and the first four have check
marks next to them, and the rest are blank. I don't clearly see that
anything is missing, though.
Thanks again!
"adampierce " <ap*******@gmai l.comwrote in message
news:1d******** *************** ***********@d4g 2000prg.googleg roups.com...
How do I know if a reference is missing? When I look at references, I
get a list of available references, and the first four have check
marks next to them, and the rest are blank. I don't clearly see that
anything is missing, though.
Thanks again!
If there was a problem, then one of the checked items would have the word
"Missing" next to it.
Fred
"Fred Zuckerman" <Zu********@sbc global.netwrote in message
news:GE******** *********@newss vr19.news.prodi gy.net...
"adampierce " <ap*******@gmai l.comwrote in message
news:1d******** *************** ***********@d4g 2000prg.googleg roups.com...
>How do I know if a reference is missing? When I look at references, I
get a list of available references, and the first four have check
marks next to them, and the rest are blank. I don't clearly see that
anything is missing, though.
Thanks again!
If there was a problem, then one of the checked items would have the word
"Missing" next to it.
Fred
Maybe there's a corrupted record somewhere in the table. Try deleting all
the records and run the query on the empty table. If you don't get the
error, then add back some records, and repeat.
Fred
I think you hit it right on the head. I found a record that had some
corrupt data in it, and when I deleted it, the query worked! Thanks!
adampierce <ap*******@gmai l.comwrote:
>I think you hit it right on the head. I found a record that had some
corrupt data in it, and when I deleted it, the query worked! Thanks!
Thanks for posting back your solution. That message is exceedingly rare when I did
some searching at Google. I'd suggest purchasing some lottery tickets.
Added to the Access Corruption Symptoms page at my website.
Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/ This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics | |
by: Pai |
last post by:
Hello there,
I am trying to send a attachemnt using CDO
when I try to attach a file to the message, I get the error
CDO.Message.1 error 80070005
Access denied
|
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? Rosy
We are running Windows 2000 Server and Win 2000 on the terminals.
Access 2000.
|
by: dkintheuk |
last post by:
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?
|
by: Erwan |
last post by:
I have a strange (but very blocking) result when using the smtpmail
class from an ASPX page :
here is the (very simple !) code...
'--------------------------------------------------
mail.To = "el@illico.fr"
mail.From = "el@illico.fr"
mail.Subject = "test envoi de mail"
mail.Body = "test envoi de mail"
|
by: Rider |
last post by:
Hi, simple(?) question about asp.net configuration..
I've installed ASP.NET 2.0 QuickStart Sample successfully. But, When I'm
first start application the follow message shown.
=========
Server Error in '/QuickStartv20' Application.
--------------------------------------------------------------------------------
Configuration Error
Description: An error occurred during the processing of a configuration file
| | |
by: Joshua V. |
last post by:
We are trying to implement Windows Error Reporting from within our VB.Net
application. Basically we want to replace the standard unhandled exception
message we use with the Windows Error Reporting message. This will provide
our users the ability to send the crash report to Microsoft, which in turn
will allow us to get it.
We did a search for Visual Studio help to see what that might turn up and
came across the “ReportFault”...
|
by: kvarada |
last post by:
Hello Experts,
I am building my application on WinNT.4.0_i386_MSVC.7.1 platform. When I build the application on a stand alone machine, it builds fine. But when I build the same application from a linux box using rsh it gives me the errors below
Microsoft (R) Development Environment Version 7.10.3077.
Copyright (C) Microsoft Corp 1984-2001. All rights reserved.
------ Build started: Project: SigComp, Configuration: Release Win32 ------...
|
by: Walt in Decatur |
last post by:
Just tried to open reports in a database prepared in Access 2003 in my brand new Access 2007 and got this error. One of these reports has sub-reports that generate this error, but another one does not and still the error message pops up. Since the error has no explanation attached to it, I'm at a loss to figure our what's going on.
I am able to preview the report in "Layout View", but get the error when I attempt to print.
Any ideas?
|
by: Mark05 |
last post by:
#include<conio.h>
#include<iostream>
using namespace std;
int main()
{
double ManfCode,ProdCode;
int Checkdigit, SecondManf, FourthManf;
int FirstProd,ThirdProd,FifthProd;
int SecondProd,ForthProd;
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it.
First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
|
by: Hystou |
last post by:
Overview:
Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
| | |
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 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 a new presenter, Adolph Dupr who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms.
Adolph will...
|
by: conductexam |
last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert into image.
Globals.ThisAddIn.Application.ActiveDocument.Select();...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
|
by: adsilva |
last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
| | |
by: bsmnconsultancy |
last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...
| |
