Open the database exclusively
In Access 2003/XP/2000/97, I tried modifying some of the objects in my Access database and I received an error message stating that I needed to open the database exclusively. What does this mean and how do I open a database exclusively?

---

Import an Access 2.0 database into an Access 2007 file
If you use an existing database in the Access 2.0 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb). To import forms, reports, or modules into Office Access 2007, you must first convert the database by using an earlier version of Access, open the database in Access 2007, and then convert the database into the Access 2007 database format. The following sections in this article explain how to perform each of these tasks. What do you want to do? * Open an Access 2.0 database in Access 2007 * Import data from an Access 2.0 database * Convert an Access 2.0 database by using Access 2003, Access 2002, or Access 2000

---

Help secure an Access 2007 database
This article explains how to help keep your Microsoft Office Access 2007 databases more secure. It explains the concepts that you must understand before you can use the Office Access 2007 security features properly and how to use the tools that Access provides for helping to secure a database. In this article * What's new in Office Access 2007 security * Use an Office Access 2007 database in a trusted location * Package, sign, and distribute an Office Access 2007 database * Enable disabled content when you open a database * Use a database password to encrypt an Office Access 2007 database * How security works with databases from earlier versions of Access opened in Office Access 2007 * Run unsafe expressions (disable sandbox mode)

---

Open an existing database
This topic describes the different methods you can use to open existing Microsoft Office Access 2007 databases. You can open databases from Windows Explorer or from within Access itself. You can open multiple databases at once, and you can also create desktop shortcuts that open database objects directly. What do you want to do? * Open an Access database from Windows Explorer * Open a database from within Access * Open multiple databases at the same time * Create a desktop shortcut to open a database object

---

Where did my switchboards go?
In Microsoft Office Access 2007, when you open a database created in an earlier version of Access - and that database contains a switchboard (a form with buttons or links that enabled you to navigate around the database) - some commands on that switchboard may not work. Specifically, commands to display the Database window no longer function. Office Access 2007 provides a new feature called the Navigation Pane. The pane replaces the Database window, and you can use the pane instead of switchboards. The Navigation Pane works with the new user interface model adopted by Office Access 2007. That model (called the single-document interface model) places any open objects - forms, reports, and so on - in a single window and marks each object with a tab. When you open more than one object, you use the tabs to switch between the open objects

---

Demo: Up to speed with Access 2007
Microsoft Office Access 2007 brings you a new look and new features designed to help you get your work done more easily than ever. You'll see differences right away, starting with the Getting Started with Microsoft Office Access page where you can open a blank or existing database, download a pre-built database template, and check out the offerings on Microsoft Office Online. Watch the demo for an introduction to Office Access 2007. You'll also hear about new file formats, and see how to work with files from previous versions of Access.

---

Create Database in MS Access 2007
What is a Database? Create a database from a template, Create a database using a template from Office On Line, Open a recently used database, Open a database through Microsoft Office Access button, Close a database.

---

Access 2007: Get up to speed
Microsoft Office Access 2007 brings you a new look and new features designed to help you get your work done more easily than ever. You'll see differences right away, starting with the Getting Started with Microsoft Office Access page where you can open a blank or existing database, download a pre-built database template, and check out the offerings on Microsoft Office Online.

---

Set or change Access 2003 user-level security in Access 2007
If you created a database in a previous version of Access and you applied user-level security to that database, those security settings remain in place when you open that file in Microsoft Office Access 2007. In addition, you can start the security tools provided by Microsoft Office Access 2003 - the User-Level Security Wizard and the various user and group permission dialog boxes - from Office Access 2007. This article explains how the Access 2003 security features work, and it explains how to start and use them in Access 2007.

---

Show or hide the Navigation Pane
By default, the Navigation Pane appears when you open a database in Microsoft Office Access 2007, even if the database was created in an earlier version of Access. In an open database, you can hide or show the Navigation Pane at any time. You can also set the default option in an open database so that the Navigation Pane does not appear the next time the database is opened.

