Answer for:

How do I run Access as an Administrator?

Message 5 of 6

View entire thread
0 Votes

Yes, they do differ (host/username/pass combo). But MyODBC drivers are identical, and both my PHP apps and Heidi SQL connect fine whereas Access wont. It was very frustrating, but it is less so now as I have a local webserver at home with the data mirrored on it and Access happily connects across my network so all is well. I can develop my SQL on that and it works when I embed that into my PHP scripts. It's less of a frustration and more of a minor annoyance now. And (as my friend points out) I use MS software so I'm used to minor annoyances :)