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.

---

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.

---

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.

---

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?

---

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.

---

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

---

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

---

Compact an Access Database with VBS Script
If you have worked with Microsoft Access databases for any length of time, you have no doubt noticed that the mdb file itself tends to bloat as you work with it. Every time you open a form or report in design mode, the mdb file grows. Each time you add records to a table or create a temporary table, the mdb file grows. And contrary to what you might expect, closing or deleting objects and deleting records does not "shrink" the database. Those actions merely make shrinking the mdb file possible. The actual shrinking is done by executing a DAO (Data Access Objects) Method named CompactDatabase.

---

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.

---

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.

---

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.

---

Control whether some or all of the built-in menus are displayed
If the Microsoft Access file you're creating provides the user access to the built-in menus, you can choose to display only a predefined subset of the menus. That way, you can hide menus, such as View and Insert, that would enable a user to access the Design view of objects in your Access database or Access project and to change their design.

---

Outputting one HTML file per record in an Access database
There are several ways to make your Access data available on the Web. Usually, Access displays more than one record per Web page. For example, when you create a data access page, you can browse and modify all records in the record set from one Web page. Or, when you output a datasheet to an HTML or XML file, all the records are formatted as one HTML table. However, there are times when you want to output one HTML file per record. Learn: Why output one HTML file per record in an Access database? How many ways in Access can I output one HTML file per record? Use a report to output one HTML file per record. Use the VBA PRINT statement to output one HTML file per record.

---

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.

---

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

---

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.

---

Introduction to the Access 2007 file format
Microsoft Office Access 2007 creates files in a new file format that cannot be opened with earlier versions of Access. This article describes the new features of the Office Access 2007 file format, reviews some issues that arise when you convert to earlier file formats, and summarizes how some related file types have changed from earlier versions. In this article: * New features of the Access 2007 file format * Conversion to earlier file formats * File types * Linked tables * Replication

---

Access 2003: Advanced Tables Design View
Learn advanced table features using Design View in Access 2003. (pdf file, install Acrobat Reader to read this tutorial)

---

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.

---

Flat File Database Design vs. Relational Database Design
A flat file database is a database designed around a single table. The flat file design puts all database information in one table, or list, with fields to represent all parameters. A flat file may contain many fields, often, with duplicate data that are prone to data corruption. If you decide to merge data between two flat files, you need to copy and paste relevant information from one file to the other.

---

Making .exe from MS Access
I just made some forms and reports on MS access and want to make an exe file out of every form..like i want to make a working software/program that doesnt run under ms access.

---

You must install the Microsoft Access 2.0 Converter in order to convert this file
When you open a file in Access 2.0 file format in Access 2003, you are prompted to install the Access 2.0 Converter. This issue occurs because you have to install additional files that are not installed by Access 2003 to open or to convert an Access 2.0 database file.

---

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.

---

Access 2007 Deciding Whether to Change Database Formats
The newest version of Access, Microsoft Access 2007, marks the end of the old familiar .mdb file format, replaced with the .accdb file extension. It is important for Access users to become familiar with the new format in order to be able to make an informed decision of how, and whether, to transition older databases into the new .accdb format.

---

Self Help Documents: Microsoft Access
Topics: understand and create database, import and export data, sort and filter tables, insert graphics, queries, reports, forms, advance table design view, understand relationship and learn how to connect through an ODBC to make tables that you can manipulate in Access. (Download all these tutorial in pdf file format).

---

getting data from a Microsoft Access DB (.mdb file)
I need to write a script that queries a MS Access database (in a .mdb file). The file itself is sitting on the Linux box which this script will be running from. The program that uses the DB runs on a Windows box and accesses the .mdb file via a samba share. What are my options for accessing this DB from the Linux side? Can I read from the .mdb file directly with some module? Can I use DBD::ODBC to access the DB across the network?

---

Access 2003: Advanced Queries: Design View
Learn how to use Design View to run advanced queries in Access 2003. (pdf file, install Acrobat Reader to read this tutorial)

---

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.

---

Troubleshoot saving files
When I save a file, it is saved with an additional file name extension. When I try to save changes to a file, I get a message saying the file is read-only. The file I saved contains two periods in the file name. I entered my username and password but I still can't access a network drive. When I save a file, I get a message saying there is insufficient disk space or memory.

---

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.

---

MS-Access Common Dialog API
How do I put a button on a Microsoft Access form which will allow the user to look up a file. I want to be able to lookup and insert a image file. I need to be able to press the button and look for a file either with windows explorer or the Microsoft Office file lookup window?

---

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.

---

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.

---

Developer Considerations for Choosing File Formats in Access 2007
Find out when you should use the new .accdb file format in Microsoft Office Access 2007 and when you should use the earlier .mdb file format. Access 2007 introduces the new .accdb file format, which supports several improvements in the product, including multivalued fields, the new Attachment data type, better integration with Windows SharePoint Services and Office Outlook 2007, history tracking in Memo fields, and encryption improvements. This article describes when you should use the new .accdb file format and when you should use the earlier .mdb file format.

---

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.

---

Restore a database
To restore a database, you must already have a backup copy of your database. A backup is commonly referred to as a "known good copy" of a database file — a copy in which you are confident of its data integrity and design. You should use the Back Up Database command in Microsoft Office Access to make backups, but you can use any known good copy to restore a database. For example, you can restore a database from a copy that is stored on a USB external backup device. You can restore an entire database, or you can selectively restore objects in a database. If you do not have a backup copy, you risk data loss and unwanted changes to or corruption of your database design. For this reason, you should make backups on a regular basis.

---

File Browser (Common Dialog Control)
SEARCHING FOR OTHER FILES FROM MS ACCESS: How to Browse for Folders or Files from MS-Access? If we can, then what do we do with the File(s) we bring into Access. Well, you can copy it from one place to the other for an example. Anyway let us get to work with the first part.

---

Access 2003: Data Entry and Forms
Learn how to build forms in Access to enter your data into tables without having to go into the Design View. (pdf file, install Acrobat Reader to read this tutorial)

---