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 |