Pass Through to SQL Server Optimization Questions
On an autoexec function several recordsets are opened. Some are
queries to local tables, some are to sql server tables.
I have been trying to optimize performance but I haven't seen much
difference in speed between queries run directly against linked SQL
Server tables vs pass through queries. Here is my code for creating
the pass throughs (I have another function OpenRecordSetLocal that
handles queries to tables within the frontend. The ODBC connection
string resides in the query Q_PassThrough.
Am I missing something key? Is there a better way to do this?
Function OpenRecord...MS Office 2008 home version with Pro for entourage
Hello and thanks for any help you can provide.
I have MS Office 2008 Home & Student edition. I want to install only
word, excel and powerpoint and then separately install Entourage 2008
Pro (as provided by my hosted exchange co.) in order to connect to my
exchange server. I have done this before and remember some convoluted
errors but it eventually worked. My latest attempt did not. Has there
been a change to prevent this from working?
...Microsoft CRM server is not responding
Workflow Manager write:
The specified Microsoft CRM server is not responding. This might happen if
it is currently unavailable, it is not a Microsoft CRM server, or you are
not a valid user. Fro more information, contact your system administrator.
How fix it? In IE i can logon to CRM.
I've resolved this problem by restoring the metabase with the original
version in IIS
> Workflow Manager write:
> The specified Microsoft CRM server is not responding. This might happen if
> it is currently un...Exchange 5.5 to 2003 upgrade issue 3
We have upgraded our Exchange 5.5 server to 2003 and moved all the mailboxes
and moved and re-homed the folders following the KB articles.
We turned off the 5.5 services and for a week everything was working fine.
Now for some reason the messages to the main distribution list is being sent
to the old 5.5 server on a x400 protocol.
How can I stop this and assure that the 2003 server is self contained so I
can get rid of this server?
...Dropped connection to POP3 servers
Just installed Office 2003 under XP Home. Outlook is
dropping connection to POP3 servers, I check 2 different
servers with a S/R. Both fail at the same time, never
separately. Sometimes I can exit Outlook gracefully but
a reboot is required to get Outlook to work again.
Sometimes locks entire system and have to powerdown
Pattern not fully determined but it appears to happen
when there is other activity to the internet that is
going to specific servers using an ID and password. I
use Medved Quotetracker with E*Trade quotes (requires
ID). If I bring up Quotetracker, Ou...Vb.net 2008 ContextMenuStrip logical error when running code
I have a connectmenustrip item that when clicked runs the following code
Now if the event is called by the button i.e. cmdDeleteingBooking.Click the
linq query returns the appropriate value.
However when called by cntMnuCancelBookingItem.Click is returns 0 even if a
checkbox is of 'TRUE' value.
Debugging shows the code runs exactly the same code (which loops around rows
in a datagridview checking if the checkbox has been checked).
Could someone explain the reasoning why the same code would return different
Private Sub cmdDelete...how to config Server for one user which has 2 mail address.
we have one NT4.0 + Exchange 5.5 Server "A" Email firstname.lastname@example.org ��and
windows2003 + exchange 2003 Server "B" email@example.com user name is same in A
B��Mx record was be set ,question is how to config Exchange 2003 to receive
down the mail to Server A , because of we need to replace A with B.
thanks a lot.
E2K3 setup guides you through common scenarios (like yours) pretty much holding
your hand - on welcome screen tell it that you have existing E55 org and want to
join it, then follow on-screen instructions. Having usable backup of Exchange
databases and AD i...How Can I Control When Messages are Downloaded from Server
I have the box "Check for messages every ___ minutes" unchecked
Yet seemingly randomly, messages get downloaded a couple of times a day
without my clicking "Sync." This is problematic due to the way I share the
Is there another setting I need to keep this spontaneous downloading from
"Gripper" <Gripper@discussions.microsoft.com> wrote in message
> I have the box "Check for messages every ___ minutes" unchecked
> (too...Exchange Server 2000 Secuirty Setup problems
I have apply wrong setting to our exchange server 2000 . The wrong setting
as from exchange manager . mail store , I have apply everyone send as and
receive as access right, the group included remote access via offline sync.
This setting once apply , all user access other mailbox without apply access
right. I have try disable this setting, after all local office user no
problems, but a remote offline sync laptop user does not work . The error as
below: Unable to display the folder. Microsoft Outlook could not access the
specified folder location. The file C:\exchange\shawnb.ost cannot b...Bogus Helo
I could not send email to 1 or 2 domains and the rest all emails going
fine, I checked with ISP my IP is not blocked and I don't have any
virus on the server but the only problem from my point of view is
creating problem my domain name is like main-server.local which i
think suppose to be main-server.com
Any Help would be appreciated
configure the FQDN as explained here:
IMF Tune - Unleash the Full Intelligent Message Filter Power
"Adnank5" <adnan.inay...Lexmark driver for Windows Vista??
does anyone know how to get a driver for my Vista program for a Lexmark X75
Any help appreciated?
On Sun, 3 Jun 2007 15:07:39 -0500, "Kitty Stringfellow"
>does anyone know how to get a driver for my Vista program for a Lexmark X75
>Any help appreciated?
I'd suggest reposting your question in a newsgroup supporting Vista, or
Lexmark. This newsgroup is for questions about designing relational database
Queries in Microsoft Access.
John W. Vinson [MVP]
...IIS Admin Service Stops Repeatedly
I am having the same symtoms that are described in knowledge base article
http://support.microsoft.com/?id=885264. The IIS admin and SMP services
crashes repeatedly (6 times since last server restart 3 Hours Ago), after
IIS crash I receive an instant phone call from my external OWA users!!!
I am running Exchange Server 2003 SP1 on Windows Server 2003 R2 and that KB
Hotfix does not apply to my OS version.
I need help with this PLEASE!!!! The IIS Services simply goes down and
theres no clue for me to start troubleshooting. The Exchange Server has been
running for 3 months without an...Office 2004 issue with documents NOT BEING ABLE TO OPEN APPLICATION, but application can open documents.
Just migrated all my files and apps from a G4-400 to a new Mac Mini
1.87ghz Intel running pre-installed OSX10.4.10.
Used CD to install 'normal' version of Office 2004 Mac on the new Mac
Mini. In fact its the same disk that I used originally to install Office
on the G4-400.
Neither old .xls and .doc documents (made on old Mac, nor new .xls and
..doc documents (made on new Mac)will not open their respective
applications, when clicked upon.
However, when I use either of the the application's "Open" feature,
theres is no pr...invoice for envelopes with windows
What invoice template can I use that will consistently place the name and
mailing address on the invoice form so that it will always fit in the window
of an standard #10 business envelope?
There is no standard location for the window. I would suggest folding a
piece of paper and measuring where the window is on the envelopes you use.
MVP Microsoft [Publisher]
Tech Editor for "Microsoft Publisher 2007 For Dummies"
"Mary" <Mary@discussions.microsoft.com> wrote in message
> What invoi...Chart printing issue in Excel 2007
A spreadsheet with charts was created using Excel 2003. I have Excel 2007
and saved it in compatibility mode.
I inserted a couple colored lines on the chart and created my own legend
based on these. A couple of issues:
1. When I close the file or even minimize, 2 of the colored lines on a
couple of my legends disappear upon reopening.
2. When I try to print a chart, it looks good in Print Preview, but then
looks magnified,half off the page, and only one of my drawn lines is printed.
When someone with 2003 prints, the sizing is correct, but all of the
colored drawn lines are missing...DPM and VMM on same server using side-by-side SQL installation
Windows 2008 Std R2 Server, 64bit
VMM 2007 is currently installed (with the built-in default database) SQL
2005 Express Edition, SP3, 32bit.
I was advised by Microsoft that both VMM and DPM could be installed on the
same server (small DR environment)
The VMs are hosted on a Windows 2008 Enterprise Server w/ VS2005R2 - because
the hardware didn't support HyperV.
VMM works great to manage the Windows 2008 VS2005R2 Host running Win2K3
server instances ... after lots of trial and error.
Now, I need to install DPM 2007 onto the same server... DPM wants to install
the 64bit vers...Single keystroke issue
Since upgrading from IE7 to IE8, I have lost the capability in the
right-click menu to hhit a single key to perform a function. For example,
right click a "favorite" and hit "m" to rename, or hit "d" to delete.
Instead, now have to mouse over the command to perform. Also, the shortcut
keyletter used to be underlined in IE7, now nothing underlined.
I'm sure it is something simple, but I haven't been able to find the answer
FerretDaddy & the FBR-Gang
They changed the way the Favorites Pane and Links toolb...Only new email window?
Is there a way that I could have a shortcut on my desktop that does not open
the whole application, but rather ONLY open my new email window? I send out
a lot of email, and I also have a lot of other apps running.
Please let me know if that is possible. Thank you,
Steve F. <firstname.lastname@example.org> wrote:
> Is there a way that I could have a shortcut on my desktop that does
> not open the whole application, but rather ONLY open my new email
> window? I send out a lot of email, and I also have a lot of other
> apps running.
Create a shortcut whose target is:
"%Pr...Outlook 2000 client Connection TimeOut w/ Ex5.5 server???
Hi, we have a really intriguing issue that started recently.
Outlook users, when clicking on an item in the Mailbox, will get the message
"Can't open this item. The operation could not be completed because of an
error on the network. Try to log on to the network again, and then repeat
The user will click OK, and usually will be able to open the same item in
one or two attempts.
The Envrionment: Ex5.5 SP4, Outlook 2000.
It is ONLY the Windows98 users that is seeing this message, on NT and W2k
stations, there's this occassional hour-glass when we click on an ...Exchange Server C Drive No free space
Need some advise.
The Exchange Server during certain times C Drive will not have free space. I
have check that during that period there is a temp file which will increase
in size and takes up all the disk space in C. The file will not have any
extension (the file name ex. T232C or R408).
When this happened, the Exchange MTA service will stop, users will not able
to send email.
I have rum Spyware scan, Virus Scan, Online Virus scan, all seems to be
Anyone experience this before?
Thanks in Advance for the help.
On Wed, 26 Jul 2006...parent window?
Im trying to display bmp image using static control.I have
created a pointer as
when i use stc.Create(NULL,SS_BITMAP,pos,?);
what shall i give for the parent window of static control?
i used getactivewindow(),but i was not able to display bmp
when setbitmap(Hbmp) is used.
thanks in advance
...Frame window does not get displayed properly
I have a Dialog based applciation. I want to create a Frame window
when clicked on the button on Dialog. The problem is I handled the
Painting of the dialog (I draw a picture on so WM_PAINT message I
handle.) but doing this I am not able to draw the frame window
properly. It appears to be transparent to me .
I am setting the CFrameWnd to be the child of CDialog
Please Can you let me know how to draw the farme window of how can I
have a floting window on a dialog.
I don't know if what you are doing is a good idea.
But if you want to have a floating window ins...Exchange server reporting tool
Could someone recommend an exchange server reporting tool other than
promodag? I will really appreciate the help.
=?Utf-8?B?c2xhd2Fs?= <email@example.com> wrote in
> Could someone recommend an exchange server reporting tool other than
> promodag? I will really appreciate the help.
Quest messagestats is good stuff.
i second that...
Susan Conkey [MVP]
"Arlo Clizer" <firstname.lastname@example.org...Gadget Issue
Once in a while, a Gadget just disappears. Once in a while, I can only
see a small portion of a Gadget (the rest is off the screen). Once in
a while, my Gadgets switch their order on the screen. Once in a while,
my Volume Control Gadget stops working. Is anybody else having any of
these problems? Are there fixes? Thanks.......
...Cursor on new message window but no text appears when typed?
When using Outlook 2003 for sending new e-mail, I'm unable to type text into
the message body. The cursor appears but no text shows. Text appears when I
use Word 2003 to send my new e-mail message. It is more convenient for me to