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

---

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.

---

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?

---

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?

---

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.

---

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.

---

Copy files to a CD
As more and more computers come standard with a CD-ROM drive, burning your data onto a CD makes sense and is replacing floppy disks as the removable media people use to create backup copies and to share files with other people. For example, you might want to burn a CD to preserve the digital photographs you took on vacation instead of taking up precious space on your hard drive. Or you might want to keep a digital record of your house inventory on a CD and store that CD in a safety deposit box. The reasons for putting your data on a CD are endless.

---

Use files from other Office programs in your Access forms and reports
Using files from other Office programs The concepts you must understand in order to use files correctly, such as whether to link or embed them, and whether to use bound or unbound files. It also briefly explains OLE (Object Linking and Embedding), the technology that some Access components use to store and display files. Storing files in a database How to add fields to your database tables and either link to or embed file data in those fields. Adding unbound files to forms and reports How to add files that remain fixed as you move through the records in a database or the pages in a report. Adding bound files to forms and reports How to add files that change as you move through the records in a database or the pages in a report. Updating and editing links and files How to update links to your files, display updated files automatically and manually, and edit files in Access. Solving common display problems What to do when you see file names instead of the files themselves, and "Package" in your table fields instead of a specific Office file type.

---

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.

---

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.

---

Transforming XML files with XSLT in Access
In this article, we introduced the XSLT and XSL languages and described their file structures and a few processing instructions. We discussed their use in transforming XML data files from one format to another. We also looked at output of the default XSLT style sheet used in Internet Explorer and two of our own custom XSLT files. Hopefully, these concepts will provide a starting point for building your own XSLT and XSL files and using them in your own applications.

---

Using Text Files with Microsoft Access
Microsoft Access through VBA makes it easy for us to interact with the system files. In this article we will explore how to manipulate text files through Microsoft Access. To use files with Access we will have to use the file system object or FSO.

---

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

---

Set the number of files shown in the list of recently used files
When you start Microsoft Access, when you click New on the File menu, or when you click File on the menu bar, a list of the most recently used files appears. You can click a file name in this list to open the file with the same option settings it had the last time you opened it. You can also change the number of file names that appear on the list of recently used files.

---

Customize the list of recently used files
Many Microsoft Office programs display the last few files you opened in that program. You can use the links on this list to quickly access files. This feature is turned on by default, but you can turn it off, turn it back on, or adjust the number of files that it displays. If this feature was turned off and you subsequently turn it back on, only the files that you open and save after you turn it on are listed. If you close a file, and then move it to another location, such as by using Windows Explorer, the link to that file in the program in which you created it no longer works. You must use the Open dialog box to browse to the file to open it. After you save the file in its new location, that link is added to the list.

---

MS Access JET TMP Files
I have just taken over supporting a very badly designed system which manipulates massive MS Access tables. I'm told that I need to watch out because it creates quite large jet*.tmp files and there is an upper limit. I am trying to find out what the upper limit size for these files is so that I can see how long I've got.

---

Security Considerations and Guidance for Access 2007
Find out how you can use Access 2007 to protect the information in your databases. Learn about encrypting files, administering passwords, converting databases to the new ACCDB and ACCDE formats, and using other security options such as SQL Server.

---

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?

---

External Files List in Hyperlinks
Is it possible to display a directory listing of External Files on a Form and open them in their parent applications?

---

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.

---

About finding files
You can use the File Search command in Microsoft Office 2003 to find files wherever you work: on your computer hard drive, your local network, your Microsoft Outlook mailbox, and your network places. You can also find e-mail messages, meetings, and other information in your Outlook mailbox. Search provides two methods of finding files: basic search and advanced search.

---

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.

---

Attach files and graphics to the records in your database
You use the Attachment feature in Microsoft Office Access 2007 to add one or more pieces of data - Microsoft Office Word 2007 documents, Microsoft Office PowerPoint 2007 presentations, images, and so on - to the records in your database. This article provides the background information and steps needed to configure a database to use attachments, and to attach and manage data. In this article: * Why should I use attachments? * Add an attachment field to a table * Attach files directly to tables * Use attachments with forms and reports * Save attached files to other locations * Remove attached files * Use attachments without a mouse or other pointing device * Attachments reference

