Title: Searchable Database
Last modified: August 21, 2016

---

# Searchable Database

 *  [jimbabwe1](https://wordpress.org/support/users/jimbabwe1/)
 * (@jimbabwe1)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/searchable-database-2/)
 * Hi all,
 *  I am having a lot of difficulty in finding answers with searchable databases
   and hope someone here can help! My dilemma is the following:
 *  I have an MS access database that I want to place on the WP website… and make
   it searchable. This database contains a list of landlords in our county, property
   locations, etc. and we want case managers to be able to see which properties 
   are available to specific client criteria (criminal Hx, MH, etc.)
 *  I really appreciate any assistance that people can give on this!

Viewing 1 replies (of 1 total)

 *  [linux4me2](https://wordpress.org/support/users/linux4me2/)
 * (@linux4me2)
 * [12 years, 9 months ago](https://wordpress.org/support/topic/searchable-database-2/#post-3863900)
 * If you want to code it yourself, you can use [PHP PDO](http://us3.php.net/manual/en/book.pdo.php)
   and ODBC to connect to an MS Access database if you’re still going to be actively
   maintaining the database through MS Access. Of course, your MS Access database
   has to be on a server that is accessible to the web server where you run WordPress
   so that the database can be connected to.
 * This would be a fairly routine job for a developer with experience with PDO if
   your MS Access database is well-constructed; it can get really hairy if it’s 
   not. There are lots of examples of code for the connection and various basic 
   queries out there if you Google “php pdo odbc ms access” or something along those
   lines, but if you don’t have any experience with PHP and database access, you
   may want to invest in a developer.
 * If the data is no longer going to be maintained in MS Access, you could export
   the database structure/data from MS Access and import it into MySQL tables in
   WordPress’ database, then not have to worry about connecting to MS Access with
   PHP.
 * Either way, you’d probably write all your code in a custom template for WordPress,
   then create a page linked to the custom template to display the user interface/
   data you want.
 * The other thing you could look at would be a plugin that allows access to an 
   MS Access database, but I haven’t seen one, and in that case you might not get
   the kind of custom user interface you want.

Viewing 1 replies (of 1 total)

The topic ‘Searchable Database’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [searchable](https://wordpress.org/support/topic-tag/searchable/)

 * In: [Everything else WordPress](https://wordpress.org/support/forum/miscellaneous/)
 * 1 reply
 * 2 participants
 * Last reply from: [linux4me2](https://wordpress.org/support/users/linux4me2/)
 * Last activity: [12 years, 9 months ago](https://wordpress.org/support/topic/searchable-database-2/#post-3863900)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics