RE: MySQL, MyODBC and MS Access

2002-04-22 Thread Venu
Hi !! -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, April 21, 2002 11:52 PM To: [EMAIL PROTECTED] Subject: MySQL, MyODBC and MS Access Hello! You are my last chance, reading FAQs and asking in newsgroups gives no effect. I have a

RE: MySQL, MyODBC and MS Access

2002-03-25 Thread Chuck Roberts
-Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 2:51 PM To: Chuck Roberts Cc: Mysql; Mark Stringham Subject: RE: MySQL, MyODBC and MS Access Chuck - I am looking for a way for both MS access and MySQL to share realtime data so

RE: MySQL, MyODBC and MS Access

2002-03-23 Thread Alexander Shaw
This seems to be a very common question that appears very frequently on the group, in fact one I have asked in the past too. Could I stick my head over the parapet and suggest a person or persons with experience of Access front ends and MySQL backend puts together an FAQ for this, or better

RE: MySQL, MyODBC and MS Access

2002-03-23 Thread Venu
Hi ! -Original Message- From: Alexander Shaw [mailto:[EMAIL PROTECTED]] Sent: Saturday, March 23, 2002 11:19 PM To: MySQL List Subject: RE: MySQL, MyODBC and MS Access This seems to be a very common question that appears very frequently on the group, in fact one I have asked

RE: MySQL, MyODBC and MS Access

2002-03-22 Thread Andrew Hazen
There might be a better way but here's a suggestion: When I needed to switch from an Access db to mysql I couldn't find any docs about exporting the table structures from Access to mysql, so I documented the Access db and manually built the same table structures in mysql. Then export the Access

Re: MySQL, MyODBC and MS Access

2002-03-22 Thread jake williamson 28
hello mark, been doing this quite a bit recently but i cheat a bit... 1st step is to export the table from access as a text file - delimited by comma's. if you load up phpMyAdmin (available at http://www.phpwizard.net/projects/phpMyAdmin/), create your database and then mimic the table set up

RE: MySQL, MyODBC and MS Access

2002-03-22 Thread Chuck Roberts
I'm doing something similar, with an Access front-end and mysql back-end. -Original Message- From: Mark Stringham [mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 3:11 AM To: MySQL Subject: MySQL, MyODBC and MS Access I have a project where I may need to connect an MS

RE: MySQL, MyODBC and MS Access

2002-03-22 Thread Mark Stringham
Chuck - I am looking for a way for both MS access and MySQL to share realtime data so that if someone where to insert (through a web based admin) or update table in a MySQL db you could open your Access db and see the same data. I don't know if it is possible but that way there wouldn't be an

RE: MySQL, MyODBC and MS Access

2002-03-22 Thread Todd Williamsen
[mailto:[EMAIL PROTECTED]] Sent: Friday, March 22, 2002 1:51 PM To: Chuck Roberts Cc: Mysql; Mark Stringham Subject: RE: MySQL, MyODBC and MS Access Chuck - I am looking for a way for both MS access and MySQL to share realtime data so that if someone where to insert (through a web based admin