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
>>