[_] SQL / MS Access suggestion?
rick.hurst at gmail.com
Fri May 27 08:58:34 BST 2016
Aren't you allowed to install xampp on your machine or is it completely locked down? On Fri, May 27, 2016 at 7:01 AM, Paddy <paddy at creativemedia.org.uk> wrote: >>have you considered connecting to the access db via ODBC from php > > Thanks for reply: I'd *love* to do it in PHP, Rick, but as a lowly temp at > the university, I don't think I've got the clout to do this sort of thing. > As it is, I'm being sent an Excel export out of the original academic > database, importing it into my new Access one, exporting the queried report > as a PDF.... and probably the other schools are finding their own > solutions... all my system analysis senses are screaming "Wrong, WRONG!" :-( > > There's a lot to be said for working in smaller more flexible organisations. > > My solution (as long as I've got the data right) isn't too bad, but I've not > found a way to make MS Access add a Subject to the mailto hyperlink in my > report. > It's funny - I reluctantly learnt PHP and MySQL because Access wasn't > available on Mac Office back in the noughties, and now I'm finding Access > somewhat limiting! Though being able to paste great chunks of spreadsheets > into tables is very useful. > > > - Paddy > -- > underscore_ list info/archive -> > http://www.under-score.org.uk/mailman/listinfo/underscore -- Rick Hurst http://www.rickhurst.co.uk