Append Data to a SQL Server 2005 table

[Kiwiman]

Hi

I am using Access 2003 and trying to add some data to a SQL Server 2005 table. I have linked this using an ODBC link, and can open the table and run select queries on the table.

When I try and Append records to it, the table does not show in the table name box.

Does anyone know how I can resolve this? I guess there is something on the SQL Server side I need to set.

Thanks for your help.

 

[boblarson]

1. Make sure your table on SQL Server has a primary key assigned.

2. You should be able to type in the name, but perhaps it has the dbo_ prefix attached so it isn't where you think it should be.

 

[Kiwiman]

Howzit

This has come up again - I never resolved this but found a workaround - which I can't remember.

I created the table in SQL Server using the following

Create Table ProdCodeMap
	(
	ProdCode  varchar(31) null default(''),
	ProdDescrip  varchar(101) null default(''),
	NewProdCode  varchar(31) null default(''),
	NewProdDescrip  varchar(101) null default('')
	)

I linked the table to access and renamed it by taking out the dbo. part of the table name. I can see and open the table in access, but the name does not appear in the Append "Table Name" box. I can write the table name in this box instead, access recognises it and even lets me append the data.

My question is why I can't see this table in the list of tables to append to. Other tables from the same SQL database appear. Any ideas?