---

Introduction to the Access 2007 Developer Extensions and Runtime
With the release of Microsoft Office Access 2007, the Access 2007 Developer Extensions and the Access 2007 Runtime are available as free downloads. These utilities provide database developers with tools to package and deploy a database, create database templates, and integrate a database with source code control systems, such as Microsoft Visual SourceSafe.

---

My PivotTable and Chart controls don't work in Access 2007
When you open a Microsoft Office Access 2003 or earlier Microsoft Access file format database in Access 2007, one of the following messages appears: * Your Microsoft Office Access database or project contains a missing or broken reference to the file '0WC10.DLL' version 1.0. * Your Microsoft Office Access database or project contains a missing or broken reference to the file '0WC11.DLL' version 1.0. Access 2007 opens the database file, but any Microsoft Office PivotTable controls or Microsoft Office Chart controls that are contained on forms, reports, or data access pages do not work. In addition, Access might show the message "There is no object in this control" when you open an object that contains a PivotTable control or Chart control.

---

Get to know Access 2007
When your data works for you, that's great. When you have to work on your data, that's not so good. For convenient, reliable data management, get to know Access 2007. It puts you in charge. After completing this course you will be able to: 1) Explain the benefits of Access 2007 compared to workbooks or lists. 2) Find and download an Access 2007 database template. 3) Identify the main parts of a database.

---

Create a new database
Microsoft Office Access 2007 features a number of improvements that make the process of creating a new database easier. Even if you have created databases before, it is likely that you will appreciate these features for their ability to speed up the creation process. This article covers the basic process of starting Office Access 2007 and creating a database, either by using a template or by creating your own tables, forms, reports, and other database objects. It also details a few techniques that you can use to get information into your new database. What do you want to do? * Get to know the Getting Started with Microsoft Office Access page * Create a database by using a template * Create a database without using a template * Copy data from another source into an Access table * Import, append, or link to data from another source * Open an existing Access database * Create a custom blank template

---

Access 2007
In this tutorial I will explain how to setup a database, tables, and creating relationships using Microsoft Access 2007. In Access 2007 the database format changes to accdb, but there is an option to export your database as the old format mdb.

---

What happened to the Database window?
The Database window is no longer available in Microsoft Office Access 2007. In Access 2007, you now use the Navigation Pane to perform tasks that you previously accessed by using the Database window. For example, if you want to open a table in Design view or run a report, you can perform those tasks from the Navigation Pane.

---

Use a Database Template in Access 2007
Some database templates are included in Access 2007 and are frequently used by beginners to create applications without knowing anything about database design. Advanced users may also find that templates save time in setting up an application. The following steps will show how to create a database in Access 2007 using a template.

---

Video tutorial
Microsoft Access 2007 helps you effectively track, report, and share information in a manageable environment. With a library of pre-built tracking applications (database solutions) and the Microsoft Office Fluent user interface, Access 2007 does not require deep database knowledge or programming skills. In this VTC course, Author / IT Instructor, Tim Warner introduces users to database design concepts while assisting them in becoming proficient with building and maintaining an Access 2007 database. To begin learning today, simply click on one of the Microsoft Access 2007 links.

---

Create a macro that runs when you open a database
If you want to perform a particular set of actions every time that a database starts, you can create an AutoExec macro. For example, you might want to maximize the database window, lock the Navigation Pane, and then open a particular report. An AutoExec macro is just a macro that is named AutoExec. When a database starts, Access runs the AutoExec macro before it runs any other macros or VBA code. (Applies to: Microsoft Office Access 2007)

---

