> Hi
>
> We have a sophisticated Underwiting management system written in MS
> Access.
>
> The programs and the data are in separate mdb's.
>
> The time has come to improve the product's client/server and
> web strengths.
>
> We came across mysql whilst investigating MS SQL server.
>
> Can we upsize our Access database to mysql easily and continue to use
> the Access programs to work with the mysql data?
>
> Thank you
>
> Chris Needs & Peter Jacobsohn
> Telek Systems
>
Chris & Peter,
The code will work with slight modifications AS LONG AS the database doesn't
use subselects, stored procedures, stored queries, or (I just learned -
thanks, Will!) joins in updates or deletes. I had to convert a
'sophisticated' website from Access to MySQL about a year ago, and there are
many times that I felt I'd be better off recreating the database from
scratch. The sheer volume of data (and the extremely denormalized structure
of the original db) kept me from doing just that. There is no clear-cut
yes or no here. You will have to look closely at the code and the original
database. Yes, it can be done, but there is the possibility of a major
rewrite of your code.
Good Luck!
Jay Fesco
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
