I have an Access 2003 database that now has a backend in SQL Server 2005 due to my converting it.
In the Access database there is a query that runs to pull data down out of a DB2 table and inserts the data into a table. Since I have converted all tables that used to be local to ACCESS into SQL Server, I am now trying to do a "Select Into" on a linked table. Herein lies my dilemma -- everytime the query is run, the linked table becomes local.
Can someone tell me why the linked table dissappears and how can I prevent this from happening?
INTO [Item Desc Table]
ItemData is linked to the DB2 table and [Item Desc Table] is linked to a SQL Sever table.
Both ItemData and the [Item Desc Table] have four fields for Plant, ItemID, ItemDesc, UOM. If I view the design of the tables within Access they have the same data type. The differences are that [Item Desc Table] has a Primary Key defined on Plant and ItemId and ItemData has no primary keys defined at all. Also ItemDesc and UOM are listed as being required on the ItemData table but not on [Item Desc Table]. I hope this helps.