Index to Troubleshooting Topics

Open table as spreadsheet

Topic	Description	Page
Tables	Why can’t I see the Maximize/Minimize buttons on my table?	109
Tables	Why does my table have extra rows in the lower half of the screen like a spreadsheet?	111
External Data	Why can’t I connect to my local instance of SQL Server 2005 Express Edition using Windows authentication on my Windows Vista computer?	258
External Data	Access won’t use ODBC for all file types.	268
External Data	You can’t connect to a specific database using trusted authentication because you use more than one data source.	302
External Data	Why can’t I see all the fields from my table in the data collection process?	311
Queries	How can I be sure I’m using the correct table in the query designer?	415
Queries	I didn’t specify sorting criteria, so why is my data sorted?	439
Queries	How do I display more than one value in a crosstab?	444
Reports	Why did the Print Preview tab disappear when I collapsed the Navigation Pane?	739
Macros	Why doesn’t the list include all the macro actions available?	892
Forms	Why isn’t Access setting my defined default value for a date/time field?	1063
External Data	I don’t see the graphic or the background on my sample page. What am I doing wrong?	1150
Windows SharePoint Services	Why doesn’t my imported Windows SharePoint Services list include all the records?	1191
Windows SharePoint Services	Why can’t I make any changes to my published database?	1224
Access Project	I keep getting errors when I try to create a new database. What am I doing wrong?	1452
Access Project	I’m using SQL Server 7, so why can’t I see all the column properties or create lookups?	1470
Access Project	Why can’t I open my form in Layout view in a project file?	1552