Hi to all
is there any way to restore from database a mailbox in exchange2003 that was
Assuming you have backups look at the recovery storage groups
"Microsoft" <firstname.lastname@example.org> wrote in message
> Hi to all
> is there any way to restore from database a mailbox in exchange2003 that
> was deleted ?
...Update one table from another
I am trying to update one table that has one record for each employee(table
1) with available vacation time. The other table records every time off
request(table 2) and how much time they want off. I have the update query
and it works fine. The problem is that everytime it is ran every requested
time off amount(from table2) is subtracted from the available time(table1)
again and again. I want the records for requested time(table2) to update the
employee available time off(table1) only once, but keep the records on the
table as that is the basis for a report.
----=...How OMPM Scanner (offscan) Filter by Access/Modified Date ?
I have problem to inventory excel files on very big file server, but I
believe there are so many documents we no longer need to maintain.
I want to skip files if the access date or modified date longer than 6
month, but don't see the OMPM providing feature about it.
I currently running OMPM since 2 weeks ago and running out of time for
reporting to my manager.
Please help me, this is my critical assignment.
...Copying data from one chart to another
I have many graphs - all plotting on similar scales but using different
data. Is there any way I can simply copy one set of data from one graph
and paste it into another graph so that I can avoind going through all
the hassle plotting each curve again? I want to have graphs showing
different combinations of the same data and have hundreds of curves to
plot so this could be a huge timesaver...
Alan_Partridge's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=29295
V...The Sum from 1 worksheet cell to another worksheet cell
the sum from one cell on sheet1 from another cell on sheet2,how do you do the formula
To sum the value on Sheet1, cell A10 with the cell
value Sheet2, cell B20, enter =Sheet1!A10 + Sheet2!B20
(or you can enter '=' sign and click on A10, then enter
the plus sign and click on B20)
>the sum from one cell on sheet1 from another cell on
sheet2,how do you do the formula
...Mailbox Size #10
Does anybody knows if there is default mailbox size, when I tried to
configure the storage limits in AD over 2 gig a message said:
The value for 'Issue warning at (KB)' is not valid. Specify a value from 0
Using Windows 2003 server and Exchange 2003.
On Wed, 22 Mar 2006 14:01:39 -0500, "johnstep" <email@example.com>
>Does anybody knows if there is default mailbox size, when I tried to
>configure the storage limits in AD over 2 gig a message said:
>The value for 'Issue warning at (KB)' is not valid. Specify a value from ...comdlg32.ocx and Access 2007
I have several Access databases that were originally written using an Access
version prior to Access 2007. I am in the process of converting the
databases and installing them on new machines running Win7 and Access 2007.
Over the years, one of the References I commonly used was comdlg32.ocx. It
does not appear that either Win7 or Access 2007 installs that particular
Active X file. I can copy it from an older machine, but that seems like a
Is comdlg32.ocx a "legacy" Active X file and has it been replaced with a
newer (and differently named) Activ...Mailbox deletion in 2003
I have deleted and purged a users mailbox owing to corruption..ie not being
able to set permissions for other users to access their calandar.
I have created and applied against an existing user and have imported their
messages ok. They can send and receive ok...But!!!
Any messages before I deleted mailbox now come back as undeliveable..cannot
find recipient. If outside users reply to them.
How can I set the mailbox to recongnise incoming messages from replies.
Sounds like the SMTP address isn't the same.
For internal replies, failures would be caused by the legacyEchan...Importing Messages From Another Mail Program
I just set up outlook express 6.00.2900.2180 for XP SP2 and wish to import my
messages and folders from Netscape 7.0 mail and when I follow the
instructions and click on the netscape Local Folder inbox file, I get a
message from outlook that says there aren't any messages in the file. I tried
to mail the files as attachments but that didn't work. Is there some other
way to export these messages .to outlook express.
Ask in an Outlook Express forum. This is an Microsoft Office Outlook forum.
Outlook Express is family of Internet Explorer and Outlook of the Office
Here is...Error 2455 Closing Access 2007 database with form open
I have a form with a subform that is requeried when you select a new key for
the main form from a combo box.
Everything works fine - usually. But sometimes if you have the form open
when you close the database down you get the following error message (twice)
in a pop up. You say OK (twice) and the database closes OK
"2455 you entered an expression that has an invalid reference to the
If I close the form before the database I never get the error.
If I do not touch the form before you close the database I don't get the
If I update a field by t...Inserting Excel into Access Reports
Have a great Access application that produces a nice template (headers &
footers) report into which I'd like a spreadsheet inserted before going to
the printer. In the past, I'd just print the Access reports, then reload
them into the inkjet printer and run the Excel spreadsheets as needed. The
heat of the new color laserjet turns the paper grey if it runs through too
often, so it's time to get the reports printing on one pass.
Any suggestions would be welcome. I've of course also got Word XP, MS
Publisher XP, as well as Adobe Acrobat, if anyone thinks it m...Simple Access counting queries
Hi, hoping someone can help a relative newbie with a pretty simple
query. My database (Access 2007) has three tables:
Purchases (many-to-one links to both of the other tables, this is
basically a linking table)
I have two simple queries I'd like to get out of this database, but
I'm a bit stuck on how to construct the SQL. Any direction you can
give me would be helpful.
1. List of all customers who have purchased 2 or more products (or 3
or more products, or 4+, etc.)
2. List of all customers who have purchased both Product A and Product
B (or A, B, and C, or B an...How to get only the year in the date format in Access
How to get only the year in the date format
I.e in the table in need to display only year
E.g 2005 - should be display " 05" automatically
Custom format the cell as:
Please keep all correspondence within the NewsGroup, so all may benefit !
"yanu" <firstname.lastname@example.org> wrote in message
> How to get only the year in the date form...Expression Too Complex in Access 2000
Consider the following query:
SELECT crTbl.acct_1, crTbl.amount, crTbl.date
WHERE (((crTbl.acct_1)="Supplies") AND ((crTbl.date) Between
The query works fine on my own computer in Access 2002.
When converted to Access 2000 and used on an other computer,
I get the following error:
"This expression is typed incorrectly or is too complex to be evaluated.
Try simplifying the expression by assigning parts of the expression to
The problem is with the "Between...How do add another code to a current one?
I have this following code to make the rows changed based on the critea in
column 16, and I need add A "Red, Yellow, Green" for status to only one
column 30 at the end of the spreadsheet. How do I add another code? I keep
getting an error..
Private Sub Worksheet_Change(ByVal Target As Range)
Dim c As Range, clr As Long
For Each c In Target.Cells
If c.Column = 16 Then
Select Case c.Value
Case "Analyze": clr = RGB(204, 255, 255)
Case "Build ": clr = RGB(204, 255, 255)
Case ...groups detail section totals access 2003
I know this can be done, but haven't figured out how yet. I have what
basically is a summary report that my sql comes up with for the detail
rows. I want to total these rows in the report and display
immediately below the detail section. I don't really want to group
anything, but want to treat the whole detail section as a group.
That being said, how can I get a "group footer" on the designer so I
can add my total columns. If I use "sorting and grouping", it starts
grouping things and that is not what I want.
I don't want to use the "page foo...Problem creating new mailbox
I'm trying to create a new mailbox, I've done this tons of times but this
time I'm getting a problem.
I created the user and then the respective mailbox with no problems.
I then went to the users properties to create e email address, choose SMTP
and inserted the address with no problems.
The other times after some seconds exchange would automatically create de
X400 Address but this time it doesn't, the user won't appear in the global
address list and when I configure Outlook 2003 and click "check name" it
says it cannot find the user.
Last friday I cr...Mailbox needs reducing
We have this mailbox that has been left for months and with no limits, it's
Ho can I trim in down, I don't really want to go into the mailbox and do it,
can Exchange do it?
Gonzo <email@example.com> typed:
> We have this mailbox that has been left for months and with no
> limits, it's now 11GB!!
> Ho can I trim in down, I don't really want to go into the mailbox and
> do it, can Exchange do it?
Presuming you're not on 5x or earlier, you can use mailbox management
policies to get rid of items ol...Cannot create mailbox for new user accounts
I am running Exchange 2003 on Server 2003. I was able to move all existing
mailboxes from my old Exchange 2000 server to my new 2003 server. Whenever I
try to create a new user it creates the user normally and asks if I want to
create a mailbox for the user. I check yes, and it says account created
successfully. However, the mailbox never appears in Exchange, no email
address is assigned to the new user, and I cannot send mail to the user
account either. If I try to access any Exchange properties from ADUC it
shows everyhting as if a mailbox exists, but there is no mailbox. I am
...Forward a Task For Someone Else To Track
I have no trouble assigning a task but when I ask someone to forward their
task to me to track it does not show up on my task list or in any of the
other views... help PLEASE :)
...Mailbox permissions #17
I have a bit of a mess with a mailbox that receives all messages that clients
send through our web site. Everyone except one person has this additional
mailbox open within Oulook. The remaining person I can't seem to get the
permissions down. I myself have it added on my desktop. The only reason I
think I can expand the mailbox is because I'm in the enterprise admin, domain
admin, and exchange admin groups. When I look at the properties of the
mailbox, my account has "None" as so does this other employee. When I click
on my account, the employee's account wo/ ...Exchange 2003
I've set up a policy that deletes items in the "Deleted Items" folder that
are 7 days old (no size limit). For some reason Mailbox Management finds no
deleted items. See the email I receive below...
The Microsoft Exchange Server Mailbox Manager has completed processing
Started at: 2006-02-25 00:08:58
Completed at: 2006-02-25 00:08:59
Mailboxes processed: 0
Messages moved: 0
Size of moved messages: 0.00 KB
Deleted messages: 0
Size of deleted messages: 0.00 KB
The information store is 82 GB's big...there is no way there are no deleted
items. I've had this pr...Remote access to another company's Outlook calendar?
I have one client on Exchange 2003 that wants to access the calendar of an
employee (consultant?) at another company running Exchange (version not
known yet). How can the remote company share this person's calendar with my
client? He would need to access it and add appointments to it.
Thank you for the help!
On Mon, 30 Aug 2004 22:15:24 -0700, "Gregg Hill" <firstname.lastname@example.org>
>I have one client on Exchange 2003 that wants to access the calendar of an
>employee (consultant?) at another company running Exchange (version no...Can't connect to Exchange server after VPN access
I can connect to my office Exchange server when in the office (LAN) but I
cannot connect outside with Outlook.
I can only use the webmail after entering a web VPN access:
- First portal for VPN : https://xxx.yyy.com --> I enter my
- On the next web page, I have the choice for the webmail and it's a link as
https://xxx.yyy.com/go/webmail.yyy.com~ssl where I can enter my
So I can't enter the url in RPC as every slash is forbidden
In my Outlook, the Exchange server (EXC.yyy.com) is not reachable by ping
(or tracert) and I can't ...disable mailboxes
We have a number of Windows users whose Windows account has been disabled.
Now the exchange server reports error events for each of those users,
because the mailbox is not associated with an active user account.
Short of deleting the mailboxes, is there anyway to get Exchange to (reject
the mail and) not report error events for those mailboxes.
- David Aschmann
MCSE: Messaging, Security+
"david epsom dot com dot au" wrote:
> We have a number o...