see embedded comments
bastien
From: "Perry, Matthew (Fire Marshal's Office)" <Matthew.Perry@xxxxxxxxxxxx> To: php-db@xxxxxxxxxxxxx Subject: RE: mysql to access Date: Fri, 17 Dec 2004 10:25:09 -0600
Here is the problem:
I am currently using MySQL and PHP for this application but have realized recently that the bulk of my work is setting up three forms (add, view, modify) for each table I create. It takes hours for each table with MySQL and PHP but takes only minutes with Access. Also, other office administrators have been trained in Access instead of MySQL and will not be able to update my tables directly or set up new forms if I only use MySQL and PHP.
Add / Edit should be the same page. You can add a little code to make some field uneditable if they should not be. You need to find ways to speed up the process. There is code available that will take your table structure and dump all the fields and sql statements, to initialize the variables with defaults. (get it here (http://www.weberdev.com/get_example-3978.html)). Then its mainly a matter of creating the forms and plugging it all together. Using a web form is even easier than using an access form, since all the code for menus and stuff is hiddedn away and links and form provide the navigation
On the other hand, PHP and ASP are easier and more flexible with user control options. Also, directly entering SQL can be much more efficient than using Access's embedded SQL applications.
The other thing is that to install this based on browser technology (ie ASP/PHP) you only need to install in one place, on the server. Otherwise you'll need to install it on every computer where the user is (time, travel and VERSIONING considerations here). Its easy and quicker to make those changes on a webserver than going around to all the users and making sure that they use the correct access application.
I really would like to exploit the advantages of both databases but do not know the best means by which to do this. We are creating a standard that will be followed by everyone in our department and need the best and most efficient solution possible. People move around from different positions constantly and it seems we are making radical changes to our system every year. Here are three questions with which I still need help:
1) Would it really make sense to split the data management between two linked databases (Access and MySQL) or would this just cause problems?
NO SPLITTING!!!!! Splitting the data is askng for a data management nightmare. Synchronicity will become a major problem as data changes in one place and not another.
2) If I must use Access, should I use ASP(grrr) instead of PHP?
DO NOT USE ACCESS, its not nearly robust enought to handle the application, lack of ability to handle multiple users, security etc
3) If I must use Access, should I use MS SQL Server(grrr) instead of MySQL?
not unless you have big dollars to spend? Its just not worth it.
Thank you all for your time and patience.
- Matthew
-----Original Message----- From: Bastien Koert [mailto:bastien_k@xxxxxxxxxxx] Sent: Friday, December 17, 2004 10:01 AM To: Matthew.Perry@xxxxxxxxxxxx Subject: RE: mysql to access
it would depend on what you need the app to do...if you are looking to use access to do reporting and/ or act as a front end, then it may be feasible...
more details, if you care to share them, may help in this consideration
bastien
>From: "Perry, Matthew (Fire Marshal's Office)" <Matthew.Perry@xxxxxxxxxxxx>
>To: "Bastien Koert" <bastien_k@xxxxxxxxxxx>
>Subject: RE: mysql to access
>Date: Fri, 17 Dec 2004 09:59:25 -0600
>
>You mean link the tables? I haven't yet considered this.
>- Matthew
>
>-----Original Message-----
>From: Bastien Koert [mailto:bastien_k@xxxxxxxxxxx]
>Sent: Friday, December 17, 2004 9:42 AM
>To: Matthew.Perry@xxxxxxxxxxxx; php-db@xxxxxxxxxxxxx
>Subject: RE: mysql to access
>
>why not just link the mysql to access?
>
>bastien
>
> >From: "Perry, Matthew (Fire Marshal's Office)"
><Matthew.Perry@xxxxxxxxxxxx>
> >To: php-db@xxxxxxxxxxxxx
> >Subject: mysql to access
> >Date: Fri, 17 Dec 2004 09:33:39 -0600
> >
> >Does anyone know of a FREE program that exports MySQL to access? The
>trial
> >versions of the ones I have downloaded do not export all the records of
>the
> >database.
> >
> >- Matthew
> >
>
>
>
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
-- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php
