MacroAlan
New Member
- Joined
- Aug 30, 2004
- Messages
- 31
I have an Access database that was getting close to the 2gig limit so I converted the primary tables to SQL Server.
My query for pulling 195K rows into SQL table is working.
Before I begin producing reports, I need to update a number of fields on that master table.
Everything I do, I am getting a 3073 error; Operation must use an updatable query
The following query is constructed from a Recordset to give me the component parts.
Do I need to pass this thru a DAO.Connection? Is my syntax wrong?
Do I need to qualify the table with dbo.TableName?
My query for pulling 195K rows into SQL table is working.
Before I begin producing reports, I need to update a number of fields on that master table.
Everything I do, I am getting a 3073 error; Operation must use an updatable query
The following query is constructed from a Recordset to give me the component parts.
Code:
UPDATE dbo_tbl_Sales_Data_Pass SET dbo_tbl_Sales_Data_Pass.[Lead Time Category] = '000-013'
WHERE (((dbo_tbl_Sales_Data_Pass.[Num of Days Order to Request])>=0
And (dbo_tbl_Sales_Data_Pass.[Num of Days Order to Request])<=13));
UPDATE dbo_tbl_Sales_Data_Pass
SET dbo_tbl_Sales_Data_Pass.[Lead Time Category] = '000-013'
WHERE (((dbo_tbl_Sales_Data_Pass.[Num of Days Order to Request])>=0
And (dbo_tbl_Sales_Data_Pass.[Num of Days Order to Request])<=13));
Do I need to pass this thru a DAO.Connection? Is my syntax wrong?
Do I need to qualify the table with dbo.TableName?