MS Access Database to Work With WordPress?

  • LandOfTheLost

    (@landofthelost)


    14 years, 9 months ago

    Hello,

    We have an existing organizational web site (not a WordPress site) that keeps track of membership information using an MS Access database. This allows people to view their membership information online, etc.

    We are going to redesign the web site using WordPress…a self-hosted WordPress site.

    Will we still be able to use the existing Access database? If so, how will we do that?

    And if not, is there a way to “convert” the data in the Access database into something the WordPress site can use?

    I’m sorry to say that I know nothing much at all about databases…I will appreciate any help or suggestions.

    Thank you.

Viewing 4 replies - 1 through 4 (of 4 total)
  • vtxyzzy

    (@vtxyzzy)

    14 years, 9 months ago

    IMHO, this could be quite a challenge. Access has built-in functionality for designing your own database tables and setting relationships among them. It makes it easy to view these tables for entry, updating, and reporting.

    WordPress does not have these functions – you must code them all yourself. The tables that WP provides are all predefined. There is no built-in mechanism for adding your own tables and viewing or reporting from them.

    If your Access DB is really simple, you might be able to use the PODS CMS Framework plugin to create and manage the tables. If there are complex relationships among the tables you will probably have to do everything from the ground up.

    Thread Starter LandOfTheLost

    (@landofthelost)

    14 years, 9 months ago

    vtxyzzy…thank you so much for your response.

    Of course I was hoping to get a response saying, “Yes this is easy to do…and here’s how to do it.” although I had a feeling that would not be the case.

    Although it’s not “good news,” it’s helpful to know that it’s not an easy job…and could be next to impossible.

    I’d welcome any further advice from you on this topic…thanks again for your help…I appreciate it.

    vtxyzzy

    (@vtxyzzy)

    14 years, 9 months ago

    Unfortunately, there is not much more I can say on the topic.

    I have worked with Access and with WP, but never together. I don’t know if there is another web platform that would be better suited than WP but you should research that aspect.

    Thread Starter LandOfTheLost

    (@landofthelost)

    14 years, 9 months ago

    Thanks again, vtxyzzy. I hope some day I can be able to answer a few questions here rather than just asking.

Viewing 4 replies - 1 through 4 (of 4 total)

The topic ‘MS Access Database to Work With WordPress?’ is closed to new replies.