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.

---

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 Microsoft Access .mdb files to XML
YeoSoft MDB to XML Converter is designed to help you publish your Microsoft Access database files (Microsoft Access .mdb) to the web with there quick and easy-to-use mdb to xml conversion, featuring xsl style sheet support.

---

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.

---

Convert databases from MS Access to MySQL
Access2MySQL Pro Convertor is a program which provides you with the opportunity to perform MS Access (mdb) to MySQL and MySQL to Microsoft Access database conversions, simply by having several wizard-like configurated options within the application. Convert your databases using professional conversion tools.

---

Convert a Database to Access 2007 Format
The ACCDB database format introduced in Access 2007 provides a number of enhanced features over the older MDB format. In this article, we'll walk you through the process of converting an MDB format database to the new ACCDB 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, 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 get table names from ms access(mdb file) by using odbc library.
I am writing a c++ program get the data from mdb file using odbc library. By the way, I couldn't get table list from mdb file. I already wrote a lot of part of this program so i don't want to switch database library. And the query gives "no read permission on 'MSysObjects' " error message. If you know how to get the table list from a mdb file by using odbc library, please share your experience.

---

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

---

How to convert my MS Access file to Application?
Anyone can help me convert or set my .mdb with form in ms access file to an application? i mean an application open the interface(form) without open microsoft access.

---

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.

---

Access File Formats: ACCDB vs MDB
The release of Access 2007 brings a new file format. The MDB database files we've known for over a decade are now slated to become historical relics. While Access 2007 continues to support MDB databases for backwards compatibility purposes, Microsoft has now introduced the new ACCDB file format as the future standard. Wondering if you should begin using the ACCDB format?

---

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.

---

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.

---

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

---

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

---

MDB File
MDB is the file format used by Microsoft Access XP and earlier versions. It was replaced by the ACCDB format with the release of Microsoft Access 2007.

---

Export All VBA Code
Microsoft Access database developers often want to keep their VBA code backed up separately from their MDB files, so that when a disaster befalls the database file, the lost or corrupted MDB file doesn't mean that the hard work invested in developing the code for that database application is gone forever, too.

---

Specify the default language sort order (MDB)
How to specify the default language sort order (MDB) in Access 2003.

---

Convert Old Version Databases
When upgrading from Microsoft Access 95 or 97, you need to convert your secured database, but you don't need to convert the workgroup information file to use it with Microsoft Access 2000. However, you should compact the workgroup information file before using it.

---

Create a field to store hyperlinks (MDB)
Learn to create a field to store hyperlinks (MDB).

---

Convert Numbers to Dates
Learn how to convert numbers into date (video tutorial).

---

Split your Access database into data and application
Even if all your data is in Access itself, consider using linked tables. Store all the data tables in one MDB or ACCDB file - the data file - and the remaining objects (queries, forms, reports, macros, and modules) in a second MDB - the application file. In multi-user situations, each user receives a local copy of the application file, linked to the tables in the single remote data file.

---

Set options for a shared Access database (MDB)
Learn how to set options for a shared Access database (MDB).

---

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.

---

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

---

View, refresh, or change the file name and path for linked tables (MDB)
Learn how to view, refresh, or change the file name and path for linked tables (MDB).

---

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.

---

Ways to work with SQL Server data in Access
One of the many strengths of Access is that it works well with a wide variety of databases and file formats, including Microsoft SQL Server data. There are five main ways to work with SQL Server data in Access. 1)Create an Access project 2)Create a data access page 3)Create an Office Web Component 4)Link SQL Server tables from an Access database (.mdb) 5)Import SQL Server data into an Access database (.mdb)

---

Change the font in SQL and query Design View (MDB)
How to change the font in SQL and query Design View (MDB).

---

Microsoft Access, Help Connecting to a FTP server
I am trying to figure out how to access a database on a FTP server that requires a username and password while using only microsoft access. The files that are on the database are in a .mdb file format which is what access uses. Currently I can connect to the ftp server and view the .mdb files using a cruddy third party vendor software that has no options for reports or sorting (which happens to be why i need to figure out how to connect to the server with Access). I know all of the information such as the ip address, username, password, port etc.... that is required to connect.... i just dont know "how to connect" using Access. Any help would be appreciated.

---

How to Convert a Database to Access Format
Access is a popuular Microsoft database program, designed to quickly gather and manipulate information. Access features a greater range of database objects than many of its competitors, as well as the ability to convert databases by importing them into Access. Here's how to do it.

---

Convert Numbers to Dates in Microsoft Access
If you have ever received a database from someone that has dates stored as six-digit numbers, like 990104, this lesson will teach you how to convert those to proper Access dates.

---

Convert MS Access to MySQL
I always wanted to convert my access db to MySQL to access it easier on the internet. i used access for my vb programming. i couldn't use mysql. now i needed the exact db for MySQL. A lot of converters only converted first 5 rows of each table so i had to do it all my self. this tutorial is for windows users.

---

Reading the Catalog (.psa) in MS Access
I discovered today that the Photoshop Elements 4 catalog is simply a Microsoft Access database with the extension renamed from .mdb to .psa. You can copy your catalog file to another directory (make sure Photoshop is closed first), change the extension to .mdb, double click on it, and voila, MS Access comes up with the catalog open as a database, with 12 tables. Of course, you must have Microsoft Access installed to do this. Since you're working with a COPY of the catalog file, no damage can occur. Now why would you want to do this? Well, I'm not sure yet, but as a software developer, I might think of some interesting reports or searches. You might want to set up a report using SQL capabilities that are more sophisticated than the standard Photoshop searching. It's always nice to have the option...... In the mean time, I need to get back to the tutorials so I can understand white balance, color balance, histograms, and levels better.....

---

Convert Old Version Workgroup File
Convert workgroup information file from a previous version of Microsoft Access.

---

Convert Access Database to Excel
A very common question many people have when learning Access is "how do I convert an Access database to an Excel spreadsheet?".

---

Error message: Microsoft Access couldn't print your object
This article applies to a Microsoft Access database (.accdb and .mdb) and to a Microsoft Access project (.adp). This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp). When you try to preview or print a report in Microsoft Access, you receive the following error message: Microsoft Access couldn't print your object. Make sure that the specified printer is available.

---