Access Front-end & SQL Server Back-end

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

worksfire1 - 06 Sep 2007 03:02 GMT

It's been a long time since I dabbled in SQL Server. It was back in the day
on SQL 6.0! Due to load needs, the Sr. Analyst in my department (IS) had to
switch from an Access Back-end (BE) to SQL Server BE on a database. I know
when she had a corrupt record issue in Access every once in a while, we can
do a "Compact & Repair" and fix the record and then everything works again.
Does anyone know off hand what the SQL Server equivalent to a "Compact &
Repair" is? If there is a better forum, I apologize and would love a link to
it. But if anyone knows the answer, that is a PLUS, too!

Reply to this Message

Rick Brandt - 06 Sep 2007 03:15 GMT

> It's been a long time since I dabbled in SQL Server. It was back in
> the day on SQL 6.0! Due to load needs, the Sr. Analyst in my
[quoted text clipped - 5 lines]
> there is a better forum, I apologize and would love a link to it.
> But if anyone knows the answer, that is a PLUS, too!

SQL Server has no need for this in the same sense, but there is a "shrink
database" command that is as similar as you are going to get. It can even be
set to do this automatically on a continuous basis.

Signature

Rick Brandt, Microsoft Access MVP
Email (as appropriate) to...
RBrandt at Hunter dot com

Reply to this Message