dbTalk Databases Forums  

Upsizing Access to SQL Server 2000

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts


Discuss Upsizing Access to SQL Server 2000 in the microsoft.public.sqlserver.dts forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Joe
 
Posts: n/a

Default Upsizing Access to SQL Server 2000 - 02-16-2004 , 08:56 PM






Every time I use the upsizing wizard on Access 2003 in my new Access ADP database, I have one table in which I cannot add new rows. I think there is some kind of primary key issue preventing the addition of the new rows. The primary key is exactly the same in the other tables, and the table works fine the the Access mdb table. It happens everytime I upsize
What is going on
Thanks
Joe

Reply With Quote
  #2  
Old   
Mary Chipman
 
Posts: n/a

Default Re: Upsizing Access to SQL Server 2000 - 02-17-2004 , 05:51 AM






Open your table schema in a database diagram and make sure everything
is as it should be. The upsizing wizard doesn't do everything as you'd
expect, and in fact often requires considerable clean-up afterwards.

-- Mary
Microsoft Access Developer's Guide to SQL Server
http://www.amazon.com/exec/obidos/ASIN/0672319446

On Mon, 16 Feb 2004 18:56:05 -0800, Joe
<anonymous (AT) discussions (DOT) microsoft.com> wrote:

Quote:
Every time I use the upsizing wizard on Access 2003 in my new Access ADP database, I have one table in which I cannot add new rows. I think there is some kind of primary key issue preventing the addition of the new rows. The primary key is exactly the same in the other tables, and the table works fine the the Access mdb table. It happens everytime I upsize.
What is going on?
Thanks,
Joe


Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.