Have this snippet of code that I use fairly often:
insert into OPENDATASOURCE('Microsoft.Jet.OLEDB.4.0', 'Data Source=D:\DP1_DBF\;Extended Properties=dBASE III;')...Any_DBF
(Field1, Field2, Field3)
select Field1, Field2, Field3
Usually works great (and it's perfect for a lot of the dynamic stuff we do), but I run into this error on large tables when the .dbf size hits exactly 262,144 KB. (2^18 in KB, so not a random number).
OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" returned message "Could not update; currently locked.".
Msg 7343, Level 16, State 2, Line 1
The OLE DB provider "Microsoft.Jet.OLEDB.4.0" for linked server "(null)" could not INSERT INTO table "[Microsoft.Jet.OLEDB.4.0]
Any ideas to get around this limitation or possible workarounds? It would need to work in SQL 2000/2005/2008. Thanks in advance =)