Web Wiz Support and Community Forums : Access to SQL conversion error https://forums.webwiz.net/ Copyright (c) 2006-2013 Web Wiz Forums - All Rights Reserved. Sat, 04 Apr 2026 17:34:18 +0000 Wed, 03 Nov 2004 10:29:47 +0000 http://blogs.law.harvard.edu/tech/rss Web Wiz Forums 12.08 360 https://forums.webwiz.net/RSS_post_feed.asp?TID=12426 <![CDATA[Web Wiz Support and Community Forums]]> https://forums.webwiz.net/forum_images/web_wiz_forums.png https://forums.webwiz.net/ <![CDATA[Access to SQL conversion error : michael wrote:a blank database...]]> https://forums.webwiz.net/access-to-sql-conversion-error_topic12426_post68903.html#68903 Author: Emiliano
Subject: 12426
Posted: 03 November 2004 at 10:29am

Originally posted by michael michael wrote:

a blank database already has guest and administrator, so in oder to "overwrite" those enable identity insert and delete all records when using DT

Yep! I just did it this weekend and it's exactly what michael wrote!

You should delete all records from the newly created tables (some of them are created with some records), enable identity insert and follow a logical order! For example, if you delete the records from tblGroup, you should insert the new group records before inserting the users...

This error you got must have occurred because of the default Administrator and Guest accounts...

]]> Wed, 03 Nov 2004 10:29:47 +0000 https://forums.webwiz.net/access-to-sql-conversion-error_topic12426_post68903.html#68903 <![CDATA[Access to SQL conversion error : most of the time you have that...]]> https://forums.webwiz.net/access-to-sql-conversion-error_topic12426_post68902.html#68902 Author: michael
Subject: 12426
Posted: 03 November 2004 at 9:40am

most of the time you have that problem if you do not enable identity insert, a blank database already has guest and administrator, so in oder to "overwrite" those enable identity insert and delete all records when using DT]]> Wed, 03 Nov 2004 09:40:31 +0000 https://forums.webwiz.net/access-to-sql-conversion-error_topic12426_post68902.html#68902 <![CDATA[Access to SQL conversion error : There shouldn&#039;t be, but check...]]> https://forums.webwiz.net/access-to-sql-conversion-error_topic12426_post68895.html#68895 Author: WebWiz-Bruce
Subject: 12426
Posted: 03 November 2004 at 4:13am

There shouldn't be, but check that only the ID field, username, and user_code fields are set to unquie.

Also check you haven't got two users with the same username.
]]> Wed, 03 Nov 2004 04:13:42 +0000 https://forums.webwiz.net/access-to-sql-conversion-error_topic12426_post68895.html#68895 <![CDATA[Access to SQL conversion error : When converting from Access to...]]> https://forums.webwiz.net/access-to-sql-conversion-error_topic12426_post68894.html#68894 Author: oweh
Subject: 12426
Posted: 03 November 2004 at 3:41am

When converting from Access to SQL using DTE i get some errors.

For example one row fails in tblAuthor with the error message:
Cannot insert duplicate key in object 'tblAuthor'

Is there some tables i SQL database that doesent allow duplicate keys that Access does?

 

]]> Wed, 03 Nov 2004 03:41:06 +0000 https://forums.webwiz.net/access-to-sql-conversion-error_topic12426_post68894.html#68894