Hello,

     What I am attempting to do, is generate a custom report using Access2000, from information stored in a MySQL database. The MySQL is located on a server here at my place of employment, and is used to track the start time, end time, and voice recording .wav file of our agents on the telephone (inbound/outbound callcenter for national company).

     I am able to connect to the MySQL database with no problems. I can link to tables within the database. However, here is where the problems begin.

     I can pull data from one table (users), but not a second table (recordings). All fields for all records show just fine for the users table, but everything shows as #Deleted from the recordings table.

     Anyone have any idea why? I connect to our Oracle database, and do not have this problem. The contents of the Oracle database tables are in the hundreds of thousands of records, where the MySQL is not. As I and another person thought this was the issue, of the tables being to large for Access to display. Didn't really make any sense, but it was a thought to finding a reason.

     Any and all help would be greatly appreciated.

Rood67
Scott H.

__________________
<b>Rood67</b>

Is the data really there in any other view? Otherwise this sounds like a rights issue. Are you the sa for the MySQL database? You may need to change your rights to that table.

mmcdonal

Thanks for the reply. Let me add, I know nothing about MySQL other than it's a "free" database that most people use on websites. Why in the name of all databases did the company we purchased our phone recording server and software use MySQL?!?!?!?!?

I and our lead IT person have downloaded and installed Jet4.0 updates from Microsoft. We have downloaded updated versions of the MyODBC drivers from the MySQL website. Nothing is helping.

You mentioned rights on the MySQL database. I have received the Root login information from our provider to be able to connect to the MySQL database at the highest level.

Now the kicker is that I can use the Oracle ODBC Connection test, and connect to the MySQL database, and run queries against the recordings table. I just cannot see the data if I use Access to connect and run a query.

The reason I need to use Access is so that I can run queries and reports against the live data. Not run a SQL script to generate a delimited text file, to then be imported into Access for processing.

So any clarification on your statements or any other ideas would be greatly appreciated. And any ideas from anyone, please.

Thanks,
Rood67
Scott H

Have you tried creating a view of your recordings table that doesn't have the WAV file itself in it?
It could be that Access doesn't like how the WAVs are kept, so by not including them, it might get around it.
Given that you can't put an audio file on a piece of paper (i.e. a report), there's no use returning it from the MySQL database.

Steven

I am a loud man with a very large hat. This means I am in charge

Hello all,

     I have found a work around to my problem. I have set up Access to run some queries as SQL Pass Through's and my other queries to pull from these.

     Annoying, but it works. So if anyone else runs into this type of a problem, this will work.

Rood67
Scott H.