Get started with Access 2007 security
Microsoft Office Access 2007 provides a number of new features that can help make your data and your computer more secure. In addition, these features can be easier to use than the security tools in previous versions of Access. This article explains how to use the most common security features in Office Access 2007. The information in this article is intended for new users who want to do the following tasks: * Trust (enable) the disabled content in a database * Use a password to encrypt or decrypt a database * Package, sign, and deploy an Office Access 2007 database This article also provides background information about the new security features and architecture in Access 2007.

---

Access Tips
Adding the Database Name to a Report in Access, Automatically Compact and Repair Access Databases, Change the Default Working Folder in Access, Combining Text from Two Fields in Access, Create a Vertical Control in Access, Define a Default Field in an Access Database, Deleting Duplicate Records in Access, Display Tabbed Documents in Access 2007, Displaying Highest or Lowest Values in an Access Query's Results, Import Access Tables into Excel, Insert Time/Date in Excel or Access, Navigation Pane in Access 2007, Number Entries in an Access Report, Report Layout View in Access 2007, Techniques for Creating Forms and Reports in Access, Upgrading to Access 2007, Using Validation Rules to Restrict Data in Microsoft Access

---

Use existing custom toolbars and startup settings in Access 2007
This topic explains how custom toolbars and menu bars that you created in earlier versions of Access behave when you open those older databases in Microsoft Office Access 2007. This topic also explains how to turn off the Ribbon so that you can use just your custom toolbars and menu bars. The Ribbon is part of the Microsoft Office Fluent user interface. In this article: * How earlier version databases behave in Office Access 2007 * Open and use an earlier version database that contains custom toolbars * Open and use an earlier version database with custom startup behavior * Turn off the Ribbon and use just your custom menu bars

---

Link an Access 2007 database to a database that contains data access pages
A data access page is a Web page that is designed to let you view and work with data from the Internet or an intranet. This data is typically stored in an Access database. The ability to create, modify, or import data access pages is no longer supported in Microsoft Office Access 2007. However, you can still use Access 2007 to work with databases that contain data access pages.

---

How to Do an Access 2007 Delete Query
Access 2007 is a database program that is a part of Microsoft Office 2007. A delete query is a action available in Access that allows users to delete entire records from a database. Doing a delete query in Access 2007 is an easy task that can be completed in just a few minutes.

---

What's new in Microsoft Office Access 2007
Microsoft Office Access 2007 provides a powerful set of tools that help you to quickly start tracking, reporting, and sharing information. You can rapidly create attractive and functional tracking applications by customizing one of several predefined templates, converting an existing database, or creating a new database, and you can do so without deep database knowledge. By using Office Access 2007, it is easy to adapt database applications and reports to changing business needs. The enhanced support for Microsoft Windows SharePoint Services 3.0 in Office Access 2007 helps you to share, manage, audit, and back up your data.

---

Exploring a desktop Access 2007 database
In this article: * Navigating through a desktop database * Tables * Queries * Forms * Reports * Macros * Modules Once you are more comfortable with the user interface in Microsoft Office Access 2007, you'll want to dig deeper into exactly what makes up an Access database. This article uses an example to help you understand the relationships among the main components in Access and shows how to move around within the database management system.

---

Four Things to Love About Microsoft Access 2007
For many years now, Microsoft Access has been one of the most popular of all desktop database programs. Along with its bigger cousin, Microsoft SQL, Microsoft Access has helped form the core of database development for many small, medium and large businesses, and with the new version, Microsoft Access 2007, on the horizon it is important for workers to learn about the new features and benefits of this new program. Those who have been using Access 2000, Access XP or Access 2003 will recognize much of the interface of Microsoft Access 2007, but there are some notable differences, and a new look as well. It is important for those considering upgrading to the new version to understand the unique features and benefits of the 2007 version of Microsoft Access.

---

About saving design changes to a shared Access database (MDB)
You cannot save design changes to a Microsoft Access database while other users have the Access database open. The only way to ensure that changes are saved is by opening the Access database in exclusive (exclusive: A type of access to data in a database that is shared over a network. When you open a database in exclusive mode, you prevent others from opening the database.) mode.

