Help needed with SQL...

Hi All, I'm having problems creating a query to return a recordset from the following situation: I have two tables, one which contains member details, and the other which contains details re: the groups to which the member belongs. When a member logs into a particular part of my site, I want to

Access XP crashes regularly when linked to MySQL via MyODBC

Hi All, My MySQL Server is 3.23.53-max-nt. I'm linking to it via MyODBC 3.51.05.00 and accessing its tables via Access XP linked tables. For some reason, Access XP crashes regularly in this setup. No meaningful error messages, just crashes and reloads after a repair. Even more odd (and I only

Workable solution: writing program to communicate with remote internet MySQL server

Hello All, Just thought I'd report back with what seems to be a simple, elegant solution to my previous inquiry re: writing a program to connect with the MySQL server that powers my internet site from my desktop PC. Yesterday I downloaded the latest release of PHP (ver 4.3.0) and, while reading

RE: Writing program to communicate with remote internet MySQL server?

you might achieve this on a local server using MyODBC? The end goal is to develop a program I can fire as a Windows XP scheduled task to synchronize the remote database with the local one. Any help appreciated! Regards and best wishes, M Wells

RE: solution for opposite of this join / join from this subselect

it can't be done, but I certainly can't think of a way to do it. All the best, M Wells [1] As a simple example of a 'find unmatched' query, if we had a table that contained a record for each of the files on your computer and a table of all of the files from your computer that you've backed up

Writing program to communicate with remote internet MySQL server?

server as though they were recordset objects, similarly to how you might achieve this on a local server using MyODBC? The end goal is to develop a program I can fire as a Windows XP scheduled task to synchronize the remote database with the local one. Any help appreciated! Regards and best wishes, M

RE: opposite of this join

Hi Josh, I'm hesitant to make the following suggestion, mainly because I'm not terribly clued up with SQL myself, however the following APPEARS to deliver something close to what you're looking for. It relies on breaking your recordsets into 3 tables, as your situation appears to already do, 1

RE: MySQL Database Design

Hi Brian, By no means am I a MySQL guru (or any other database server environment guru, for that matter), but could you simply have a reference table that indicates the percentage of the grape used in the relevant wine? So, you might have three tables, Wines, GrapeVariety,

RE: MySQL as a desktop DB

Hi Arthur, Which version of MySQL / MyODBC are you using? I tried building an app with an Acc2000 frontend and a MySQL backend using MyODBC and kept running into a problem where the record being edited would become 'locked' and wouldn't allow me to update (from memory it was something along the