Frequent ExchSrvr restarts needed for remote users
Hello all –
I have a mob of disenchanted users about to lynch me because of a problem
that I cannot get to the bottom of. I recently migrated Exchange 5.5 to 2K3,
consolidating three sites in the process. Now we have one Exchange Server at
headquarters that hosts all mailboxes and public folders. The problem is
with the users at the remote sites. Approximately every three business
days, I have to restart the Exch Srvr, because over the space of a few hours,
many users at the remotes sites are unable to connect to it. (“Trying to
connect..” in the Outlook status bar). Only a resta...Compacting remotely?
I have an access97 backend mdb, which I would like to compact/repair
automatically overnight. Is it possible to leave a separate mdb open that
would open the backend mdb, compact it, then close it again?
I'm sure this can be done because I think I've read something about it
somewhere: but I can't remember how - or where!
Hope someone can help.
well you could schedule it with windows.
take a look at Albert Kallal's solution here:
change the code to compact the database...
M...Remote Active Sync
Hello, I just upgraded to Exchange 2003 Server and I have
no idea how to setup Mobile Access. I would like to sync
my pocket pc remotely. Does anyone know where I can get
step by step instructions on how to do this?
...Error 9060 during CreateZipFile procedure
This error occurs on one of three workstations.
I just got the same problem and I uninstall the FRx service pack and the
software, then reinstall it again with SP4 . Somehow it work.
Hope it help.
"Gene Rhine" wrote:
> This error occurs on one of three workstations.
> Gene Rhine
...Access 2007 Runtime: Stored Procedures as Record Source to Forms
Several forms in my Access Project use stored procedures in SQL Server 2000.
When i try to open the forms in Access 2007 Runtime on client machines, i
receive an error that the record source could not be found or does not exist.
I use dbo.ProcName format and the forms open correctly in my full version
What could be the issue?
Can I launch with some api an application in a remote pc that is connected
to the same lan?
If the answer is positive, can I supply also parameters?
Overall, the simple answer is "no". In fact, if you can do this, there is a security hole
in your network large enough to drive a freight train through. Sideways.
However, you can create secure techniques that can allow this; creating the security is a
topic well beyond the scope we can discuss here, but what you have to do is create some
kind of server process that launches the program with appropriate security cred...remote connections
In SS2K , how to enable remote connections ?
For example, from my machine, within SEM I'd like to create a "New SQL
Server Registration" connection to that machine. This has always worked for
me in the past, but today I've encountered an SS2K instance which gives me a
"SQL Server does not exist or access denied. ConnectionOpen (Connect())"
Does it matter if the target instance is configured as "Windows
Authentication" vs "Mixed Mode" ?
I'm attempting the "New SQL Server Registration" via Windows Authentication.
I...How to call aspx page from C#
I am forming a aspx url with query string parameters as variables.
sUrl = "http://abcd.com/getresults.aspx?zipcode=" + zipcode +
"&areaCode=" + areacode + "&Landmark=" + landmark;
When this url formed is run in IE, it returns an xml in the browser.
Now I want to duplicate this functionality in my code (like invoking
this url from within a function and getting the xml as output from the
function) so that my code can parse the xml got in return.
Kindly suggest a way in which this can be achieved?
Thanks in advance,
sudeeprgaitonde@gm...Remote Office VPN Internet Access
Have Remote Office (RO) PCs connected to Main Office (MO) (SBS 2003) via h/w
router Site to Site VPN, on ADSL.
Is it possible to route Internet traffic via the local router rather than
using the SBS 2003 box for DNS. Objective is to reduce data traffic on the
I am going to add 2nd ADSL line to split off and soley route the VoIP
traffic usinng a static route. Or alternatively use a router with VPN
trunking with QoS. However, if Internet traffic was kept 'local', the VPN
would have more bandwidth for VoIP/files.
In article <6...changing contents of a sheet remotely
I have a list of jobs on sheet1 col A contains the job number,
Sheet2 is an invoice, i enter job numbers into col A and Vlookups operate in
the other cols.
When i enter a number into sheet2 i would like the row which contains this
job number to have the date entered into col M so i can easily check if a
job has been charged out.
What is the command for this, will it have to be run as a macro?
If i then go on to enter numbers in a list down to cell A38 on sheet 2 is
the best way to write code to look at all the numbers at once and adjust
Or input the job numbers via a...need a procedure for tracking invoice
how do i start the procedure?
Please post some more details of what you need.
Gord Dibben MS Excel MVP
On Mon, 13 Apr 2009 16:15:01 -0700, vett <email@example.com>
>how do i start the procedure?
...Remote Web Workplace / Remote Destop Web
I'm trying to set up remote desktop access for several of my key users . I
found / enabled "TSWeb", however as far as I can see - and this is where I
need some help - this only allows all users to access a specific computer
within the LAN. I did make this work but there's really no advantage to
running the web interface if it just connects to 1 computer.
I next located the Remote Web Workplace that comes as part of SBS 2003. (I
look after several networks, one of which uses SBS2003). This is the
functionality I'm looking for however I am unable to make...Exception when reading MDB event history while calling OWA
I just installed an Exchange 2007 into a Win 2003 Server R2 X64 environment.
Before we had an Exchange 2003 - everything was running fine.
First we transferred the mailboxes to the 2007 an removed the 2003 from the
exchnage topology. Now the 2007 is the only exchange in the network - all
function within the domain are running fine, nor strange messages in the
We activated the OWA, installed an internal certificate and configuered the
SSL login / communication. Everything seems to be well.
Now after the successful login by HTTPS we get the following error message:
Re...using a With that references the calling object (or something like that)
Here's my code:
Private Sub ComboBox2_Change()
Range(ComboBox2.LinkedCell).Value = ComboBox2.Value
I need to do it like this, because for some reason just letting th
ComboBox update the linked cell causes all of the vlookups tha
reference that linked cell to return #N/A.
The issue is, I have MANY of these combo boxes, and don't want to g
through and change each one of these little functions to correct the
for each combo box. I would like to create a generic function, bu
don't know the correct syntax to do so.
---------------------...Distinguish help calls
On a dialog, how can I distinguish between the user pressing F1 and clicking
on the context help question mark and then somewhere on my dialog. I would
like F1 to bring up the main help system at the appropriate page and the
question mark to bring up context help (floating yellow text). At present,
pressing F1 lands in my OnHelpInfo method and I open the help system at the
appropriate page. Pressing the question mark brings up the context help
correctly, then lands in my OnHelpInfo method and I don't want to open the
help system, but can't tell which event caused the trigger of ..."Message delivery to the remote domain '<ISP SMTP server>' failed for the following reason: The connection was dropped by the remote host."
"Message delivery to the remote domain '<ISP SMTP server>' failed for the
following reason: The connection was dropped by the remote host."
For the past couple of weeks I have been getting the above message every
10-15 minutes on Exchange 2000 SP3, Windows 2000 SP4. The SMTP queue also
clogs up for a while then suddenly clears out.
I have asked our ISP to look at their end & they claim there are no
A while ago I had this problem & switching off 8 bit MIME appeared to work
(http://support.microsoft.com/default.aspx?kbid=262168). I have made no
...Outlook 2003 Remote/Internet
Is it possible to have one profile for Outlook 2003 for both local and
remote access to exchange?
Remote meaning no VPN, but using the "Outlook over the Internet"
functionality with HTTPS.
If so, how?
It should automatically use the same profile and credentials. What version
of Exchange are you using? (Outlook Web Access is actually a component of
Exchange, not Outlook - you would probably do better to ask in an Exchange
group - probably Admin.)
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. Due to
the SWEN virus, all mail sen...SQL Stored Procedure
Hi all -
I am wanting to use Access to run a SQL Stored Procedure. I've set up
ODBC connections to do other things, but I cannot figure out how to
connect to a Stored Procedure.
Thanks for any help!
On Feb 1, 12:19=A0pm, Dan <dan.ga...@gmail.com> wrote:
> Hi all -
> I am wanting to use Access to run a SQL Stored Procedure. =A0I've set up
> ODBC connections to do other things, but I cannot figure out how to
> connect to a Stored Procedure.
> Thanks for any help!
use ADO and you can go directly to the stored procedures collection.
Here...Calling function in conditional formatting expression
Does anyone know how or if you can call a function and pass it a control in a
conditional formatting expression of a textbox on a continuous form?
I've done some font size analysis and developed a function fnDoesItFit(ctrl)
which accepts the name of a textbox control. It then does a quick assessment
of whether the text in the textbox will fit within the area of the textbox
and returns a boolean value. I've implemented this in a single forms current
event and it works great to allow me to change the background color and
scrollbar property of the control based on the amount of t...Stupid Question: Remote Register for Shows
I'm having a lovely time trying to update the system at work to POS. The
conversion has been put off time after time due to the store being busy.
As it's a small retail shop, not a surprise, but it does make it difficult
to accomplish much.
Latest question to come up: We have a single regular register in the store.
We also have a laptop that the boss takes to shows to sell with. For
shows, it's possible that the boss will be away from the home store for
over two weeks. Are we going to have trouble (ie revert to eval mode) when
the laptop is away from the dongle for tha...Entourage and remote connection
Operating System: Mac OS X 10.6 (Snow Leopard)
Email Client: Exchange
My company is using Exchange 2007 and the PCs are using Outlook 2007 (or 2010). <br>
Outside connection from Outlook to Exchange is done using Microsoft ISA server and RPC over HTTPS (Outlook Anywhere using Exchange proxy) or OWA with RSA authentication (http://owa.server.com/exchange) <br>
When connection from outside company network, does Entourage support RPC over HTTPS (like Outlook Anywhere) ? Or does it support using ExchangeWebServices through the OWA connection ? A...User access via remote desktop
I have a situation where if I set a new user up from a local client,
they only can access GP via their local client - they get a login
error if trying to login via remote desktop.
Likewise, if I log into the server remotely and set up a new user,
they can login to GP remotely but not from their local client.
Any ideas why this would occur?
Frank Hamelly, MCP
NOVA Solutions LLC
Do you have any profiles that would be affecting where a user is using files?
I've seen this issue where one user's profile was different than other
Charles Allen, MVP
...Calling the Row Number?
I'm using the following function:
When I try to copy it down a column, the function doesn't change a
all, but I want the number "2" to reflect what row the function is on
Is this possible without making another column with number
Message posted from http://www.ExcelForum.com
instead of 2
"gorkyness >" <<firstname.lastname@example.org> wrote in message
> I'm using the following function:
...Year End Procedures #2
We will be going through our first year end close on GP10. I have a couple
of questions regarding the software.
1. Do we have to close 2008 before we can post anything into 2009?
2. Once we close 2008 can we go back and book journal entries in that year?
And if we can do we 'close' the books again.
Any assistance would be welcomed.
I have a blog post with a bunch of resources for the year end closing:
module could potentially have different answers to your questions, but in
...No e-mail in remote sites sometimes, but main location is fine.
About twice a week now, all of my three remote branch city sites will fail to
allow Outlook clients to communicate with the Exchange Server, but the main
HQ site works fine.
It can happen out of the blue, and there are no entries in the Event Viewer
after it happens. My only fix is to reboot the Exchange Server.
I can ping the Exchange Server by name from the affected branch store PC's,
and it comes back correctly, but will not allow e-mail.
Internet, databases programs, and printers all work fine during this,
showing that the networking is OK just not e-mail.
Exchange 2003 Server on...