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?

---

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.

---

Importing Data into MS Access with ODBC
Learn how to: import data with ODBC; establish a link to a database file; configure an ODBC Source; configure the new data source to MSDE; import the tables from MSDE and compare imported table with original table.

---

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?

---

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.

---

From DAO to ADO
When you migrate Access data to SQL Server, you have two choices with Access 2000 and only one with other versions. With previous versions of Access, you will link SQL Server tables, using ODBC, to your Access database. With Access 2000, you can either link the table using ODBC or decide to take profit of the new Access Project file (.adp) using OLE-DB. In the link option, your Access-VBA code remains in DAO, but need to be adapted to the newly ODBC-linked tables. In the project option, you DAO code needs to be modified in ADO.

---

Troubleshoot importing and linking
The Get External Data command is disabled. I get an error message saying the wizard is not installed or is disabled. I started the wizard, but it disappeared. What do I do? I don't see Microsoft Excel listed in the Files of Type box. I get an error saying Access cannot import data from my file. The option to append data to an existing table is disabled when importing a spreadsheet. I am importing data from a spreadsheet, but I cannot specify field options for any field other than the first.I get errors when I import or link to a spreadsheet or text file, or the data doesn't get imported (or linked to) properly. Importing a text file is taking a long time. I get errors when I append data to a spreadsheet or text file. Some field values appear truncated in a linked table. I get the Numeric field overflow message when I query a linked table. I can't open or update a linked Microsoft Visual FoxPro or dBASE table. I can't open or update a linked Paradox table. I can't open or update a linked SQL table. I get a key violation message. I imported a file and Access says it created a Tablename$_ImportErrors table. I'm trying to import or link data from my security-enabled database. File extensions don't show up beside the file names in the Files Of Type dialog box. I get an "ODBC - connection to datasourcename failed" message when I open a table or form in a converted database.

---

Connecting MS Access to SQL Servers through ODBC
Once you got a DSN defined in the ODBC manager that connects to your SQL Server, you can connect a normal MS Access document to the Oracle server, and link an Access table to a SQL Server table.

---

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.

---

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.

---

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.

---

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.

---

What to do when you see file names instead of images in your Access database
I upgraded from Access 2000 or Access 2002 to Access 2003, and now instead of seeing images, I see file names. What's up?

---

JDBC-ODBC - Creating New Tables in MS Access Database
This section describes how to create a new table in a MS Access database through the JDBC-ODBC driver.

---

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.

---

TransferText Macro Action
You can use the TransferText action to import or export text between the current Microsoft Office Access 2007 database (.mdb or .accdb) or Access project (.adp) and a text file. You can also link the data in a text file to the current Access database. With a linked text file, you can view the text data with Access while still allowing complete access to the data from your word processing program. You can also import from, export to, and link to a table or list in an HTML file (*.html).

---

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.

---

Differences between ODBC drivers and built-in drivers for external data
In Microsoft Access, you can import, export or link data from a number of different database, spreadsheet, and text file formats. To do this, Access uses either a built-in driver or an ODBC driver.

---

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

---

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.

---

TableInfo() function
How to list a table schema in a Microsoft Access database, showing the field names, types, size, and descriptions. Includes code to give the field type names.

---

How to open .mdb file
I have been sent a microsoft office access database file but I do not have Access on my computer. How can I open this file?

---

Administer ODBC data sources
Open Database Connectivity (ODBC) is a protocol that you can use to connect a Microsoft Access database to an external data source such as Microsoft SQL Server. This article contains general information about ODBC data sources, how to create them, and how to connect to them by using Microsoft Office Access 2007. The procedure steps might vary depending on the specific database products and ODBC drivers used.

---

TransferDatabase Macro Action
You can use the TransferDatabase action to import or export data between the current Access database (.mdb or .accdb) or Access project (.adp) and another database. For Microsoft Office Access 2007 databases, you can also link a table to the current Access database from another database. With a linked table, you have access to the table's data while the table itself remains in the other database.

---

JDBC-ODBC Bridge Driver
This chapter provides tutorial notes on using the JDBC-ODBC Bridge driver with MS Access database. Topics include creating MS Access database file; creating DSN for MS Access database files; inserting rows to and retrieving rows from Access database.

---

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

---

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.

---

HELP - MS Access not working
Works find local. Not in "production" when live site. I use godaddy. I have MS Access enabled. THe file is in the app_data folder. All looks right. I originally had godaddy set up a DSN, and then I removed it. Do I need to have a connection string in web.config to use Access? I though just having the .mdb file in App_Data was enough. HELP, I have people using it now and it does now work.

---

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

---

A Simple Query
By creating a simple query in MS Access, you can display field information in various ways. For example, suppose you have one table that contains extensive information about of all of your business contacts. However, for now, you just want to see the names in the list. By using a simple query, you could view a column containing names only. These instructions apply to MS Access 97.

---

ACCDB File Format
The ACCDB database file format was introduced with the release of Microsoft Access 2007 to replace the older MDB file format. The use of ACCDB format allows users to leverage enhanced functionality in Access, including the use of multivalued fields and strong cryptography.

---

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)

---

Loading MS ACCESS to Oracle
Is it possible to upload MS Access (*.mdb) using Informatica PC 6.2 while file is still on unix.

---

MS-Access Object Documenter
We normally prepare Reports on processed or raw data and take print outs to share the information with others. But, there are times that we need details of the database Objects: Tables, Queries, and Scripts (Macros) or VB Modules and other objects. We can take detail listing of Objects, like Table Fields and their Properties, Data Types and Sizes or the Control Names on Forms/Reports and their properties, User-Level & Group-Level Permission Settings and so on. We will take a listing of a Table with Field Names, Data Type, Size of each field and the Index information. I have used the Employees Table for our example, but you can try this with any Table in your Database.

---

MSysConf table to optimize your linked SQL database (MDB)
If you are administering an SQL database that uses Microsoft Access as a front end, then you can create a table in your SQL database named MSysConf to help you control communication between the two applications. Learn: The structure of the MSysConf table, The data in the MSysConf table.

---

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.

---

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.

---

Source ConnectStr Property and ODBC
The best way to learn and understand more about the Connection String Syntax of different ODBC Data Sources is to go through the following steps and look at the Connection String of the Linked Table:

---

Importing and linking
There are a number of different ways to create and populate a table: -Create the table definition from scratch and then populate the table manually with data values; -Create the table definition from scratch and then append data from some other electronic format to the table; -Import the table definition and data from another database or application (such as MICROSOFT EXCEL or a text file); -Create a link to an external data source. In this case, the data is not actually stored in your database file, but is accessible from within ACCESS like any other table. (pdf file, install Acrobat Reader to read this tutorial)

---

Create a Microsoft Access Query That Uses More Than One Table
You can use queries to display information from a combination of tables. For example, suppose you have one table that lists the books available in a library. A second table contains information about the registered users. By creating a query based on both tables, you could retrieve a listing of each book along with the name of the person who has the book on loan. These instructions apply to MS Access 97.

---