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.

---

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 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?

---

Converting a Microsoft Access Database to an MDE File
The situation may arise when you quickly need to secure and distribute a Microsoft Access database that also contains Microsoft Access VBA code. You will protect the database from editing by restricting the database users access to the design views, however you will need to allow the users to process their data as normal. It may be that you haven't got the time to fully create Microsoft Access User Accounts or to set Microsoft Access Security Permissions. By knowing what can and cannot be done by using the Microsoft Access MDE file format, will allow you to make a decision and to quickly release a secure database to the users.

---

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.

---

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.

---

Save and Retrieve Datasheet Layout with the Windows Registry
Danny Lesandrini shares a block of code that will allow users to modify (and save) datasheet layout when they are using a compiled MDE version of your Access applications.

---

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.

---

Preparing Your Access 2003 Database for Deployment, Part 2
While planning and creating your Access application, there are decisions to make and additional options to consider when preparing for deployment. This is part two of a two-part series designed to help you prepare your database application for release. When creating an application for deployment, setting startup options allows you to customize the appearance of what your user sees when starting the application. Setting security prior to deployment helps protect the application from unauthorized users. Packaging your product with the Access run-time components provides a royalty-free method of running Access on you user's computers. In addition, by saving the file as an .mde file, you can help protect your code and other objects from undesirable access. Further, creating a setup package using the Package Wizard addresses many details for you. Planning and developing your application while remembering these and the other considerations discussed in this article helps to make the process of developing your application an enjoyable one, and helps to provide your customer with a professional and easy-to-use product.

---

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."

---

Create your own wizards, builders, and add-ins
To develop your own add-in(wizard, builder, or menu add-in), you can set several database properties and create a USysRegInfo table in the add-in database (*.mda, *.mde) so that it can be installed by using the Add-in Manager. You can also develop a COM add-in that can be installed by the Add-in Manager.

---

Microsoft Access Viewlets
Using the Blank Database Wizard in Access. Change Properties for Table Fields in Access. Using the Selection Filter in Access. Using the Report Wizard in Access. Creating an Input Mask in Access. Deleting and adding a Table Field in Access. Creating a Relationship Between Two Tables in Access. Sorting a Table Using Multiple Columns in Access. Freezing and Unfreezing Columns in Access. Sorting a Table in Access. Creating a Simple Query in Access. Navigating Through Table Data in Access. Hiding and Unhiding Columns in Access. Building and Applying a Sort Filter in Access. Searching For and Replacing Text in an Access Table. Automatically adding Date and Time to Access form

---

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

---

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

---

Getting Started with Access
Access provides a powerful yet comfortable environment in which you can manage your information. Using Access, you can tame even the most difficult data-management tasks. This tutorial is the first step in your journey. Here you will learn basic terms, as well as how to start and exit Access. You will also learn how to get help and even catch a glimpse of what you can do with Access.

---

No Access license on this machine - message when I start Access
When you start Access 95 or Access 97, do you see a message about your computer not having an Access license? This could be because Access is not registered properly on your computer. The problem is often caused by installing Access 97 and Access 2000 on the same computer.

---

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

---

VB6 With Access
Microsoft Access may be the most powerful programming tool available for Visual Basic. While nearly everything Access does can be accomplished with Visual Basic code (there are exceptions), Access makes most design tasks so much simpler that I consider having a copy of Access as much a necessity for database development as a keyboard.

---

Need Access Help
Can anyone help me with 2 questions? I taught myself Microsoft access and can't figure 2 things out... 1. How can I make the startup screen of access be maximized at the beginning? (When I start it up it goes thru the process of a regular access project. I don't want to see the tool bar or anything. I would like the screen to take up the whole area instead.) 2. How can I make it so another users use it if they don't have access on their computer?

---

Getting started with Access 2007
There are several ways that you can get started with Microsoft Office Access 2007, depending on whether you are using Access for the first time, moving data from another database or spreadsheet program into Access, or upgrading from a previous version of Access. This article covers questions that are likely to arise in each of these situations.

---

Delphi 6 and MS Access Reports
This may sound like a weird question but I am wondering whether anyone has been able to trigger an MS Access Report from Delphi 6. I am trying to port an Access "application/database" into Delphi 6 and, while I can replicate (and even improve upon) the Access Forms, The first phase of this task is going to get a lot more complicated if I have to also duplicate the various reports that are already available in the Access database. So, what I would really like to do is to interface the Delphi application to the MS Access database in a manner that would allow me to initiate the existing Access Reports.

---

