My BCM data base has become corrupted. After a miserable experience with
VISTA I upgraded to 7 on my HP laptop and continue to have problems in
Outlook BCM. Latest occurred when I attempted to add a contact the system
indicated that I as administrator did not have the proper privileges and BCM
indicated that my access address was not signed in. I moved to run error
check and BCM stalled then froze. I shut down, cleaned and defragged, opened
up BCM and encountered a dialogue box in the error check run that stated that
the system had discovered error that could not be fixed and to restore the
BCM files.

In running a restore, I encountered a dialogue box that states "Changes to
the state or options of DB 'MSSmallBusiness' cannot be made at this time. The
database is in single-user mode, and a user is currently connected to it.
ALTER DATABASE statement failed.
I need a fix. I am the only user on this system -

What have you done to your OS after XP. Vista was a disaster and to the
moment our experience with 7 is beginning the same way.

John H. Scott
Managing Director
Morgan Whitehall

John H. Scott
Managing Director
Morgan Whitehall
248 310-1946

On 3/8/2010 1:54 PM, JhScottUSA wrote:
> My BCM data base has become corrupted. After a miserable experience with
> VISTA I upgraded to 7 on my HP laptop and continue to have problems in
> Outlook BCM. Latest occurred when I attempted to add a contact the system
> indicated that I as administrator did not have the proper privileges and BCM
> indicated that my access address was not signed in. I moved to run error
> check and BCM stalled then froze. I shut down, cleaned and defragged, opened
> up BCM and encountered a dialogue box in the error check run that stated that
> the system had discovered error that could not be fixed and to restore the
> BCM files.
>
> In running a restore, I encountered a dialogue box that states "Changes to
> the state or options of DB 'MSSmallBusiness' cannot be made at this time. The
> database is in single-user mode, and a user is currently connected to it.
> ALTER DATABASE statement failed.
> I need a fix. I am the only user on this system -
>
> What have you done to your OS after XP. Vista was a disaster and to the
> moment our experience with 7 is beginning the same way.
>
> John H. Scott
> Managing Director
> Morgan Whitehall
>
> John H. Scott
> Managing Director
> Morgan Whitehall
> 248 310-1946
Restart the SQL server service. That should clear the single user mode
issue.

Alternatively, restart the computer.

Try again.
--
Leonid S. Knyshov
Crashproof Solutions
510-282-1008
Twitter: @wiseleo
http://crashproofsolutions.com
Microsoft Small Business Specialist
Please vote "helpful" if I helped you

Right Click on Outlook, select the option to launch it as an administrator
and see If you can restore the data successfully

--
Regards

Rahul Thomas

MSFT

"JhScottUSA" <(E-Mail Removed)> wrote in message
news:9BAA240A-D8FE-49E9-ACC6-(E-Mail Removed)...
> My BCM data base has become corrupted. After a miserable experience with
> VISTA I upgraded to 7 on my HP laptop and continue to have problems in
> Outlook BCM. Latest occurred when I attempted to add a contact the system
> indicated that I as administrator did not have the proper privileges and
> BCM
> indicated that my access address was not signed in. I moved to run error
> check and BCM stalled then froze. I shut down, cleaned and defragged,
> opened
> up BCM and encountered a dialogue box in the error check run that stated
> that
> the system had discovered error that could not be fixed and to restore the
> BCM files.
>
> In running a restore, I encountered a dialogue box that states "Changes to
> the state or options of DB 'MSSmallBusiness' cannot be made at this time.
> The
> database is in single-user mode, and a user is currently connected to it.
> ALTER DATABASE statement failed.
> I need a fix. I am the only user on this system -
>
> What have you done to your OS after XP. Vista was a disaster and to the
> moment our experience with 7 is beginning the same way.
>
> John H. Scott
> Managing Director
> Morgan Whitehall
>
> John H. Scott
> Managing Director
> Morgan Whitehall
> 248 310-1946