Access error message

C

cdono

Hi. I've just had to reload Windows XP and consequently Office 2000.
My Access database, which was working fine until this has developed a
error message which reads: "Circular reference caused by alias 'Exp
1000' in query definition's Select List". I get this everytime I ope
up the main table in the database. The choices for me are OK or Help.
Clicking Help just gets a blank screen. Clicking OK gets the messag
again. Clicking OK for this second time allows me to edit the databas
table, which seems fine. What's it all about and how can I rectify it
 
D

David Lloyd

The error message indicates that the source of the error is a query. One
cause of this error message is if you use an alias that is also the name of
a field in the underlying table. For example:

SELECT CStr([LastName]) AS LastName
FROM MyTable;

I would look at your queries for a field aliased as "Expr 1000" and look to
see how it is referenced in that field.

--
David Lloyd
MCSD .NET
http://LemingtonConsulting.com

This response is supplied "as is" without any representations or warranties.



Hi. I've just had to reload Windows XP and consequently Office 2000.
My Access database, which was working fine until this has developed an
error message which reads: "Circular reference caused by alias 'Expr
1000' in query definition's Select List". I get this everytime I open
up the main table in the database. The choices for me are OK or Help.
Clicking Help just gets a blank screen. Clicking OK gets the message
again. Clicking OK for this second time allows me to edit the database
table, which seems fine. What's it all about and how can I rectify it?
 
T

Tony Toews

cdono said:
Hi. I've just had to reload Windows XP and consequently Office 2000.
My Access database, which was working fine until this has developed an
error message which reads: "Circular reference caused by alias 'Expr
1000' in query definition's Select List". I get this everytime I open
up the main table in the database. The choices for me are OK or Help.
Clicking Help just gets a blank screen. Clicking OK gets the message
again. Clicking OK for this second time allows me to edit the database
table, which seems fine. What's it all about and how can I rectify it?
Click to expand...

I suspect if you have a faulty query in a lookup field in that main
table? Open the table in design view, click on the Lookup tab and
click on each field down the table looking for a field with data in
the Row Source field.

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
 
Top