I have been searching for information on how to connect to a database with FW Pro but can only find examples of using MySQL in PHP. The db in question is an Access db resident on the web site. Can someone point me in the right direction?
Thanks
As far as I know, there aren’t any Actions for Access. There are ways to access Access from PHP, using the ADODB abstraction layer, and you’ll find lots of links about that if you Google those terms. But there isn’t anything you could use to do all this in Freeway without writing any code.
If you have the opportunity to do so, though, you should really move away from Access, as it is just about the same thing performance-wise as a flat text file (which is actually what it is). Meaning, only one person can touch the data file at a time, so you’ll have race conditions galore, or just blocked access and error messages galore, if your traffic rises over say one person per minute.