access query using mysql ODBC connection

[BJZeak]

We have been given read only permission to access live data from a 3rd party Mysql db to help close a business process loop so was hoping someone may have a solution on how to query this db silently (not requireing a user to manualy enter the ODBC DSN/user/pw)

Connecting to MySql 5 on a Linux machine from an XP Pro machine with Access 2k3 across a local 100Mb network

Created a DSN in odbc admin with ODBC mysql driver 3.5x

I can link the tables but the moment I attempt to browse them with a query all I get is #deleted in all the record fields

The Access 97 faq states the linked tables may need the Key fields defined in Access ... not sure how to do this as linked table properties cannot be changed

I went online looking for #deleted and the 2 things I came away with are that this may be a speed issue (no resolution) ... or ... to use a SQL Pass through Query

The Pass Through Query does give me data but it requires manually connecting to the server every time its run which is undersireable

 

[BJZeak]

I have found another online discussion stating the issue is probably due to BIGINT fields being used as the Primary Keys

As I have no control over how this third party schema is built I then assume Access cannot be used to get data from these tables?

If this is the case is there another way to get this data? ie another SQL processor that I could call from our ACCESS front end to provide us with the data?

 

[BJZeak]

Solved using ADO connect