Search results for query: *

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...

I would like to change the size of the the icons in toolbars appearing on the taskbar. Anyone know how? Thanks.

I'm using BENT 7.3 on a Windows NT server. The install prompted me for the User ID and Password of the identity BENT would be using in the network. Is there any way to change these without reinstalling BENT? If not, what information should I expect to lose in the process of reinstalling the...

When DTS issues run-time error messages it uses names it generates, such as "DataPumpTask1". Does anyone have a handle on how to build a cross-reference to the user-defined task names? Thanks, Harry

DTS supports execution of a DOS command, which can be a DOS batch file. Does anyone have any idea how the batch file can indicate to DTS whether it succeeded or failed? My environment is SQL 7.0 (SP3) / NT 4.0 (SP6) / Intel. Thanks, Harry Rich

When I attempt an import of a MS-Access table to SQL Server 7.0 (SP3) via DTS, the wizard complains that it is unable to find the Access Workgroup (MDW) file (or that the file is opened exclusively by another user, ... not so). I am accessing DTS via the enterprise manager running on the...

I've been reimplementing some Access 97 programming to Access 2000, perhaps my first mistake. I created a recordset: Dim RateSet as Recordset Set RateSet = CurrentDb.OpenRecordset ("RateSet",dbOpenDynaset) I found the RateSet.FindFirst, .FindNext, and .FindLast methods were...

The Access 97 Performance Analyzer misses some points when dealing with multple MDB files.  In particular, when a query creates a join between tables in different files the Analyzer may not recommend or create a relationship betweem the two tables based on the joined...