Delete table values automatically
I want to create a routine that will clean all records from a specific table
automatically once a week (if possible) or each time that the MDB opens up.
Thanks a lot in advance
the code to empty a table is simple
Public Sub EmptyTable()
Dim strSQL as String
Dim db as DAO.Database
Set db = dbengine(0)(0)
strSQL = "DELETE FROM TableName"
db.Execute strSQL, dbFailOnError
Set db = Nothing
the above code goes in a standard module
when your database opens, you call the routine EmptyTable
"Lp12" <Lp12@discussion...Folder Creation slow in Exchange 2003
I just got through an Exchange 5.5 to 2003 migration, and am working out the
kinks. One thing I noticed, when I create a folder in Outlook (i.e. task
list, contacts, calendar, etc.) it takes like 4 minutes to add it. Using
Exchange 5.5, it was pretty much immediate. Any ideas?
I do still have the 5.5 server in the organization, but it's shutdown.
Could this have an impact?
...Corrupt inbox in Outlook 2007?
Very frequently, I'm in my Inbox and I see new mail has come in. On
the mail folders to the left, I see the unread emails number continue
to count but the messages don't show up. The only way to get them to
show up is by clicking out of the Inbox to another folder and then
clicking back on the Inbox. Whenever this happens, I also get error
messages on startup telling me that outlook didn't close successfully
last time. Any thoughts on either?
What OS are you using? This was a common problem using the Windows =
Firewall in Windows XP SP-2. =20
Milly Staples [...Message Tracking XML File
Is there any utility out there that can read the XML file saved from the
Message Tracking Center, and present it in an easily readable format? MS
explains the XML schema at
http://msdn.microsoft.com/en-us/library/ms987640(EXCHG.65).aspx but doesn't
offer a program to do anything.
which looks like it'll take the raw log files themselves and convert them
into XML, which isn't what I need.
Nevermind....Quotes in money 2007 stopped working
Anyone else having problems with Money 2007 downloading quotes? Mine
stopped about 10 am.
Same here JC.
"JC" <email@example.com> wrote in message
> Anyone else having problems with Money 2007 downloading quotes? Mine
> stopped about 10 am.
...Office 2007 will not install on 1 particular Windows 7 machine
I have just performed a custom install of Windows 7 Pro on a computer that
has been running Windows Vista Ultimate and Office 2007 successfully for
several years. I had some trouble geting a stable installation of Win 7 but
after an expensive visit to the Geek Squad, which determined that a
particular Windows update was causing the system to crash, I now have a
stable installation. (They disabled that particular update, too.) The
problem is that I am unable to install any of my fully-licensed copies of
Office 2007 on this machine, even though I have it running happily on two
...Cannot Install Exchange 2003
Ok, I'm, stuck. I have completed all prerequisites for Exchange 2003 install
and still receive this error when Site Replication Service is being
Setup failed while installing sub-component Site Replication Services with
error code 0xC1030B11 (please consult the Installation logs for a detailed
description). You may cancel the installation or try the failed step again..
I have done everything in MS KB 83395 on this and still it continues to
fail. the one problem I have with the KB article is that it tells you to
change the passwords for this service to be the same on the...Exchange 2003 Enterprise / Public Folder Store
I have the following configuration:
- Windows 2003 SP1 with Exchange 2003 Enterprise SP2
- 2 OU with users
- each OU has it's own GAL, AL and OAB
I created two public folder stores for each OU and to give each OU access to
a public folder store. But I even can't my additional Public Folder Store in
Outlook. Additionaly I try to replicate one OAB to the additional Public
Thanks in advance.
"But I even can't my additional Public Folder Store in Outlook. "
You want to clarify that?
"Fabian K�lling" <FabianKlling@dis...multiple copies of mail
After reinstalling XP and outlook 2002, I have started to get 2-5 copies of
mail (not every mail). This wasn�t a problem before (when I used outlook
Any ideas where to start looking?
"tomppa" <firstname.lastname@example.org> a �crit dans le message de
> After reinstalling XP and outlook 2002, I have started to get 2-5 copies
> mail (not every mail). This wasn�t a problem before (when I used outlook
> Any ideas where to start looking?
If you get as ...Tagging and routing mail destined for specific domains
Due to a change in NDA's I need to be able to tag, and copy mail that
is being routed to and from specific domains. I am using exchange 2003
std (sp2) on 2003 server. As an example if a user were to send an
email to microsoft.com I need to add a legal disclosure footer and keep
a copy of that email locally. The same would be needed on inbound mail
from microsoft.com to be copied to an additional location internally.
Is this something that exchange can handle or do I need to route this
through a second system to get this kind of tracking, etc..?
On 7 Dec 2006 15:10:57 -0800, natedizzy@...Outlook 2003 Cannot Send Mail via POP/SMTP
I have a number of remote users who POP's mail into and out of our
Exchange 2000 box. One is unable to send mail to anyone (either within
the organisation or to external addresses), so I have temporarily
discounted relaying as an issue, although I have checked the settings
on the virtual server and they are all correct (allowing authenticated
users to relay mail etc.) Receiving seems OK.
The user has Outlook 2003 (fresh install) on Windows XP (fresh
2004.07.29 15:29:39 <<<< Logging Started (level is LTF_TRACE) >>>>
2004.07.29 15:29:39 server.d...Word 2007
I used to be able to open Word 2007 documents in Word 2003, taking advantage
of the compatability pack. It is still installed, but I can no longer open
the 07 documents in 03.
Please advise what I should look for as a potential problem?
"Kelli" <Kelli@discussions.microsoft.com> wrote in message
>I used to be able to open Word 2007 documents in Word 2003, taking
> of the compatability pack. It is still installed, but I can no longer
> the 07 documents in 03.
&g...New mail notification #12
I have become more adventurous in my email setup, as a consequence,
not much mail goes to my default inbox. I found the 'new mail'
notification very handy. I am disappointed that I cannot see a way to
set it so that it notifies me if any folder gets new mail.
Is there anyway to set this up? I don't mind modifying the registry
directly if necessary.
** Stress - the condition brought about by having to
** resist the temptation to beat the living daylights
** out of someone who richly deserves it.
What version of Outlook are you using?
Ben M. Schorr, MVP...To organize Outlook 2002 junk mails
How to save the settings for the said subject?
email@example.com <firstname.lastname@example.org> wrote:
> How to save the settings for the said subject?
Since Outlook 2002 doesn't have a Junk E-mail folder and doesn't filter junk
mail well at all, why not describe exactly what you hope to accomplish?
...I can't set up Outlook in Office 2007
Office Small Business 2007 came installed on my new computer.
When I try to use Outlook, it starts to configure, and then I get a message
that "Connection to Microsoft Exchange is unavailable. Outlook must be
online or..." It then takes me to a menu "Microsoft Exchange" with a General
tab asking for Name of Server and then Mailbox Name.
I have no idea what to enter. So I'm stuck.
Furthermore, it's important that I synch with my BlackBerry but it has to be
done through Outlook, and that's impossible this way.
A moderately expert us...Shifting my Office SB 2007 MLK OEM Software on another computer
I have MS Office SB 2007 with Office Professional 2007 Trail With MLK OEM
I want to format that PC because I have some OS issue.
How can I De-Active that license?
can I use that License key after format that PC?
Thanks & Regards,
"Hitehs Prajapati" <Hitehs Prajapati@discussions.microsoft.com> wrote in
> I have MS Office SB 2007 with Office Professional 2007 Trail With MLK OEM
> Software License.
> I want...Safe to delete the default address lists?
I'd like to replace the default address lists (All Contacts, All Groups &
All Users) with customized address lists.
Is it safe to delete the default address lists or can they be hidden? The
existence of both the default & custom lists is confusing the users.
Yes, they can be deleted. You can use LDIFDE to export them first - in case
you need to recreate them the ldf dump will make it a snap.
MVP - Exchange
NEW blog location:
"David Agosta" &...Mail-Merge: Better in CRM 4.0
have a question:
Is the Mail-Merge functionality in CRM 4.0 better than in 3.0? The
restricted field access for the Mail-Merge in CRM 3.0 is bothering me
a lot and I am thinking of updating if 4.0 is better in that area.
Thank you in advance!
Download the VPC and try it out
We don't know what your expectations are but all in all - the Outlook client
is much much better
"Harald Battran" <email@example.com> wrote in message
>...Why do HTML versions differ when sendiing template as mail or as autoresponse? #2
Is this the cause why HTML templates look different when send as
Created *.oft templates and their derived emails have HTML version
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
Sending the *SAME* template as autoresponse mail has HTML version
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
I used the SAME account and the SAME template (in HTML 4.0).
Why is the autoresponse mail SENT in a lower version that it's
originating HTML *.oft template ???
Clues are highly appreciated!
(wrong setting, old DLL's, bug or wha...Exchange 2003 SP1 and IMF
Here is something tricky.
I have windows 2003 SP1 and exchange 2003 SP1 cluster machine. I never
installed IMF. Ever since I have the cluster working, I keep get 9661
information. LIke this
Event Type: Information
Event Source: MSExchangeIS
Event Category: General
Event ID: 9661
Time: 4:17:46 PM
The Unsolicited Commercial Email default filter level has been updated.
The new value is 5.
I was told that IMF will not work on cluster. I checked in m$ website
that this information means IMF is working. I do not want this function
a...Frontpage required during Office 2007 in Vista
I have successfully installed MS Office 2007 Enterprise on Vista. When I
opened MS Word files, everything looks fine. Typing in other language
(Korean) forced MS Office to look up FrontPage and got an error message
saying "Insert Windos Office XP Professional with FrontPage" I could not find
FrontPage in the CD and could not resolve the problem yet.
Welcome any idea of how to fix it,
Suggest you post to an Office or Word newsgroup or Forum - from your
description the error may mention FrontPage, but has nothing to do with that
program. No version of Offic...Exchange 2003 #25
I install Exchange 2003 on Windows 2000 server,
I try to configure MAILBOXE in one workstation with win2000 PRO, with
OUTLOOK 2000 , and get the Error " OPERATION FAILD" whene I press the check
localy on the server I can use the outlook,
In the workstation I see the server by \\server . and By ping server .
What Can I do?
...Exchange 2003 : Log for an email process...
How do I check the log for an email. For example, user A mailbox, what is
the incoming and outgoing emails for that mailbox for the past few days ?
Use the Message Tracking feature in Exchange System Manager. This uses the
tracking logs held in the servername.log share under your \exchsrvr folder.
There are 3rd party tools that can elaborate on these logs, two of which I
For Exchange news, links and tips, check:
&quo...Rule applied after Junk Mail Filter
Are all rules applied after the Junk Mail Filter. I am trying to filter out
certain types of messages but some of them still end up in the Junk Mail
Box. Is there any way to have the rule run prior to going into the Junk Mail
filter? I have the filter defined to run as soon as the mail arrives and it
is on the top of the list.
no. rules always run after junk mail.
Diane Poremsky [MVP - Outlook]
Author, Teach Yourself Outlook 2003 in 24 Hours
Coauthor, OneNote 2003 for Windows (Visual QuickStart Guide)
Need Help with Common Tasks? http://www.outlook-tips.net/beginner/
O...[Announce] Stylus Studio 2007 Reviewed by CRN Magazine
[Announce] Dear microsoft.public.dotnet.xml,
Stylus Studio ( http://www.stylusstudio.com ) was reviewed in CRN
Magazine. You can read the article entitled "Create Powerful XML
Solutions Without Coding" at:
In the article, CRN describes the program by saying, "There is little
need to write code from scratch in Stylus Studio," referring to the
new XML Pipeline ( http://www.stylusstudio.com/xml/pipeline.html ) and
XML Publishing tools ( http://www.stylusstudio.com/xml/publishing.html
) that are ...