error while working with MySQL MyODBC and MS Access 97

2004-08-06 Thread Joshua Bacher
hi their, i have a problem working with access mysql and myodbc. i ported a access database to mysql. now i had to integrate the mysql db in the old access frontend. i realized this with linked tables. now i have a problem, because myodbc seems to return the wrong results. the relation between

MySQL, MyODBC and MS Access

2002-04-22 Thread hobos
Hello! You are my last chance, reading FAQs and asking in newsgroups gives no effect. I have a problem when connecting a MySQL table in MS Access (2000) through MyODBC. MySQL is ver. 3.23.44 running on FreeBSD 4.5 box. Description of the problem: I connect the table and Access correctly

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

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
:[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 ACCESS db and MySQL. I have read some pretty good documentation and know that is possible to take an existing Access db and export it to MYSQL

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
Subject: MySQL, MyODBC and MS Access I have a project where I may need to connect an MS ACCESS db and MySQL. I have read some pretty good documentation and know that is possible to take an existing Access db and export it to MYSQL. I have a few questions and wondered if someone might offer some

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

MySQL, MyODBC and MS Access

2002-03-21 Thread Mark Stringham
I have a project where I may need to connect an MS ACCESS db and MySQL. I have read some pretty good documentation and know that is possible to take an existing Access db and export it to MYSQL. I have a few questions and wondered if someone might offer some insight. 1. Where must the Access db