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...Money: Err Msg: Path Has Not Been Properly Set Up
Microsoft Money. The path is not properly set up in the registry or has been
moved after running Money's Setup. Please re-install Money. Otherwise, Money
may not be able to run properly.
re-instal wont help
deleting registry entry dasn.t help.
windowx xp sp2 Ms Money 97 (v.5.0)
Are you using an administrator account to run the software?
Glyn Simpson, Microsoft MVP - Money
for UK tips and fixes for MS Money. To send Microsoft your wishes or
suggestions, use http://registe...Invoice Designer #3
I'm running Money Small Business 2004.
I have gone into the invoice designer section of the program, and
created an invoice template that I wish to use to print out my invoices.
However I cannot find any way of getting the invoices created within
Money to print out in this format.
Is there any way to save this template so that it overwrites the
standard invoice template which is quite unsuitable for my requirements
(or is there some other way of getting the layout that I want?).
None of the the help files within the program, the on-line Money 2004
manual or the web-based help files s...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...3.0 Customization
Is it possible in 3.0 to have one set of screens appear for one group of
users and another set for another group. For instance, could our
service people only see the service screens while our sales people only
see the sales screens? I know I can restrict access to different areas,
but we want to have a totally different look and feel for each group...
Sorry - I dont believe this can be done
"Matt Harvey" <firstname.lastname@example.org> wrote in message
> Is it possible in 3.0 to have one set of screens appear for one group of
>...Report CRM 3.0
I would need to find out the detailed procedure (step by step) to customize
Could anybody inform about any links or documents concerning this issue?
I'm not sure if it's detailed enough, but the technical training manual has
a section on creating and customizing reports. You can find it here:
Jeffry van de Vuurst
"Marco Rocca" <Marco Rocca@discussions.microsoft.com> wrote in message
news:CEF80683-EC26-456C-82C...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?
...linking worksheets #3
I know ho to link cells to oher cells. But is there a convenient way to link
ranges or worksheets to others.
just link the first cell
and copy this formula for your range. The reference will adapt
j van c wrote:
> I know ho to link cells to oher cells. But is there a convenient way
> to link ranges or worksheets to others.
...Offline Database Sync #3
Is there anyway to manually sync the offline database with the online
database on the server?
We have a register that travels to several weekend shows. We use the
offline database when it travels and would like to reconnect it when it
returns to the store.
Since we process credit cards with a secure wireless connection, we want to
run a Z report each day and settle the EDC Batch for credit card
transactions. In order to accomplish that we do the following.
We sync the offline database before the show. Then modify the SO Admin to
point the primary database to the offline databas...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...How do I setup an SMTP gateway / smart host for Exchange 5.5 internet bound mail
My current setup has a Windows NT 4.0 Exchange 5.5 server setting on our
company LAN behind a Microsoft ISA Server. The Exchange server's Internet
Mail Connector binds to (I assume this is the proper terms) port 25 on the
ISA server for inbound and outbound Internet Mail.
Our company has finally upgraded to a new Cisco Pix Firewall which we are
able to setup a DMZ on. The suggestion by our ISP is to setup an SMTP
gateway in the DMZ and have our internal Exchange server send mail to it
destined for the Internet.
I am aware that most of the work for making the connections from the SMTP
...Catch all outgoing email on Exchange and send copy to specified account
I have been asked to find out if there is anyway to configure our mail
server to catch all outgoing email from certain email accounts on our
Exchange 2003 Enterprise server and forward a copy of this email to a
specified account, also on the Exchange server.
If anyone could point me in the right direction I'd be grateful.
On 25 Oct 2006 04:10:54 -0700, email@example.com wrote:
>I have been asked to find out if there is anyway to configure our mail
>server to catch all outgoing email from certain email accounts on our
>Exchange 2003 Enterpr...CRM 4.0 Custom Report Filter Problem
I am using the Report Wizard to create a simple report.
Report is using Quotes and Quote Products
I have a custom field in Quote Products which is a bit field Yes-No
When I use that field as a filter for report output, I get all records. The
filter criteria appears to be ignored
Is this an inherent problem with Report Wizard or Am I doing something
depends on your business logic and what you want to see.
If you have three quotes:
Quote-1 has three products, all with the custom field set to Yes
Q2 has three products, two set to Yes, 1 to No
Q3 has three products, all set...Using atl based win dll with CString functions from the mfc projec #3
I have atl based general windows dll with class which contains functions
which uses CString as parameters or return values. This dll might be used
from the atl or mfc project. Dll can be used from ATL project without
problems but whenever I try to use this class from the MFC project I get the
following linker errors:
error LNK2019: unresolved external symbol "__declspec(dllimport) public: int
__thiscall MyClass::AddMenu(long,class ATL::CStringT<wchar_t,class
StrTraitMFC_DLL<wchar_t,class ATL::ChTraitsCRT<wchar_t> > > const &,long)" ...
If I replace CStri...Can you create custom activities? MSCRM 3.0
Is there a way to create a new custom activity instead of customising an
existing one? I have created a custom entity called 'Chat' utilising an
IFRAME. All works well but this entity really should be an activity
considering it's properties.
In fact I've just been introduced to MS-CRM 3.0 and don't really understand
what the difference is between an entity and activity. Would anyone shed the
light for me?
BTW, I think 3.0 looks great. Gotta admit it's improved.
In my experience, you cannot create custom activities. In fact, I have been
dire...conditional formatting in excel #3
how do you add a phrase to a field if the filed is blankl, also, can you have
a notifiction sent to you when a date on a spreadsheet has expired?
> how do you add a phrase to a field if the filed is blankl,
What "phrase" do you mean? A Comment? A value?
also, can you have
> a notifiction sent to you when a date on a spreadsheet has expired?
Maybe you can apply an open event (date to be tested being say in F1):
Private Sub Workbook_Open()
If Range("F1") < Date Then
MsgBox "Date expired"
...Program Trying to Access Email Addresses #3
Outlook 2002. When I try to create new mail, forward, or
reply I get a dialog box telling me:
A program is trying to access e-mail addresses you have
stored in Outlook. Do you want to allow this?
If this is unexpected, it may be a virus and you should
How do I determine what program is trying to access the
Outlook addresses? I have up to date Norton Anti-virus
definitions and have done a system scan, with nothing
Thanks for the help.
...Excel 2002 converts 'S' to 0 when pasting from Clipboard
I came across the following problem:
I copied some tabular data from IBM Personal Communications into the
clipboard (yes, I am still a user of good old 3270 applications). Then
I pasted the data into Microsoft Excel 2002 and all cells containing a
'S' became a '0' (number zero).
Next I did some tests and found out that every single uppercase 'S'
that is transferred to Excel using copy/paste is translated to '0'.
This would not happen with other letters or with words containing an
Using 'Paste special' I can choose to insert my Clipboard a...Excel Problem #3
I have win2000 with Office 2000 in the network!
When i try to rename one excel file my computer make
restart. This hapening not to all files,and all files
there are in the same folder in the network!
What hapen,and what i can do so as to work out the problem?
I have all the required permissions on that network folder.
No one else has any of the files open.
They are not shared workbooks.
...How do I import from LotusOrg 6.0?Import command only has 5.0
I am trying to import my calendar data from Lotus Org V6.X. Under the file
command, it will only import from V5.X. Does anybody have any help for me
since I would like to convert to Outlook from Lotus Organizer.
DonAlbert <DonAlbert@discussions.microsoft.com> typed:
> I am trying to import my calendar data from Lotus Org V6.X. Under
> the file command, it will only import from V5.X. Does anybody have
> any help for me since I would like to convert to Outlook from Lotus
> ...Limiting CRM application ability to aasigning user to approprite CRM security group
IT administrator that I have for client does not like the idea of CRM
application assigning user group automatically. They prefer to do the
security group assignment manually.
Is this possible? What do I need to do to achieve that?
I did it the following way for a customer:
1) You will need to precreate the five groups within your AD. There is no
need of having a own OU (Container, Organizational Unit) for them. Follow the
naming convention of your company or use the default namings from Microsoft
for the five groups. There is no need for your AD Admin to assig...MS Excel Print setup
When i save a document by using landscape setting,& by
opening again that document it does'nt show saved setting.
It shows portrait option,not landscpe option.
...Sql Agent Error
After installing CRM we are receiving the following error.
"An error occurred when attempting to set the SQLSERVERAGENT service to
AutoStart: System.ComponentModel.Win32Exception: The specified service does
not exist as an installed service
Microsoft.Crm.Setup.Common.Utility.ServiceUtility.SetServiceToAutoStart(String serviceName, String machineName)
Microsoft.Crm.Setup.Server.ServiceRunningValidator.AutoStartLocalService(String serviceName, TimeSpan waitTimeForStart)
We have CRM on a SBS 2003 machine and SQL EE 2000 on a W2K3 machine. Both
are DCs the SBS holds all FS...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...Database #2
I'm new to Outlook.
I hear of an Outlook database in other threads. Is this synonymous with the
..pst or .ost files people mention?
Does it corrupt often and if so are there tools to repair it?
There's a utility called ScanPST.EXE that will scan and attempt to repair
Yes, typically when a user says Outlook database they're referring to their
"Craig Roberts" <firstname.lastname@example.org> wrote in message
> I'm new to Outlook.
> I hear of an Outlook d...