Database question

I’m running a website for my R/C aircraft club. One thing I need to do is print membership cards for current members. I have created a MS Access 2010 database to do this, and I’m using your export feature to keep that database current with the website database. I’m running into a problem when there different changes in both databases (ex: someone sends in an application by US mail and someone else applies online) I can’t import anything to either without erasing data. So far we have been manually entering the data into both databases. Is there a way I can automate the synchronizong and connect Access to the s2member database on my website and it understand the layout etc.? Or would anyone have a different solution to my problem? . Thanks

• This topic was modified 4 years, 3 months ago by  Sean Hodgson.

Hi Sean.

I’m really not familiar at all with MS Access. Maybe you can have it connect regularly (with a cron job) through a script to the WP database to query the users? That way you can make the script output the data in the format that MS Access needs it.