How to Convert an MDE to an MDB
If you've written an MDB database file, and you want to let other users perform applications with it, but don't want them to change any codes, change it to an MDE file, another type of Microsoft Access file. In MDE, however, you can't change how the database and macros work. Learn how to convert the MDE file back to an MDB (modifiable) file.

---

How to make design changes to an Access MDE file
A common question in Access database newsgroups and forums is 'How can I convert my Access database from MDE format into an MDB file?' If your file contains VBA code then the correct answer is that you can't since the MDE file is locked and protected. However, the protection isn't the main obstacle in trying to convert the MDE file, the main issue is that all VBA modules are saved in a compiled state with any original source-code being stripped out.

---

Reasons for Converting Your .mdb Files to .mde Files
The Microsoft Office suite of software was developed for novice users to suit those not necessarily interested in development. To simplify database development, Microsoft Access embeds database applications, developed using Microsoft VBA programming, with database tables, objects and other components. Microsoft Access stores these database components in a single file, using the .mdb extension.

---

How to determine why Access is unable to create an MDE database
I tried to compile my MDB database into an MDE file, but I received the error: "Microsoft Access was unable to create an MDE database." There weren't any other error messages. How can I find out what the problem is?

---

Convert an Access 2007 database to an earlier file format
If you created a database in the Microsoft Office Access 2007 (.accdb) file format, but you want to share the database with people who are using earlier versions of Access, in most cases, you can convert the database to an earlier file format by using the Save As command. This article provides the steps for converting a database to an earlier file format and discusses some of the factors that prevent you from converting a database. In this article: * Convert an Access 2007 database to an earlier file format * Factors that prevent conversion to an earlier file format

---

Converting an Access Database to ACCDE File Format
If you have created a Microsoft Access database application that you will be distributing, you will want to convert it to a format that will prevent users from copying or modifying the database’s functionality. This article will deal with how we can convert an Access database to an ACCDE file. Situations may arise where you need to quickly and securely distribute an Access database that also contains VBA code. While allowing the database to provide all the necessary functions, you also want to prevent users from viewing and modifying code or altering the design of forms and reports. Converting your database to an ACCDE file will help you to lock the code and disallow design modifications.

---

Create an Adobe PDF File From an Access Database
You need to share a Microsoft Access file with others, but not all of them are running Access. Converting it to a PDF file will not only compress it, it will allow those not using Access to view it. The process for doing this depends on the version of Access you use.

---

How to convert an MDE to an MDB
If you have written an MDB database file and you want other users to preform applications with it, then you can convert it into an MDE file. But now you want to convert it it back into an MDB file and you don't want to change any codes. This process is simple, keep reading to find out more.

---

Using Microsoft Access without Microsoft Access
How to Work with Microsoft Access even if it's not Installed. Microsoft Access is a very powerful database - so powerful that that a VBScript programmer doesn't even need to install it in order to use it. One of the exciting aspects of using Microsoft Access on a Windows XP or Vista computer is that Microsoft Access doesn't even have to be installed for it to be used. All that the computer user needs is a text editor and some VBScript code. By using VBScript the would be database designer can: * create a new database file (a .mdb file) * add tables to the database * update the contents of the database * run queries on the database The great thing is that they will not need to have any additional software in order to do all of this.

---

Access, Acwzmain.mde
I am tryting to install either office pro Access or office 200 Access. I get the same error with both. f:pfilesmsoffice1031Acwzmain.mde (make sure that the file exist and that you can access it). I went to Microsft and looked it up and it says it could be my virus scan. I went into Norton and look it out and I still get the error. Please help!!! I am using Windows XP pro.

---

Which file format should I use in Access 2007?
Microsoft Office Access 2007 introduces a new file format that uses the .accdb file extension. In addition, Office Access 2007 continues to provide some support for the file format used in earlier versions of Access. This article explains why you should use the new file format whenever possible, and why you might need to use the earlier version file format in some instances. You will also learn explicitly how to convert a database to the new file format. In this article * The new file format (.accdb) * The earlier version file format (.mdb) * Converting to the new file format

---

Automate the Build of Microsoft Access Applications
There are several tasks that usually should be performed before releasing a non-trivial Access application. Typically, this includes removing Access objects that are no longer required, compiling, compacting and repairing the database, and making an MDE file. With Access, even after following these steps, sometimes the resulting application file is larger than what you would get, if you had created a new Access application and re-imported all your objects into the new MDB. This article and code provides a means to automate this process, allowing the preparation and release of an Access application to be performed as part of a batch build script.

