We use an ODBC link as we can control the rights at the MySQL level like Tobin mentions below Susan Tobin Cataldo wrote: > We have been using MS Access linked through MyODBC. The user's rights > are according to the permissions in the MySQL user table. > > Tobin > > > Ken Irwin wrote: >> Hi folks, >> >> I have some straightforward MySQL data tables that I would like to be >> editable by some of my less-techy colleagues. I tend to think of >> phpMyAdmin as a perfectly serviceable and reasonably interface for >> updating database tables, but I'm told that it's kind of intimidating >> to the uninitiated. >> >> Are there alternatives that are meant for non-admin-types? I'd want >> something with read/write permissions, but that could be targeted at >> just a few tables, wouldn't have any of the more potent tools (drop, >> empty, etc.). In the ideal world, I might like something that would >> prevent users from doing things like accidentally changing primary >> key data and things like that. >> >> I've thought about writing something, but I suspect that would be >> reinventing the wheel. Any ideas? >> >> Thanks, >> Ken >>