Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Compile Error in query expression 1

Status
Not open for further replies.
CathieB

CathieB

Programmer
Feb 21, 2003
13
0
0
US
I am programming in Access 2002, Using Windows 2000.
I installed the new SP3 to my computer, and now when I try to create a query using the tables in access, it adds all the fields to the query, even if I have only added one. And I am getting compile errors in all my queries....

Does anyone else have this problem, or does anyone know how to fix it.
 
Sort by date Sort by votes
In "Tools - Options - Tables/Queries" check to be sure that "Output All Fields" IS NOT selected.
 
Upvote 0 Downvote
THANK YOU GOLOM. Does the SP3 reset this option?
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

PizMac
  • Locked
  • Question
error 3027 database or object is read-only
Replies
5
Views
200
PizMac
PizMac
TheresAlwaysAWay
  • Locked
  • Question
Long-established database suddenly giving error Cannot open macro [Name] because it is not valid
Replies
6
Views
250
dhookom
dhookom
TheresAlwaysAWay
  • Locked
  • Question
How can I make Access display a + sign in front of positive integers, just as it does - for neg? 2
Replies
8
Views
393
TheresAlwaysAWay
TheresAlwaysAWay
TheresAlwaysAWay
  • Locked
  • Question
Delete query takes FOREVER to run 1
Replies
11
Views
190
jedraw
jedraw
Bill6868
  • Locked
  • Question
Query Expression Question
Replies
3
Views
93
Andrzejek
Andrzejek

Part and Inventory Search

Sponsor

Back
Top