---

Preventing Changes to your Microsoft Access VBA Code
If your database contains Visual Basic for Applications (VBA) code procedures, you want to ensure that your users can't make changes unless authorised or qualified to do so. Access to the code can be prevented in a couple of different ways: Password protecting your VBA code.Saving the database as a Microsoft Database Executable (MDE) format.

---

Access 97: Converting to Access 2003
This document offers some tips on converting Access 97 databases to Access 2003. (pdf file, install Acrobat Reader to read this tutorial)

---

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.

---

Microsoft Access File Format
The newest version of Microsoft Access marks the introduction of a new file format which uses the file extension of .accdb. In addition to this new format, however, Microsoft Access 2007 continues to provide support for many of the file formats used in earlier versions of the database program. Even so, it is recommended that users of Access 2007 use the new .accdb file format whenever possible, in order to take advantage of the many new features and benefits it provides. The new .accdb file format includes a number of new product enhancements and features. When a new database is created using Access 2007, the file is saved as an .accdb file by default. This new file format should be used whenever possible since the format supports a number of new features and benefits, including multiple value fields and the addition of attachments in various formats.

---

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

---

Introduction to Microsoft Access
Microsoft Access is a computer application used to create and manage computer-based databases on desktop computers and/or on connected computers (a network). Microsoft Access can be used for personal information management (PIM), in a small business to organize and manage all data, or in an enterprise to communicate with servers. TOC: Microsoft Access Interface, Microsoft Access Database File, Overview of Database Objects, Microsoft Access Help.

---

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.

---

Convert a database to the Access 2007 file format
You can convert a database that was created by using Microsoft Office Access 2003, Access 2002, Access 2000, or Access 97 to the new Microsoft Office Access 2007 file format. You should use the new file format whenever possible because it supports new features, such as multivalued fields and attachments. However, a database in the new Access 2007 file format (.accdb) cannot be opened or linked to with earlier versions of Access, and the new format no longer supports replication or user-level security. If you need to use your Access 2007 database with earlier versions of Access, or if you need to use replication or user-level security, you must use a file format from an earlier version.

---

Connecting to Microsoft Access with ADO
Readers of this tutorial will learn how to make a Universal Data Link file which provides the basis for connecting to an MS Access database file. They will also go through the steps to be followed in writing VBA code to work with the database in accessing the Connection object. TOC: Connecting to Microsoft Access with ADO; Overview of ActiveX Data Objects; Create a UDL file to connect to an MDB file; Read the connection string from the file; Create a reference to ADO; Write code to open and close the ADODB connection to the database.

---

Compact and Repair a Microsoft Access Database Files
As you work on your database, particularly when developing it, the Microsoft Access file will grow and grow. Microsoft Access files never automatically get smaller, even when you have deleted data from them. As a database continues to grow, there may be errors that spring up along the way. As the database administrator, it will be your responsibility to manage these. When errors do occur in your database, they will take up valuable space and this may lead to performance issues.

---

Create a Report Snapshot in Microsoft Access
Microsoft Access is a popular database program. If you want to send an information file from an Access database and you know the recipient doesn't own Access, you still can send the file with a report snapshot. Report snapshot is a portable viewer that the client can use to open the file and view its contents.

---

MS Access Database
MS Access uses a simple, file based database and does not need any database server to be installed on client machine. Each database is stored as a single file. The extension of the MS Access database file is .MDB. All tables within the database are stored within teh same database file.

---

AutoExec Macro in Microsoft Access
In Microsoft Access you can use startup options to specify, for example, what form to display, whether toolbars can be customized, and whether shortcut menus are available in your Microsoft Access file. You can also use a special macro named AutoExec to carry out an action or series of actions when your database first opens. When you open a database, Microsoft Access looks for a macro with this name and, if it finds one, runs it automatically.

---

Control how an Access file looks and behaves when it opens
You can use startup options to specify, for example, what form to display, whether toolbars can be customized, and whether shortcut menus are available in your Microsoft Access file. You can also use a special macro named AutoExec to carry out an action or series of actions when your database first opens. When you open a database, Microsoft Access looks for a macro with this name and, if it finds one, runs it automatically.

---

