Access 2007 Solution Center

Top issues

• Defining relationships between tables in a Microsoft Access database
• How to reset an AutoNumber field value in Access
• "File sharing lock count exceeded…" error message during large transaction processing
• How to create an SQL pass-through query in Access
• Functions for calculating and for displaying Date/Time values in Access
• How to use a query to filter unique data in Access
• Error message when you run an append query, run a make-table query, or import data in a large Access database file: "Invalid argument"
• How to retrieve the selected items in a multiple selection List Box as a comma-delimited string in Microsoft Access
• How to use the query by form (QBF) technique in Microsoft Access
• How to manually split a Access database in Microsoft Access

• Learn more about the Office Ribbon

Using Access

• Get help with expired beta software
• How to use the Workgroup Administrator utility in Access 2007
• The ID field is increment by one every time that you add a field to a new table in Datasheet view in Access 2007
• You cannot process a data collection e-mail reply when the query that the e-mail was based on contains an Access 2007-defined function

Installing Access

• 2007 Microsoft Office system pricing and upgrade eligibility
• Find help when you receive the "Setup is unable to proceed" error message when installing Office 2007
• Troubleshoot when installing an Office 2007 program from the program CD
• Convert trial versions of Office 2007 to full licensed version

Activating Access

• Find a list of helpful resources about activating Microsoft Office programs

Using Access

• Error message when you try to add a new item value to a linked table in Access 2007: "Invalid argument"

Installing Access

• Find help when you receive the "Setup is unable to proceed" error message when installing Office 2007
• Troubleshoot “Error 1923: Service 'Office Source Engine' (ose) could not be installed"
• Error message: “Microsoft Office encountered an error during setup. Error 1714”
• Error message when you try to install an Office 2007 program: "Error 1935. An error occurred during the installation of assembly component"

Alert IDs

• Learn how to use the Alert ID feature in the Office 2007 programs

Keeping Office up to date

• Visit Downloads on Microsoft Office Online to get the latest updates
• Visit Microsoft Update to keep your PC up to date

Finding add-ins

• Microsoft Save as PDF download add-in
• Microsoft Save as PDF or XPS download add-in

Installing

• Convert trial versions of Office 2007 to full licensed version
• Troubleshoot when installing an Office 2007 program from the program CD
• Find help when you receive the "Setup is unable to proceed" error message when installing Office 2007
• Install and to repair Office 2007 features

Activating

• Find a list of helpful resources about activating Microsoft Office programs

Making Access more secure

• New to Access 2007 security? Start here
• Change your security settings through the Trust Center

Making your computer more secure

• Visit the Microsoft Security Center
• Download a free trial of Windows Live OneCare – all-in-one PC care from Microsoft
• Visit the Virus and Security Solution Center
  The Virus & Security solution center provides resources to protect yourself and your PC from viruses, hoaxes, and scams.

Privacy options

• Learn about privacy options for Office 2007 programs

Migrating to Access 2007

• Migrating to Access 2007 from previous versions of Access
• Migration considerations for Access 2007
• What happened to data access pages?
• Convert a database to the Access 2007 file format

• Convert a database to the Access 2007 file format
• Which file format should I use in Access 2007?
• Differences between the ACCDB and MDB file formats

• Learn about the new Office ribbon
• Learn about the new Microsoft Office Access 2007 new interface
• How to use the Workgroup Administrator utility in Access 2007
• What happened to data access pages?
• Learn more about the Office Ribbon

• You cannot open the front-end database when the back-end database is encrypted by using a password in Access 2007
• You may experience slow performance when you view records in a table that contains a lookup field in Access 2007
• The data in a report or in a form is not updated in Access 2007
• Access 2007 may close unexpectedly when you try to change the Control Source property for a control that is on a report or on a form in Layout view

• Contact a support professional by e-mail, online, or phone
• Ask questions, share information, and exchange ideas with others in Office discussion groups
• Subscribe to e-mail news about Office
• Share your feedback with the Microsoft Office product team