---

Troubleshoot a shared database (MDB)
I can't save changes to a Microsoft Access database. I can't change the table's design. I can't view data in a table. I can't open a database object. I can't open a shared Access database.

---

Design tables for a new Access 2007 database
Learn how to plan the tables that store your data. Create tables for a new Access 2007 database. How to build the tables and set the data types for the fields in each table. Build relationships for a new Access 2007 database: how to creating the relationships between your tables, and how to put them to work. Create queries for a new Access 2007 database: how to create the queries that extract data, add calculations, and make it easier to create forms and reports.

---

Creating Charts in an Access 2007 Database
Garry Robinson fills the gap found in the Access 2007 help manual by providing some much needed help on how to use the charting object in Access 2007.

---

Import an Access 95 database into an Access 2007 file
If you use an existing database in the Access 95 format (.mdb), you can import tables, queries, and macros from that database into a Microsoft Office Access 2007 database (.accdb). You can also import forms and reports that do not employ Microsoft Visual Basic for Applications (VBA) code. To import forms and reports that contain VBA code (and also modules), first convert your Access 95 database to the Access 2002 - 2003 or Access 2000 file format by using Microsoft Office Access 2003, Access 2002, or Access 2000, and then use Access 2007 to convert that file to the Access 2007 file format. What do you want to do? * Import data from an Access 95 database * Convert an Access 95 database by using Access 2003, Access 2002, or Access 2000

---

Create a Manual Table in Access 2007
A table in Access 2007 is a list that contains rows and columns. It is used to store subject-based data and should be created before any other objects when designing a database. You can create a table in a new or existing database in Access 2007.

---

The Powerful New Features of Microsoft Access 2007
For as long as businesses and individuals have used data, there has been a need for a way to collect, maintain and use that data. Database programs like Microsoft Access were built with that need in mind, and with every new generation of the Access program, Microsoft has attempted to make the database experience safer, easier and more user friendly. That tradition continues with the release of the new Access 2007, part of the Microsoft Office 2007 family of products.

---

How database objects behave when trusted and untrusted
By default, Microsoft Office Access 2007 disables a number of database objects unless you apply a digital signature to them or you place the database in a trusted location. The information in this article lists the components that Office Access 2007 disables. TOC: * Components that Office Access 2007 disables * How to enable a disabled database

---

Training presentation: Access 2007-Get to know Access
This template provides an introduction to Microsoft Office Access 2007. It explains the advantages of Access as compared to other ways of working with data, shows how to find and use the new database templates, and offers a quick tour of a database. This content is geared for a corporate trainer to present to a group.

---

Plan a Database for Access 2007
When creating a database in Access 2007 you need to plan. In this video you will get some ideas as to what you should think about when planning a database in Access 2007.

---

Set the default form that appears when you open a database
In many database applications, it is helpful to have the same form open automatically every time that you open the database. The simplest way to set the default startup form is to specify the form in Access Options. You can also create an AutoExec macro to perform actions when a database starts. For more information, see the article Create a macro that runs when you open a database.

---

Access 2007 Security Options
Security has always been an important part of database programs, and it is important for users of the new Microsoft Access 2007 database program to take a good look at the ways in which security has been changed and enhanced in this new version. The new Access 2007 allows database developers the ability to quickly and easily lock down their creations without sacrificing the user friendly features of the program. The ability to enhance security is one of the most powerful features of the program, and one that database administrators and other IT professionals will definitely appreciate.

---

What happened to data access pages?
A data access page is a Web page that is designed to let you view and work with data from the Internet or an intranet. This data is typically stored in an Access database. The ability to create, modify, or import data access pages is no longer supported in Microsoft Office Access 2007. However, you can still use Access 2007 to work with databases that contain data access pages. * Use Access 2007 to work with a database that contains data access pages * Alternatives to data access pages

---