CMS Made Simple Forums

We have a site running on CMSMS, with a number of Sign-up forms etc. Data from these forms are sent via e-mail, and thereafter processed manually.

We'd like to automate the processing and grab the data at an earlier stage, i.e. from the db. We have a Microsoft Access db, that already performs a lot of such related work. I'd like to link some tables from the CMSMS-db to some tables in Access. I have scoured the docs for CMSMS, but cannot find any info about how to get into the db - I 'll probably need to set up some user, and password. Then I should be able to link the tables via ODBC

I have probably missed the relevant manual pages, so any pointers would be appreciated.

You will need to write a UDT for the interaction. There is nothing in CMSms for it you will have to make it from scratch in php.

Jeff wrote:You will need to write a UDT for the interaction. There is nothing in CMSms for it you will have to make it from scratch in php.

Huh? Why do I need to make a UDT (not even sure what that is) just to link a table via ODBC for read-only access from Microsoft Access?

Any other bids? Would it cause any problems to READ data via ODBC?

To moderator: I think this is the only location your rules allow for this question, but do let me know if I could place this question in any more prominent place. TIA.