Posted by Erland Sommarskog on 04/05/07 22:01

JA (jarmour@kc.rr.com) writes:
> I just deleted about 1 million records from a SQL Server 2000 database. I
> access it using Access 2000.
>
> I have Compact and Repair available in the adp under Tools. Should I do
> that from Access? Will it not mess anything up?

To me that sounds like tools for the local Access database.

In any case, one million rows is not that much, unless the rows are
extremely wide.


--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Users cannot view stored procedure text
• Prev in forum: Re: select distinct record only if certain column not null
• Thread view: Re: Compact and Repair in an adp

[Reply to this message]