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...connecting livemail
using internet explorer 8. Clicking desktop icon gives me my hotmail folders
but it won't connect so can't send or receive emails. But if I go to hotmail
website,I can access fully functioning hotmail -but with different (not so
What can I do to restore connection to usual email?
Problem arose 29 july -before that access and connection were ok.
Please keep it simple!
...Restoring Exchange 2000 cluster to "standard" Exchange 2000 Enterp
At the moment we are creating a "full" test environment built from backup
tapes from our live environment. DC's are all up and running. Our 2000 native
forest exists out of a top domain and 2 child domains. All DC's are running
2000 SP3 as well as the Exchange servers.
Exchange servers are located in the child domains.
In one of the child domains which is NL.top.net we have an Exchange cluster,
2 nodes active/active eg. These would be EX01 and EX02 and running EX04 and
Since we unfortunately do not have a SAN in our test site I will not be able
to do a DR...Autofilter to search characters that begin with "* "
I'm having difficulty getting Autofilter to work with text that begins with
"* ". It appears that * is a wild card, but I don't want to search that
way. Any suggestions?
So..you're trying to use a custom filter within Autofilter?
Use Begins with and then, in the text box, precede the asterisk with a tilde
"Barb Reinhardt" wrote:
> I'm having difficulty getting Autofilter to work with text that begins with
> "* ". It appears that * is a wild card, but I don't want to search that
> way. Any s...Controlling multiple TCP connections from Outlook 2003 clients
I've noticed that Outlook 2003 clients can have multiple TCP
connections to the mailbox store on Exchange. As the following web
"This behavior is by design. Outlook can open multiple connections to
parallelize its data communications with the Exchange server. The
actual number of connections will vary according to the version of
Outlook that you're using and the mode in which you're using it. For
Microsoft Office Outlook 2003 in Cached Exchange Mode, you'll see four
connections for the mailbox, ...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...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...How to sort calendar entries on "size"
I would like to remove large size calendar entries by
being able to sort on "size". I am able to sort Inbox
items on size but not calendar. My company's exchange
server has email account size quota and a 3rd of that
quota is being held up by calendar entries on the server
side, so I would like to get rid of the unwanted past
celndar entries that occupy portion of my account quota.
Any help is appreciated.
On 11/18/03 9:21 PM, in article email@example.com,
"Umesh" <firstname.lastname@example.org> wrote:
> I would...too many "inherited" custome headers and footers
It seems that somehow I have "inherited" custom headers
and footers from someone else's workbook. They have
filled up almost all the allocated spaces in the drop-down
selection list and pre-empt me from adding more than two
custom headers/footers of my own. I need to add at least
four new custom headers to the list.
Is there some way to delete all the "inherited" custom
headers and footers?
..."the wizard is unable to open your query in datasheet mode, possi
"the wizard is unable to open your query in datasheet mode, possibly because
another user has a source table open in exclusive mode. your query will be
opened in design view"
what this message mean ,and how can i solve it
Please provide more details as to what you are doing when you get the error,
what your database setup is (i.e. split Fe/BE?, multiuser?, version? etc).
Without more information, we can only guess.
>"the wizard is unable to open your query in datasheet mode, possibly because
>another user has a ...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..."x" button enables deletion.... can we put a focus trigger there?
on three forms, I put focus triggers on the "delete" button because I need
to validate some additional data before allowing the user to delete.
However, if the user clicks on the corner "x" button to close the form and
gets the dialogue box saying they have changes, do they want to "Save",
"Delete" or "Cancel", they can delete the record anyways. Is there any way
to put a focus trigger on the button of the dialogue box, or on the "x"
Thanks in advance.
I assume you are working with Dexterity.
To work with an add...how to config Server for one user which has 2 mail address.
we have one NT4.0 + Exchange 5.5 Server "A" Email email@example.com ��and
windows2003 + exchange 2003 Server "B" firstname.lastname@example.org 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...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...Chart "Benchmark" Line Graph Question
I am generating a graph of many team's monthly audit productivity percentages
(bar graph) with a "benchmark" (line graph) at 95% (y axis) across 6 month
period (x axis).
The problem is that the line graph appears on the graph but the ends of the
line are centered in the end columns (left & right). Is there as simple way
to extend the benchmark line out to the edges of the graph?
Have a great day and live life with passion!
...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...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 ...Send Quote via Email
I have created a quote and would like to send it via email
Is this possible without getting too technical!
(1) In Outlook client using Mail Merge
* Open the quote
* File-->Format for Customer
* Walk through the mail merge steps using "quote.dot" template
This template could potentially be modified for more/less data.
(2) Download the sample quote report by EdMar from CRM Sandbox
The rdl file is at http://codegallery.gotdotnet.com/crm under the Downloads
section with title "Quote Sample Report". Download this file and import it
to your reports s...Using "fixed" decimal place function data for charts
Is there a way to graph data which utilizes the "fixed" function for decimal
places? When I try this it will not graph, as the data has become text or
something - even though I've selected number in the cell formats.
If you've fixed the number of digits using only number formats, the values remain
numeric, and they should chart just fine. This means selecting the range, going to
the Formatting menu and selecting Cells, and on the Number tab, selecting Number in
the category list, and setting a number of digits.
I'm not familiar with a "fixed function". I...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...Unable to Add account to PrivUserGroup
On installation of MS CRM 1.2 on an Server 2003 machine, I am getting
the error message:
Setup was unable to install CRM Server
Setup was unable to add the account to PrivUserGroup in Active
Unknown Error (80005000)
This happens pretty far into the installation process.
Any clues on what is causing this?
> Setup was unable to install CRM Server
> Setup was unable to add the account to PrivUserGroup in Active
> Unknown Error (80005000)
Not sure, perhaps:
Microsoft Business Solutions CRM ins...Unable to send E-Mails #3
I have recently installed broadband and when I attempt to send an E-Mail I
get the following message.
554 <E-Mail Adress>: Recipient address rejected: Relay access denied
Any help would be gratefully appreciated
On Mon, 20 Dec 2004 13:27:03 -0800, LarryM wrote:
> I have recently installed broadband and when I attempt to send an E-Mail I
> get the following message.
> 554 <E-Mail Adress>: Recipient address rejected: Relay access denied
> Any help would be gratefully appreciated
You probably need to authenticate to your outgoing server. Set that up on
the &...Cannot Email from Outlook 2003..no "send" button present
I cannot send letters or attachments of any kind..I tried
reinstalling Outlook 2003 didn't solve the
You have to close your new message and then the send/receive button appears on your inbox screen. Click that and then it will send.
...Public Const strConstantBlue As String = "RGB(79, 129, 189)" throwing error messages
I declared a Public Constant whose value is valid for a COUPLE of
macros. The declaration statement to define the value of the constant
is as follows:
Public Const strConstantBlue As String = "RGB(79, 129, 189)"
The above defined constant will then be used in below macro as well as
several similar macros. I declared a Public Const so that I just have
to alter the RGB values in one place, should a change be required.
Regrettably the macro throws error messages, telling me that a runtime
error 13 has occurred. What's wrong with the declaration sta...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...