Introduction to Microsoft Access 2003
Our goal is to assist you to learn the software, understand some basic concepts and show you some tips and techniques so you can develop your database management skills over time. The five workshops are: Introduction to Access; Access Queries; Access Reports; Access Database Design; Access Form Design. (pdf file, install to Acrobat Reader to read this tutorial).

---

MS access 2000
I am currently running xp professional with MS Access 2002. My problem is that I'm currently taking a class in MS Access 2000 and the requirement is that I must use MS Access 2000 not 2002. I don't want to spend big dollars on a a version of Access that's not current so what do I do? Any suggestions would greatly be appreciated.

---

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.

---

Creating Forms in Microsoft Access 2007
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn't always an appropriate tool for every data entry situation. If you're working with users you don't want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we'll walk through the process of creating an Access form. This tutorial walks through the process of creating forms in Access 2007. If you're using an earlier version of Access, read our Access 2003 forms tutorial.

---

Microsoft Access Custom Form Navigation
Customising Microsoft Access forms, adding your own menus and command buttons is part of creating a Microsoft Access database application and designing an Access graphical user interface. Microsoft Access forms can contain the built in Access navigation buttons and record counter, or you may wish to add your own.

---

Access Database Manipulation via JDBC
This will teach you how to connect to a Microsoft Access database. It's also a great overview of JDBC. Once you are connected, you may run any SQL statement that is allowable on Access, such as SELECT, etc. You don't even have to have MS Access installed to run this tutorial - it shows you how to make a blank one without Access!

---

Working with Access Projects in Access 2007
Microsoft Access 2007 features significant differences from earlier versions. One of these is the lack of support for data access pages. Projects become important in this environment. This tutorial will show you how to create an Access project and more. TOC: Working with Access Projects in Access 2007; Creating an MS Access 2007 Project; Creating a Stored Procedure in the Project; Stored Procedure in SQL Server.

---

Whats New In Access 2003
If you're upgrading from either Access 2000 or Access 2002 to Access 2003, you're in luckin most respects, Access 2003 looks and works almost the same as both Access 2000 and Access 2002.

---

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.

---

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.

---

MS Access Tutorial - Forms
Access provides an easy way to enter data into your Access tables with forms. In Access you have the ability to quickly make and customize these data entry forms to streamline the data input process. Learning how to properly create an Access form will save you a great deal of time!

---

Add an Item to the Quick Access Toolbar in Microsoft Access
The Quick Access Toolbar provides you with immediate access to commonly used functions in Microsoft Access 2007. In this tutorial, we explore the process of adding your own favorite icons to the Quick Access toolbar, step-by-step.

---

Basics for Building Microsoft Office Access 2003 Runtime-Based Solutions
How to use the Microsoft Office Access 2003 Runtime with the Microsoft Access 2003 Developer Extensions so users without Microsoft Access 2003 installed can still use Access-based applications. If you are creating an application that runs in an Access Runtime environment, you must carefully consider how to provide an interface for the user. You must also consider the fact that some users may own the correct version of Access and run the application in a full Access environment. Take care to test your application under both environments to make sure it properly balances usability in the Access Runtime environment with code security in a full Access environment.

---

Access 2002
Microsoft Access is a relational database package that runs under Windows on microcomputers. This tutorial was prepared using Access 2002. Before using this tutorial, you should know the fundamentals of Microsoft Access and know how to use Windows. This tutorial teaches you some more-advanced Access skills you'll need to do database case studies. The tutorial concludes with a discussion of common Access problems and how to solve them.

---

Create an Access 2007 Form
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn't always an appropriate tool for every data entry situation. If you're working with users you don't want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we'll walk through the process of creating an Access form.

---

Password Protecting A Microsoft Access Tab Control
Situations may arise where you need to ensure that some of your database users do not have access to certain information in your Microsoft Access forms. The way that you have designed your Microsoft Access User Interface will determine how you approach this. The following tutorial details how to password protect a tab contained in a Microsoft Access tab control, to only allow access to those with a valid password.

---

Creating Forms in Microsoft Access 2007
Although Access provides a convenient spreadsheet-style datasheet view for entering data, it isn't always an appropriate tool for every data entry situation. If you're working with users you don't want to expose to the inner workings of Access, you may choose to use Access forms to create a more user-friendly experience. In this tutorial, we'll walk through the process of creating an Access form.

---

Microsoft Access Introduction
Microsoft Access is a powerful program to create and manage your databases. It has many built in features to assist you in constructing and viewing your information. Access is much more involved and is a more genuine database application than other programs such as Microsoft Works. This tutorial will help you get started with Microsoft Access and may solve some of your problems, but it is a very good idea to use the Help Files that come with Microsoft Access, or go to Microsoft's web site located at for further assistance.

---