Search found 6 matches

by cove3
Sat Jun 08, 2013 2:04 pm
Forum: General
Topic: Error: There can be only one auto column & must be a key
Replies: 1
Views: 83154

Re: Error: There can be only one auto column & must be a ke

Jacob, I looked at the dump created by Oracles Workbench in migrating from MS SQL to MYSQL. As I mentioned, I migrated my Access tables to a MS SQL Express server on my notebook pc, so I had the tables migrated and wanted to see how Workbench would do the migrate. Workbench does not have a direct Ac...
by cove3
Sat Jun 08, 2013 12:14 pm
Forum: General
Topic: Error: There can be only one auto column & must be a key
Replies: 1
Views: 83154

Re: Error: There can be only one auto column & must be a ke

Jacob, further testing with my tiny test_be.mdb database. Unchecking the create index box creates and index for the primary key field, but not the indices for the other two fields. It creates no PRIMARY KEY command and no UNIQUE commands, but it does run and upload. I'm not sure why since MYSQL seem...
by cove3
Fri Jun 07, 2013 9:31 pm
Forum: General
Topic: Connection Error help please...
Replies: 0
Views: 67044

Re: Connection Error help please...

1. Use Admin Tools/ODBC to test connecton 2. Be sure your hosting MYSQL has enable remote connections checked 3. Make sure your sign in has full priviliges for the database 4. Check if your hosting MYSQL has drop database disabled. If anything is wrong with the script, my x10 host gives a access den...
by cove3
Fri Jun 07, 2013 8:56 pm
Forum: General
Topic: Error: There can be only one auto column & must be a key
Replies: 1
Views: 83154

Re: Error: There can be only one auto column & must be a ke

Hi Jacob....I can't find a contact form. Clicking on JR has word contact, but it's not a link. I'm at cove3@aol.com I can confirm the following from working with Bullzip off and on for a couple of days: 1. I set up a small Access 2007 test.mdb with a couple of columns and two records. Primary key on...
by cove3
Fri Jun 07, 2013 1:27 am
Forum: General
Topic: Bug with export indexes and select tables
Replies: 0
Views: 72945

Re: Bug with export indexes and select tables

Bullzip isn't generating any INDEX or UNIQUE commands for my tables, even though the check mark says to transfer indices and I have numerous indexes in my back end tables. It's also not generating a PRIMARY KEY command for my tables, resulting in a MYSQL error. I'm continuing to work with it as a re...
by cove3
Tue Jun 04, 2013 12:41 am
Forum: General
Topic: Error: There can be only one auto column & must be a key
Replies: 1
Views: 83154

Error: There can be only one auto column & must be a key

In trying to upload 3 tables from Access 2007 to a remote SQL host at x10, I connect ok, but if I leave all the default checks intact, I upload no tables and get a message "There can be only one auto column and it must be defined as a primary key. All three tables have only one field defined as auto...