Recent content by DwayneC

Banana, I think the problem is solved -- and I can't thank you enough for all your help! One of the marvelous things about the net is being able to focus more than one mind on a problem. As I suspected from the beginning, it turned out to be something incredibly simple. My primary key is an...

Banana, MyODBC 5.1 produces the same results. Also, Open Office Base works perfectly, although slowly, with either version. I will grind through the document you suggested to see if there is anything else. I really appreciate your help in solving this problem!

Whoops, my eyes are getting tired. I will try the 5.1 MyODBC later and see what happens. Yes, I can edit from Access -- I changed a couple of records and checked back online to see if they were changed correctly. There are two date fields that are in M/D/YYYY format, and they look ok. They...

When I first started down this slippery slope 2 or 3 weeks ago, I first tried to download and install 5.1 on my local system. I can't remember the problem now, but I could never get it to install, gave up, and went to 5.0 Here is the info on what I am using: Enter password: ********* Welcome...

When I try to open the table, all cells show up as deleted, and I can't seem to edit anything.

No problem -- I was able to execute the revised statement -- but here is the result: Primary key already exists. (Error 3283)Primary key already exists. (Error 3283) You are attempting to define a second primary key for this table. Each table can have only one primary key. Remove the...

Thanks for your patience. I am connecting to my website host, Bluehost, and have set up MySQL ODBC 3.51 Driver as a System DSN, BluehostODBC, with port 3306. The following are enabled under the Flags 1 tab: Return Matching Rows Allow Big Results Change BIGINT column to INT Enable Auto...

Banana, thanks for the response. I already have a primary key in the MySQL table. However, when I actually import the file instead of linking to it, and then look at the design view, it is not shown as a primary key. In fact, NONE of the indexed fields are shown as being indexed. On the...

I have spent many hours over the past two or three weeks trying to use MySQL on a remote server as the back-end of a database and Microsoft Access as the front-end on local desktops or laptops. The main table I want to store on the remote host has almost 1000000 records, and even zipped exceeds...