Secure Microsoft Access Passwords and Encryption in Access 2007
Hello Microsoft Access fans and skeptics. In this article, I am going to describe how you can improve on what already is a very significant security improvement in Access 2007, database encryption. Microsoft Access 2007 introduced a new file format for storing Access database information. This file format can be identified by any file that ends with .ACCDB. Whilst Microsoft Access 2007 still supports the file type of .MDB, the future of Access is going to be built around the .ACCDB format. One of the most significant changes with the .ACCDB format is a new method of encryption that is based around the database password. This change is a very significant security improvement because encrypted ACCDB databases are (in theory) strong enough that they can only be cracked using very computer intensive brute-force password recovery. Of course, as with all security, if lots of people do things the same way the risk is far higher that someone will work out how to breach the security. This definitely will apply to encrypting an Access 2007 database because the default encryption algorithm used is RC4 with a 40-bit key, one that is not as strong as it could be. In this article I am going to show you how to make your password encrypted database more secure than the standard ACCDB encryption.

---

Defining the Scope of your Database
If you have been following these Microsoft Access Tutorials, you should now know how to create a database file, and have a broad understanding of good database design as it relates to table structure within Microsoft Access. We are now going to look at the theoretical design of the database that we will be working with throughout the rest of this tutorial.

---

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

---

Microsoft Access and HTML
Importing an HTML File: If you have a table on a web page and the table is well structured for a database, you can use it as a table of your database. That is, you can import it in Microsoft Access. Like a normal text file, a typical HTML document can contain anything. This means that you should not attempt to import just any HTML file into your database.

---

Error accessing file - or - This action will reset the current code in break mode
When you try to view the code for a Visual Basic for Applications module, compile a database, create an MDE file, or execute code in an Access 2000 database, you may see one of the following messages: "Error accessing file. Network connection may have been lost." "This action will reset the current code in break mode."

---

Basic Skills and Tools Using Access
1. Describe the primary functions using Microsoft Access. 2. Describe the steps for creating a new database file using Microsoft Access. 3. Describe the steps for creating and modifying a table and fields using Microsoft Access. 4. Describe the steps for creating relationships between tables using Microsoft Access. (pdf file).

---

Access 2000 Tutorial
Learning Objective: A few terms, Getting started, Blank Access database, Access database wizards, pages, and projects; Open an existing database, Converting to Access 2000

---

Save As Database Template Add-in
The Save As Database Template add-in allows you to convert an existing Microsoft Office Access database file to a database template (*.accdt) format file that can be featured on the Getting Started with Microsoft Office Access page.

---

Converting a Spreadsheet to a Database
Do you have an unwieldy Microsoft Excel spreadsheet that you'd like to convert to an Access database? This illustrated tutorial walks you through the process, step-by-step.

---

Microsoft Access Tutorial
Microsoft Access is a powerful program to create and manage your databases. Below shows the Hierarchy that Microsoft Access uses in breaking down a database. (pdf file, install Acrobat Reader to read this tutorial).

---

Change the default file format
When you create a new, blank database in Microsoft Office Access 2007, you are prompted to provide a name for the database file. By default, the file is given the ".accdb" extension - it is created in the Office Access 2007 format and is not readable by earlier versions of Access. In some cases, you may prefer to create files in an earlier Access format. In Office Access 2007, you have the option of creating files in either the Access 2000 format or the Access 2002-2003 format (both with the extension ".mdb"). Then, when you create a new database file, the resulting file is created in the earlier Access format and can be shared with others who use that version of Access. This can be helpful if you have upgraded to Office Access 2007 but you share files with others who have not.

---

Regarding queries in ms access, while converting to mysql
Currently I am working on a project to convert ms access back end to mysql back end. Front end is still going to be ms access. The backend which is currently held in ms access is a different file, meaning front and back ends aren't in one mdb. Now i heard alot of suggestions about converting access tables to mysql tables, but not much discussions are held about queries. My questions are: (1) I have around 30-40 queries , querying forms, subforms & reports. Should i convert them to mysql queries or should i just leave it the way it is. (2) Will converting queries to mysql queries increase/decrease the speed. (3) How efficient are ms access queries. i find them extremely friendly to work around and i can create any query using its design view or with sql very fast. (4) also off the topic are there any tools that can be used to show the time taken by each forms or queries to run and load in ms access...

---

How to Import Shapefiles into Microsoft Access
How to Import Shapefiles into Microsoft Access. This tutorial demonstrates how to import an ESRI shapefile into an Access database using the... (PDF file, install Acrobat Reader to read this file)

---

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.

---