Using data from cells in a Query to a MS Access Database
I need to use a MS Excel 2003 spreadsheet to perform a simple set of calcs.
One piece of information I need is stored in an Access Database.
If I could have, I would have converted the spreadsheet to an MS Access
database and programmed the query to use information from text boxes.
However, not all employees in the company have MS Access on their computer.
So I need to use an external query in Excel to look at the MS Access Database.
I can do that pretty easily. The Query Wizard walks you right through it.
However, I need to make it so that the criteria for the query is drawn ...MS-Word to XML to HTML
I have a need to convert MS-Word Documents (6.0 / 97 / 2000 / 2003)
to XML and from XML to HTML.
This needs to be done programmatically with C/C++/C#.
Any information on doing this would greatly be appreciated.
...Making Exchange 2003 server a DC/GC server?
Is it now a recommended practice to make a primary corporate Exchange
2003 server an AD domain controller/GC server, so that the Exchange
server can do local GC lookups faster (as long as the server has the RAM
I have never seen a recommendation that this is a good practice. While
"best practices" for some things change over time, I think this is still a
bad idea (IMHO). In an environment with more than a few hundred users, it
is just a bad design. Small organizations can't afford this, of course, but
larger ones can and should put their D...SMTP/FATAL: Server sent a bare LF
Exchange Server 2003
Windows 2003 Server
Spam.xxx.org is a Modus Gate spam appliance
some users get the following failure error:
XXXX@pivot.net on 5/19/2005 8:12 AM
The e-mail system was unable to deliver the message, but did not
report a specific reason. Check the address and try again. If it still
fails, contact your system administrator.
< spam.XXXX.org #2.0.0 smtp; 501 MessageWall: SMTP/FATAL: Server
sent a bare LF; please see http://cr.yp.to/docs/smtplf.html>
Spring Harbor Hospital
Do you use qmail at all? We use qmail as an SMTP relay an...Send/Receive isn't transmitting e-mails from pop3 server
As far as I can trace, I downloaded XP SP2 and since then
Outlook no longer can receive files from my pop3 server
set-up. I removed XP SP2 and I still have the problem.
I click on send/receive, it shows everything to work but
e-mails are remaining on my internet e-mail server and
not being transferred to Outlook. It was all working a
few days ago.... Any advice?
"Outlook 2000 SR-1 & Windows XP - Send/Receive"
<email@example.com> wrote in message
> As far as I can trace, I downloaded XP SP2 and si...Exchange 5.5 (VPN/External Access)
We currently use exchange 5.5 (win2k server) for our postoffice and im
currently looking into giving a small amount of users access to their
email from home.
How secure or what are the best practices in this situation....?
Custom Recipient (just forward email to their home account)
Lets just leave this one out for the moment as i know all about this....
Each of these scare the hell out of me as the client machines will
largly be out of my control. I think the VPN option scares me the most
as this will give most access, whereas with the other two i'm...Exchange server resending message
I have a SBS2003 server that uses a pop connector to pull over messages from
an ISP. The server has been resending an incoming message that has over a
thousand recipients! One of my users got an email from a Professional
organization he is a member of. Every time he gets a copy of the message, the
server starts sending out a flurry of these messages. I spoke to the
organization and they informed me that there have been thousands of returned
mail. I have checked the server for viruses but have found none. I have up to
date versions Symantec Antivirus Server and Exchange Antivirus by Syma...Upgrade GP 10 and Citrix terminal server
We upgraded SQL Server to Windows Server 2003.
Now I read that a Terminal Services Server has to have Windows Server 2003
as well. Is this only if the TS is used as the server? We have GP installed
as a client and all the outside users connect to it (Citrix 4.0). If this is
so, then I have to delay my upgrade another 2 weeks :(
What about client workstations? Can they run Gp 10 if they only have office
2000? I know some new reports go to Excel, and that is probably why it says
Office XP, 2003 or 2007 is required.
Can anyone please respond ASAP? Our VAR is out of the office today, and I...12.1.1 connection to update server interrupted (Message)
Operating System: Mac OS X 10.5 (Leopard)
The subject message has been repeated every time I have tried to download the update since its release. The server can't still be busy, can it? I've checked my connection settings and everything is fine.
This seems to be a different problem than not seeing the Office volume on the hard disk.
Any help would be very much appreciated!
> The subject message has been repeated every time I have tried to download the
> update since its release. The server can't st...Exchange 2003 Public Records Requests
Hello all --
I am the Exchange 2003 administrator of a large (500+ users) library. We
have a public records requirement that says we have to keep email for a
period of three years. However, our top 10 emails users have information
stores of anywhere between 1.5G to 2.3 gigs!
I would like a way to clean up their deleted items folder of all emails that
are older than three years. Is that possible? And if so, then how?
Check out the functionality of the Mailbox Mananger in combination
with recipient policies. You'll probably need to do some reading (the
M...Exchange 55 mailbox issue
We have deleted mailboxes still appearing in the IS database. Some mailbox's
still appear in the Mailbox resources under Private Information store of the
server object. We have a single exchange 55 server in our site which
communicates with our head office running in a different site.
What can be done to remove these deleted mailboxes from the IS database.
Have you done the knowledge consistence check ?
If it do not help make a eseutil /d and "isinteg -test alltests - fix
-detailed". I had the same problemes with some servers after migration the
mailboxes to Ex...How do I open port 389 (LDAP) on exchange server
I have an application that we want are using to download from LDAP our
exchange active directory users. When I scan the exchange server on port 389
the state is closed. How do I change the state to open. Can anyone also brief
me on the security risk of opening that port.
Thanks in advance.
On Thu, 13 Jul 2006 09:58:02 -0700, Brillmike <firstname.lastname@example.org>
>I have an application that we want are using to download from LDAP our
>exchange active directory users. When I scan the exchange server on port 389
>the state is closed. How do I change the state to open. Can...Can OfficeX open MS Publisher files?
Does anyone know of a way that OfficeX can open or
translate files created in Publisher? It is the one thing
that I really miss and need when working back and forth
between my G4 and PC files.
On Sun, 28 Sep 2003 15:06:23 -0700, "Natalie"
>Does anyone know of a way that OfficeX can open or
>translate files created in Publisher? It is the one thing
>that I really miss and need when working back and forth
>between my G4 and PC files.
AFAIK you're SOL...
("As far as I know you're shit outta luck")
to open ...LCR question in Exchange 2007
With LCR are all the transaction log files copied from the production storage
group to LCR copy? if a transaction log file is created on the production
storage group is this log file also copied to the LCR copy?
On Mon, 25 Sep 2006 13:07:01 -0700, skip
>With LCR are all the transaction log files copied from the production storage
>group to LCR copy? if a transaction log file is created on the production
>storage group is this log file also copied to the LCR copy?
But remember there can only be one sto...Access 2007 update queries does not update table in SQL Server 200
We have this application upgraded from Access 2003. This application is front
end to SQL Server 2005. When we try to run any action queries, Access will
show command executed successfully but it will have no effect on the table in
This happen when we use WorkSpace and Begin Transaction. Any updates we do
between Begin Trans to Commit trans will have no effect.
UPDATE: We are using ODBC to connect to SQL Server 2005
> We have this application upgraded from Access 2003. This application is front
> end to SQL Se...Fix in for Money 2004, and before, Passport server problem.
New information has been posted on
regarding the fix to the Money 2004, and before, Passport server
The best thing would be to wait until Saturday to let the fix get
propogated thru the servers.
In message <email@example.com>, Cal Learner--
MVP <firstname.lastname@example.org> writes
>New information has been posted on
>regarding the fix to the Money 2004, and before, Passport server
>The ...Exchange 2007 #8
If anyone here can help with two problems I would be forever grateful!
Details: 2000 & 2007 co-existence
1) I can no longer send email to any of the 2000 mailboxes. I can receive
from 2000 or external, I can send to 2007 or external, however, I cannot
send to 2000 internal mailboxes. Examining the Queue Viewer I see that the
mail is getting stuck and that the last error states: 451 4.4.0 Primary
target IP address responded with: "535 5.7.3 Anonymous authentication is not
allowed." Attempted failover to alternate host, etc...etc.
2) OWA no longer works via SSL. I t...add microsoft exchange sever
I need to add exchange sever to Outlook 2003, but when I add as new e-mail I
get an error has to be added fron mail icon in control pannel. which is not
What OS are you using?
Milly Staples [MVP - Outlook]
Post all replies to the group to keep the discussion intact. All
unsolicited mail sent to my personal account will be deleted without
After furious head scratching, bb asked:
| I need to add exchange sever to Outlook 2003, but when I add as new
| e-mail I get an error has to be added fron mail icon in control
| pannel. which is not present.
...MS Office Project 2007 SP1 on MS Windows 7 problem
I have setup MS Office Project 2007 SP1 on MS Windows 7. When I use MS
Office Project 2007 SP1 with MS Project Server 2007 SP1 connection, I cann't
select pulldown Custom Enterprise Fields. When I work on Windows XP, Custom
Enterprise Fields perform correctly. There is no error information in a
Could you help me to fix a pulldown Custom Enterprise Fields whith MS
..."Server Error in '/' Application" when adding a new Contact
Since applying roll 2 5 weeks ago, we started getting the error below when
adding a new contact inside an existing customer.
Can anybody help? the error is as follows:
Server Error in '/' Application
The parameter is incorrect.
Description: An unhandled exception occurred during the execution of the
current web request. Please review the stack trace for more information about
the error and where it originated in the code.
Exception Details: System.ArgumentException: The parameter is incorrect.
So...Integration of project server 2007 and moss 2007 on separate serve
I have two server in one i have installed single server installation of
project server 2007 in which and on the other server separately i installed
moss 2007 and make Database server of MOSS 2007 is Project Server 2007.
Now we can integrate Project Server 2007 and MOSS 2007 in this way and want
to configure proposal workflow.
Because i dont want to install moss 2007 in existing installation of project
If you want to combine MOSS with Project Server, you need to make the two
servers part of the same farm and both need to have the same software
insta...cant telnet to exchange port 25 from exchange machine ?
Simply im trying to connect to 25 using "telnet 192.168.0.10 25" from cmd
prompt on the actual exchange server (also tried from one other server).
- simple mail transfer protocol is running
- smtp virtual server is listening on 35
- portreporter shows TCP, 11956, 192.168.0.10,25, 184.108.40.206,7848,
- no other port 25 shown in port reporter (ie "SMTP" not shown in log file)
- all outlook clients point to exchange server (192.168.0.10) so must be
using it for smtp.
1. I cant find SMTP on the list (does inetinfo.exe cover SMTP as its all
I kno...How to add a new domain to Exchange 2003?
We are running Windows 2003 and Exchange 2003. Our email domain is
"mycompany.com". We would like to tell Exchange also except email for
domain "newdomain.com". How do I add that at the Exchange level? I now
about DNS, MX records and all of that. We don't need all of that, we are
just running a test. Thanks for any and all help.
"Clayton Sutton" <n...OT
Is the Microsoft Exchange website down, by chance?
When trying to access the ExBPA Page or the Exchange 2003 SP1 page, or the
/exchange/library page, I recieve a Page not found error (Can't post it due
Error page that launches:
When I try to access the main Exchange page, it now comes up with a 403
Bob Christ...Exchange Delivery Delay (Error 4.4.7)
We recently installed SBS 2003 and are using Exchange 2003
for email. Everyone can log in and use exchange with no
problems. All seems to be working ok.
But some of the users are getting Non Delivery Reports. On
some email messages.
The reports are in the following formats:
This is an automatically generated Delivery Status
THIS IS A WARNING MESSAGE ONLY.
YOU DO NOT NEED TO RESEND YOUR MESSAGE.
Delivery to the following recipients has been delayed.