Search found 6 matches
- 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: 96618
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...
- 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: 96618
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...
- Fri Jun 07, 2013 9:31 pm
- Forum: General
- Topic: Connection Error help please...
- Replies: 1
- Views: 78591
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...
- 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: 96618
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...
- Fri Jun 07, 2013 1:27 am
- Forum: General
- Topic: Bug with export indexes and select tables
- Replies: 2
- Views: 85167
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...
- 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: 96618
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...