This is the Select Statement in Query Builder when I'm using the Designer
Wizard:
SELECT [Assessed Value], [Billing Cycle], CallClient, Comments,
[Contract?], [ContractSigned?], [Corner Stake Details], [Date Received],
[Date Sent],
[DepositPaid?], [Disputes or Encroachments Flag],
Estimate, FieldCrewInstructions, [GaveROSRequirements?], [Geo?], [Go Date],
[Hourly Billing?],
[Hourly Deposit], [Includes Record of Survey], [Info
Notes], [Initial Contact Date], [Initial Contact Name], [Job Description],
[Job Notes], [Job Notes Flag],
[JobSetup?], Jurisdiction, LastBillingDate, [Legal
Description], [Legal Received?], [Line Stake Details], [Lot Size], [Lot Size
Type], NextBillingDate,
[Not to Exceed], [Office Due Date], [Paid Barry],
[Party ChiefID], [Payment Notes Flag], [Payment Plan],
[PaymentArrangements?], [Percent Complete],
[Percent Complete2], [PickupContract?],
[PickupDeposit?], PickupLegal, [PO#], Price, ProjectID, [Project Name],
[Business Name], contact1,
[Current Status], [# of Line Stakes], [# of Stake
Corners], [1], [2], [3], Priority, [Project ManagerID], [Project Referance],
[Projected Field Manhours],
[Projected Office Manhours], [Reason for Project
Flag], [Reason for Survey], [Received Back], [Required Due Date], [ROS
Paid], ROSCost, ROSStatus,
ROSStatusNotes, ROSType, [Scheduled Date], [Schedule
Office?], ScheduleNotes, [Site 1st 1/4], [Site 1st 1/4_2], [Site 2nd 1/4],
[Site 2nd 1/4_2],
[Site Access?], [Site Address], [Site Area], [Site
Block #], [Site Brush?], [Site City], [Site County], [Site Cross Reference],
[Site Disputes/Encroachments?],
[Site Grid], [Site Grid_2], [Site Improvements?],
[Site Legal Description], [Site Lot #], [Site Page], [Site Plat Name], [Site
Range], [Site Range_2],
[Site Section], [Site Section_2], [Site Slope?], [Site
Special Conditions], [Site State], [Site Tax #], [Site Thomas Guide], [Site
Township],
[Site Township_2], [Site Trees?], [Site Volume], [Site
Wetlands?], [Site Zip], SpecificJobInstructions, [Status Notes], [Survey
Type], Title,
[Total Office Manhours Billed], [Total Field Crew
Hours Billed]
FROM tblProjects
I can't add more fields. I get an error saying "There were errors
configuring the data adapter."
As soon as I delete the added field I get no more errors. I know the fields
I'm trying to add are not using reserved keywords and there are nothing
wrong with them.
Thanks,
Anatoly
Brian Brown said:
Hi Anatoly,
I am glad that worked. As for selecting reserved keyword you should be
able
to do something like (using the reserved word SELECT as an example)
SELECT MyTable.[SELECT] FROM MyTable
If you are using the designer to choose the column names you shouldn't
have
to enclose the reserved words in []. It will do that for you (look at the
Sql View once you have your query complete).
If this does not help and you are having a specific problem can you post
more details about what you are trying to do? For instance the table
structure (partial - the part that is giving you problems) and the query
that
is giving you problems.
I have posted below a couple of links from the MSDN listing of the
reserved
words for different versions of Access.
I hope this helps.
--------------------------
Access 2000
http://support.microsoft.com/kb/209187/EN-US/
Access 2002 and 2003
http://support.microsoft.com/?id=286335