On 5/21/10 3:02 PM, Wade Preston Shearer wrote: > There is a member of our group that frequents the IRC channel that mentioned > that he uses Microsoft Access to read MySQL databases frequently at his place > of employment. I can't remember who that was. If it was you, would mind > emailing me? I have a few questions. > > If anyone else has experience with this, here is my question: > > I set up Microsoft Access for a client. It works great for them to read the > MySQL database. I set it up permissions on the MySQL account that they are > using to be read-only so that that it is only a reporting tool. The problem > is that with these permissions, there is no way to export the data. Microsoft > Access disabled copy-and-pasting or exporting to Excel. Is there any way to > set things up such that my client would be unable to modify the database but > would be able to run queries and export them?
If you set up the odbc connection to mysql then you can access that connection with excel as well and they can create queries right in excel and have the data there. If you have questions let me know. -- thebigdog _______________________________________________ UPHPU mailing list [email protected] http://uphpu.org/mailman/listinfo/uphpu IRC: #uphpu on irc.freenode.net
