MYSQL Data Entry Form

Richard Hubbard rhubby at yahoo.com
Mon Jul 25 15:32:42 EDT 2005


For things like Data Entry, you can always have  MS
Access link to MySQL tables. Then you hand the users
the MS Access MDB file and (provided you are pointing
to a machine they can get to) they can access the
files.

With not much work you can also set up a custom
program in (gasp...arrgh...cough) Visual Basic.  The
Data Form wizard is almost painless.  (If you need any
extra work, though VB is a nightmare to code in).


--- Justin Bennett <Justin.Bennett at dynabrade.com>
wrote:

> Ok, Thanks for the info. Gives me a good route to
> go, I'm compiling 
> MYSQL now, I want to see if the webmin module is
> decent for it, if not I 
> may go the access route.
> 
> Justin Bennett
> Network Administrator
> Dynabrade, Inc.
> 8989 Sheridan Dr.
> Clarence, NY 14031
>  
> 
> 
> 
> On 7/25/2005 3:16 PM, Mike Richardson wrote:
> 
> > Justin Bennett wrote:
> >
> >> Thanks, I hope it doesn't come to that, not a big
> odbc fan.. Seems 
> >> flaky every time i've used it.
> >>
> >> But thanks for the tip.
> >
> >
> > Just to ease your mind:
> >
> > We've been using the MySQL odbc connector for
> about 2 1/2 years with 
> > no noticable incidents.
> >
> >> On 7/25/2005 2:54 PM, Mike Richardson wrote:
> >>
> >>> Justin Bennett wrote:
> >>>
> >>>> I'm looking to deploy a mysql database for web
> work via PHP (our 
> >>>> stuff has been oracle so far).
> >>>>
> >>>> What I'm looking for is an easy way a windows
> user could update, 
> >>>> delete, insert, data into the database. I'm not
> looking to make the 
> >>>> user upload a csv or anything like that to
> update records.
> >>>>
> >>>> A nice GUI data entry form would be nice. I
> could always write one 
> >>>> in PHP but was hoping for something canned,
> maybe with a wizard so 
> >>>> I could create more forms in the future. It
> doesn't need to be web 
> >>>> based, it can run on w32, and it doesn't have
> to be free.
> >>>
> >>>
> >>>
> >>>
> >>> Although it's not necessarially being developed
> (or even supported) 
> >>> anymore, MySQL Control Center has always been a
> good data 
> >>> manipulation tool. It may be a little confusing
> for the general 
> >>> user, though.
> >>>
> >>> Otherwise, if your clients have MS Access
> installed, you can install 
> >>> the  MySQL ODBC connector on Windows. In Access,
> you can link tables 
> >>> up to the MySQL db and let them edit data there.
> >>>
> >>> Both of these pieces of software are available
> of MySQL's Developer 
> >>> site. http://dev.mysql.com/downloads/
> >>>
> >>> *shutters* I just promoted an MS product for
> getting things done...
> >>>
> >>>
> >>
> >>
> >
> >
> 


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around 
http://mail.yahoo.com 



More information about the nflug mailing list