| Author |
Users accessing MySQL
|
|
|
| I have a Samba server set up in an all Windows network and 2003 AD domain.
The server works and I can see the shares...no problem there.
I also have MySQL up and running and know how to populate the databases
manually and do queries and so forth.
But what is the best way for users to access the data and add data in a
MySQL database without having to know all the commands?
| |
|
| CJ wrote:
>
> what is the best way for users to access the data and add data
> in a MySQL database without having to know all the commands?
A client application of some kind, I suppose...
Cheers,
NC
| |
| HawkEye 2005-03-02, 8:56 pm |
| CJ wrote:
> I have a Samba server set up in an all Windows network and 2003 AD domain.
> The server works and I can see the shares...no problem there.
>
> I also have MySQL up and running and know how to populate the databases
> manually and do queries and so forth.
>
> But what is the best way for users to access the data and add data in a
> MySQL database without having to know all the commands?
>
>
Get the MyODBC connector (from MySQL themselves I believe) and then
configure Access or whatever other front end you prefer to talk through it.
--
Regards
Neil
Registered Linux User 324599
Who is General Failure, and why is he reading my Hard Drive?
| |
| Bill Karwin 2005-03-02, 8:56 pm |
| HawkEye wrote:
> Get the MyODBC connector (from MySQL themselves I believe) and then
> configure Access or whatever other front end you prefer to talk through it.
Yes, I was going to suggest the same thing, write a simple data entry
form in MS Access and use "linked tables" or whatever Access calls them
to have the data posted to the back-end database via ODBC.
See:
http://dev.mysql.com/doc/mysql/en/mysql-connectors.html
http://dev.mysql.com/doc/mysql/en/msaccess.html
Regards,
Bill K.
|
|
|
|