ODBC link to MySQL, can write, but not edit or delete

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I have a MySQL database on a server in our shop, which I'm running through
an ODBC link. Very simple table (experimental part of a larger project), one
text field, the primary key. I have two queries, one which loads the table,
one which clears it. The load runs fine, shovels in around 300 records with
nary a peep. But the delete query fails, as does VBA code with error 3027
when I try to clear it again, or even execute rst.Edit. I have to log onto
the server and run a query directly in MySQL to empty the table. I've looked
at all the permissions I can find and all are set to unrestricted access.

What I have, seemingly, is a write-only-once table. I can add records, but
not edit or delete them. Anybody?

Pete


--
This e-mail address is fake, to keep spammers and their address harvesters
out of my hair. If you want to get in touch personally, I am 'pdanes' and I
use yahoo mail. But please use the newsgroup when possible, so that all may
benefit from the exchange of ideas.


.

Relevant Pages

  • Re: Simple network layout design questions
    ... I actually like the WINS server (but wish to separate the requirements ... As to seeing negligible loads, this is becoming the standard case since ... broadcast domain cover just about every case these days. ... and even those that could create an LMHosts file would not want to do so, ...
    (microsoft.public.windows.server.active_directory)
  • Re: Hit counter problem
    ... |> You are using a Hit counter - every time the page is downloaded from ... |> the server the counter will increment. ... |> Using the Back button loads the page from computer memory, ... |> load from the browser Cache if the page is in the cache, ...
    (microsoft.public.frontpage.programming)
  • Re: Server comments
    ... Most of our systems are disc bound. ... (reservations and related info) ... sounds like you are getting just amazing service from your server. ... I don't doubt that there are application loads which warrant ...
    (Ubuntu)
  • Re: Hit counter problem
    ... You are using a Hit counter - every time the page is downloaded from ... the server the counter will increment. ... Using the Back button loads the page from computer memory, ... > increment again if the 'Home' button is used. ...
    (microsoft.public.frontpage.programming)
  • Re: OWA slow from outside on SBS 2K3
    ... 3.- I click the "refresh" button on the browser and the page loads ... now the tree loads but not the other two frames. ... RDP to the server and check email that way, than going through the web on ...
    (microsoft.public.windows.server.sbs)