Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Index Rebuild Fails on Table Exported from MS Access

Status
Not open for further replies.
harryrich

harryrich

Programmer
Apr 11, 2000
68
US
For some tables exported (straight export, no Wiz) from MS-Access 2000 the standard maintenance plan fails when rebuilding the index. The message was (and still is):

[MICROSOFT SQL-DMO (ODBC SQLState: 42000)] Error 1934: [Microsoft][ODBC SQL Server Driver][SQL Server] DBCC failed because the following SET options have incorrect settings 'QUOTED_IDENTIFIER, ARITHABORT'

Deleting and rebuilding indices from Enterprize Manager did not change this behavior. Copying the table design and data did fix the problem.

I couldn't find any clues in the MicrosoftTM Knowledge Base. Any ideas?

Thanks,

Harry
 
Status
Not open for further replies.

Similar threads

Steve Yu
  • Locked
  • Question
How secure is MS SQL on the Internet vs behind firewall inside a LAN 1
Replies
3
Views
557
Chris Miller
Chris Miller
bharons
  • Locked
  • Question
Pick up value from combobox
Replies
0
Views
589
bharons
bharons
SashaBuilder3
  • Locked
  • Question
select a single row based on conditions in multiple rows 1
Replies
3
Views
871
SashaBuilder3
SashaBuilder3
BobThornton
  • Locked
  • Question
Drop a table based on the count of records in another table
Replies
13
Views
725
Chris Miller
Chris Miller
grnzbra
  • Locked
  • Question
How Do I Add Column to Middle of Table
Replies
4
Views
885
BobSuruncle
BobSuruncle

Part and Inventory Search

Sponsor

Back
Top