Access 2002 Queries

  • Thread starter Thread starter Cathie
  • Start date Start date
C

Cathie

I have Windows 2000, running Access 2002 SP 3. Since I
downloaded the SP 3. When I create queries with the
tables in access, even though I only add one field from a
table it adds all the fields from the table into the
query, and I am getting compile errors. Does anyone else
have this problem, or an answer for it?
 
Open any database and choose Options from the Tools menu. Make sure Output
all fields is unchecked on the Tables/Queries tab.

What compile error messages are you getting? Open any module in the VB
Editor and choose References from the Tools menu. Uncheck any libraries
marked "Missing". You should have Visual Basic For Applications, Microsoft
Access 10.0 Object Library, and either Microsoft DAO 3.x Object Library or
Microsoft ActiveX Data Objects 2.x Library (or both).

--
John Viescas, author
"Microsoft Office Access 2003 Inside Out"
"Running Microsoft Access 2000"
"SQL Queries for Mere Mortals"
http://www.viescas.com/
(Microsoft Access MVP since 1993)
 
Back
Top