Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access
Password Reminder
Register
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read
Access Discussion of Microsoft Access database design and programming. See also the forums for Access ASP and Access VBA.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access section of the Wrox Programmer to Programmer discussions. This is a community of tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old May 18th, 2004, 10:58 AM
Authorized User
 
Join Date: Mar 2004
Location: Knoxville, TN, USA.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Rood67
Default Connecting Access2000 to MySQL Database

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>
Reply With Quote
  #2 (permalink)  
Old May 19th, 2004, 06:21 AM
Friend of Wrox
Points: 9,611, Level: 42
Points: 9,611, Level: 42 Points: 9,611, Level: 42 Points: 9,611, Level: 42
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Mar 2004
Location: Washington, DC, USA.
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts
Default

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
Reply With Quote
  #3 (permalink)  
Old May 19th, 2004, 10:12 AM
Authorized User
 
Join Date: Mar 2004
Location: Knoxville, TN, USA.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Rood67
Default

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
Reply With Quote
  #4 (permalink)  
Old May 19th, 2004, 05:58 PM
Friend of Wrox
 
Join Date: Jun 2003
Location: Melbourne, Vic, Australia.
Posts: 308
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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
Reply With Quote
  #5 (permalink)  
Old May 20th, 2004, 12:49 PM
Authorized User
 
Join Date: Mar 2004
Location: Knoxville, TN, USA.
Posts: 26
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to Rood67
Default

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.
Reply With Quote
Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Help connecting to mysql database catalog ajrobson Servlets 0 December 28th, 2006 04:24 PM
Connecting to MySQL Database from VB2005 Tank Pro VB Databases 0 January 23rd, 2006 04:46 PM
Need Help Connecting to mySQL Database! jehchoi1 PHP Databases 6 April 21st, 2005 09:28 AM
database connecting with java &mysql rakeshkumar MySQL 1 February 4th, 2005 11:59 AM
problem with connecting asp with ms-access2000 ravinkumar Classic ASP Databases 2 September 12th, 2003 05:23 AM



All times are GMT -4. The time now is 06:56 PM.


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.