Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Articles for product: Microsoft Office Access 2007

Article ID Article Title Hidden
163438 Warning message when you start Access 2007 after you install Access 2007 Developer Extensions: "You don't have a source code control program (such as Microsoft Visual SourceSafe) installed on your machine"
168798 How To Parse City, State, and Zip Code into Separate Values
197103 ACCESS: How to Prompt User to Save Changes to Record in a Form
202261 You cannot use a pound character in a file name for a hyperlink in an Office program
207823 "Save Password" check box is unavailable when you link ODBC tables
208408 ACCESS: Exporting to Text File Truncates to Two Decimals Places
209141 Microsoft Access: How to Group Column Headings in a Crosstab Query
209502 How to store SQL database login IDs and passwords locally
209849 How to loop through the references to view their properties in Microsoft Access
210362 HOW TO: Use the Attributes Property for TableDef Objects in Microsoft Access
213800 In Office programs, you receive a "Specified COMMAND search directory had too many parameters" error message when you try to use an MS-DOS core command from the Shell function
237590 The "Import/Link Data on an FTP or HTTP Server" Help topic is not correct in Access 2000, Access 2002, Access 2003 and Access 2007
238972 Using Visual C++ to automate Office
242375 PRB: Office 97 Automation Client Fails After Re-compilation with Office 2000 or Later Type Library
246237 BUG: Access object model breaks binary compatibility
247386 Microsoft Jet database engine 4.0 enforces the syntax "Is Null"
258511 How to obtain the window handle for an Office Automation server
259134 Information about the Microsoft policy on forgotten password assistance with Microsoft Access
266387 How to find and to list Access VBA procedures by using MFC
274680 How to use MFC to retrieve a list of macro names in an Office document
278374 PivotTables and PivotCharts do not show values found in lookup list or in value list in Access
282315 Access appears to hang when you preview or print an object in PivotTable view
282323 The Display Type property of an OLE Object changes to "Content" when the record is saved
283228 Exclusive lock is required for saving design changes to Access objects in Access
283788 ACCESS: "Microsoft Access Was Unable to Create an MDE, ACCDE, or ADE Database" Error Message with a Database That You Cannot Compile
283806 Visual Basic for Applications (VBA) functions break in a database with missing references
283849 How to troubleshoot and to repair a damaged Access 2002 or later database
283878 Description of the database normalization basics
285820 How to display images from a folder in a form, a report, or a data access page
286446 Date/Time data type provides current year automatically
287696 Error message when you use Access: "The Microsoft Jet database engine cannot find the input table or query '<name>'" or "The record source '<name>' specified on this form or report does not exist"
289670 How to synchronize two combo boxes on a form in Microsoft Access
289681 You may receive a "file already in use" error message when you try to open an Access database that is located on a server
290127 Btrieve ISAM is not available in Microsoft Access 2002 and in later versions of Access
290148 How to use the Undo feature with inserted objects in Office programs
290228 "Cannot connect to the FTP server" error message when you access an FTP site in Office
292634 How to use a query to filter unique data in Access
292783 How to force Microsoft Access to use read-only (snapshot) mode for linked data
293303 Technical resources for Office Products
297373 Logon errors occur when you connect to a SQL Server database from a Microsoft Access project
299958 Errors that the RegClean utility finds after you install Microsoft Office
302891 How to start MSBackup.exe from Microsoft Access
303968 How to create an SQL pass-through query in Access
304466 How to define relationships between tables in an Access database
310803 How to resolve reference issues in an Access database
318989 A collation conflict error occurs when you open an Access Project table or view
319844 You receive a "ActiveX component can't create object" error message when using Access
325233 HOW TO: Hide the Combo Box Drop-Down Arrow on a Form in Microsoft Access
325573 You receive error messages when you try to open an Office document
328828 How to troubleshoot errors that may occur when you update data in Access queries and in Access forms