tag:blogger.com,1999:blog-15319370.post113503730719875365..comments2024-03-29T12:51:32.931+01:00Comments on Roland Bouman's blog: 'Doing' MS Accessrpboumanhttp://www.blogger.com/profile/13365137747952711328noreply@blogger.comBlogger7125tag:blogger.com,1999:blog-15319370.post-65629073078187544402009-07-29T09:53:35.273+02:002009-07-29T09:53:35.273+02:00Sam,
in our case, the Access db was on the local...Sam, <br /><br />in our case, the Access db was on the local network. Unfortunately I lost track of this company, and I don't know if they were successful in the end in porting it.<br /><br />Would it be very hard to rebuild your app? How badly are you dependent upon MS Access? there are some tools out there like Wavemaker that are designed to offer the same easy development experience as MS Access.<br /><br />I hope this helps, sorry I couldnt answer your question directly.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-16284896582575641372009-07-29T06:33:13.252+02:002009-07-29T06:33:13.252+02:00Hi Roland,
The staff of my nonprofit has been usi...Hi Roland,<br /><br />The staff of my nonprofit has been using an MS Access database but given the geographically distributed nature of our staff, passing the database around is becoming unbearable. We don't have an intranet or a VPN, but we do have a dedicated LAMP web server. So, I thought we'd port the tables to MySQL and turn Access into an ODBC front-end for the data hosted in the MySQL server. Unfortunately, *everyone* has been warning us against doing that. This includes Microsoft/Access/VB developers and non-MS developers alike. They all claim that "it just doesn't work as advertised" and that they "have the scars to prove it." In your case, was this MySQL installation hosted locally or was it on an intranet or a remote server? Did you see any performance or other problems with multiple users? Is this sports clothing store still using this Access/MySQL solution? <br /><br />Any real-world guidance is very much appreciated as it is hard to find (unbiased anyway).Sam Hummelhttps://www.blogger.com/profile/14009873778989801142noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-67607013751093863832008-03-19T14:21:00.000+01:002008-03-19T14:21:00.000+01:00Hi Anonymous,let me see if I understand:1) you can...Hi Anonymous,<BR/><BR/>let me see if I understand:<BR/>1) you can't get it to work<BR/>2) so it must be the ODBC driver's fault<BR/><BR/>Well I'm sorry if it doesn't work for you. <BR/><BR/>Have you tried posting at the MySQL forums at forums.mysql.com? There is an ODBC and an Access forum there too so you should be able to find some help there.<BR/><BR/>Thank you so much for patiently putting up with all these awful tools, and good luck,<BR/><BR/>Rolandrpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-33416806189197090912008-03-19T14:10:00.000+01:002008-03-19T14:10:00.000+01:00I have done everything said herehttp://dev.mysql.c...I have done everything said here<BR/>http://dev.mysql.com/doc/refman/5.0/en/myodbc-usagenotes-apptips.html#myodbc-usagenotes-apptips-microsoft<BR/>and it still shows #deleted#<BR/><BR/>MySQL ODBC is really amateurish: I have never seen that with any other ODBC driver !Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-29850399544301832652007-02-05T19:53:00.000+01:002007-02-05T19:53:00.000+01:00Hi Anonymous,
thanks for spotting these! It's co...Hi Anonymous, <br /><br />thanks for spotting these! It's corrected now.rpboumanhttps://www.blogger.com/profile/13365137747952711328noreply@blogger.comtag:blogger.com,1999:blog-15319370.post-56797169748224116072007-02-05T17:33:00.000+01:002007-02-05T17:33:00.000+01:00Corrected some small typos . . .
alter table tabl...Corrected some small typos . . .<br /><br />alter table table1 add dummy timestamp default current_timestamp on update current_timestampAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-15319370.post-1153379173454245902006-07-20T09:06:00.000+02:002006-07-20T09:06:00.000+02:00Thanks for your advice. I have the same problems w...Thanks for your advice. I have the same problems with MS-Access and MySQL and i did not yet been successful although I had added the TIMESTAMP fields.<BR/>I shall try once more...<BR/><BR/>Kind regards<BR/><BR/>BeatAnonymousnoreply@blogger.com