---

Add a place to store your files
The My Places bar is on the left side of some dialog boxes, such as Save As, Open, and Insert Picture, that allows you to specify a folder where you want to store your files. You can use the My Places bar to help save time getting to your folders and help make it easier to access your files in your various folders. After you update the My Places bar in one dialog box, the changes are available in the other dialog boxes with the My Places bar.

---

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.

---

List files recursively
This article illustrates how to list files recursively in VBA. Output can be listed to the immediate window or displayed in a list box.

---

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.

---

Print, share, and protect files in the PDF and XPS file formats
Often you want to save your files so they cannot be modified, but you want them to be easy to share and print. Examples include resumes, legal documents, newsletters, and files intended to be read and printed. PDF and XPS formats can help. What do you want to do? * Learn about PDF and XPS file formats * Install and use the Save as PDF or XPS add-in from Microsoft * Install a third-party solution

---

Display Excel Value directly on Form
We have already seen how to open dBase Files directly and work with the data in VBA in the earlier Post Opening dBase File Directly. But, there are other alternatives (besides linking the files) to work with dBase Files in Access. We will explore this aspect in detail later. This Post was originally intended for a demo of opening Excel based Data Table directly and working with it in VBA Code. We will do that in the next Post. Before that we will look into some interesting and very easy trick with Excel.

---

Select multiple files
How to select and open multiple files at once using Microsoft Office Access.

---

Split an Access database (MDB)
You can split a Microsoft Access database into two files: one that contains the tables and one that contains the queries, forms, reports, macros, modules, and shortcuts to data access pages. This way, users who need to access the data can customize their own forms, reports, pages, and other objects while maintaining a single source of data on the network.

---

Export Access Data to XML Format
XML is a very simple and efficient way to exchange data between different computer programs. More and more companies choose to use XML files to move data back and forth, rather than using the Microsoft Access 2007 files. Most often you'll be asked to send a XML file, which is easier to integrate with other reporting programs, rather than the high specialized .ACCDB database format. In case the entire idea of using XML files scares you, then you have to know this: you don't exactly need to know how XML looks like or works in order to use it. So, fear not the technology, just follow the instructions and Microsoft Access 2007 will produce the XML file for you.

---

Why zip a file?
Zipping a file creates a compressed version of the file that is considerably smaller than the original file. The zipped version of the file has a .zip file extension. For example, if you zip a Microsoft Office Word document called Government Proposal.doc that is 6.5 megabytes (MB) in size, the file created, Government Proposal.zip, is reduced to 2.5 MB. File types that are reduced the most as a result of zipping are text-oriented file types, such as .txt, .doc, .xls, and graphics files that use non-compressed file types such as .bmp. Some graphic files, such as .jpg and .gif files, already use compression; therefore, the file size is reduced very little by zipping. Also, a Word document that is full of graphics files does not get reduced as much as a document that is mostly text.

---

Reading Access Databases with PHP and PECL
In this article, I'll introduce you to PHP's MDBTools extension, which provides an API to programmatically read data from Microsoft Access database files. If your project involves working with such files, extracting database records either for calculations or for conversion to other formats, you'll find this extension invaluable. Come on in, and see how it works!

---

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.

---

Troubleshoot HTML formatted files
Problems: My server-generated HTML files do not appear as expected when I display them in a Web browser. I can't open a file on the Internet. I want to open an HTML file in Access, but it opens in another Office program. I get an error message when I try to import or link to data on a FTP or HTTP Server.

---

ReportML in Access
In Access 2002 or later, you can now export Access objects as Extensible Markup Language (XML) files that make them easier to share between applications. Access datasheets, forms, and reports can be exported using either one or two XML files. Learn: What is ReportML? Structure of a ReportML document. Example of an Access form and subform in ReportML. Additional information about ReportML. Saving a ReportML file.

---