Re: Access 2007 / SQL 2008 slow to open....

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

I don't want to be blunt, but you've obviously never opened a ticket with
Microsoft. Maybe your clients can wait 3-6 months for a resolution or an
upgrade or an SP release from them, but my clients will NOT.



"Sylvain Lafontaine" wrote:

"Maurice Maglalang" <MauriceMaglalang@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in
message news:E3A10A08-3492-4FF7-AEEA-3B56E889C45A@xxxxxxxxxxxxxxxx
I got past the problem by giving the PUBLIC database role rights to the
database I was having a problem with. Considering that applying USER
roles
in SQL 2000 and SQL 2005 worked just fine in the past, I have no idea
whether
this is the correct way to resolve the problem. I've received NO REPLIES
from any "MVP" so I'm hoping I made the right decision for my 600 users.
The
good news is that adding layers of role-based security at the SCHEMA level
overrode anything I did at the parent level. Hope that helps! Sincerely,
Maurice Maglalang (maurice at akademe dot net)

"Maurice Maglalang" wrote:

I don't want to be blunt but at 600 users, you should have opened a support
ticket at Microsoft.

These public forums are open to everyone and the questions here are answered
free of charge on a free time basis. The "MVP" don't work for MS; they just
appears to give a little more of their freetime than other people around
here. I'm sure that if anyone here would have known the answer, they would
have answered back to you.

Finally, thanks for your solution; I'm sure it will be helpful to other
people.

--
Sylvain Lafontaine, ing.
MVP - Windows Live Platform
Email: sylvain2009 sylvainlafontaine com (fill the blanks, no spam please)
Independent consultant and remote programming for Access and SQL-Server
(French)


.

.

Relevant Pages

  • Re: Problem with entourage/exchange
    ... clients open support tickets with microsoft to force the issue. ... resolved...microsoft issued refunds for each ticket. ... we're not sure WHICH patch caused entourage to ...
    (microsoft.public.mac.office.entourage)
  • RE: ISA server 2003 and microsoft update
    ... I understand that your internal clients ... unable to access Microsoft Update. ... Click the "Connect to the Internet" link. ... check if you have 22 SBS rules in the ISA server. ...
    (microsoft.public.windows.server.sbs)
  • RE: Group Policy, Firewall and RDP - Terminal Services
    ... ping and telnet the clients. ... Microsoft Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ... I did mention that I CAN Remote into the Server right? ...
    (microsoft.public.windows.server.sbs)
  • Re: XP Clients cannot connect to new SBS 2003 installation.
    ... were successful in resolving this issue. ... The security settings on the clients are incorrect. ... Microsoft Online Newsgroup Support ... This newsgroup only focuses on SBS technical issues. ...
    (microsoft.public.windows.server.sbs)
  • RE: Check Your Server Configuration
    ... Some clients are connecting ... > When installing WSUS on Windows Small Business Server 2003, ... > enables V4 and V5 clients to selfupdate through the default Web site. ... > computer running Small Business Server that also has Microsoft Windows ...
    (microsoft.public.windows.server.sbs)