Running Access Query Returns Incorrect Number of Records
I am running some code which loops through and runs the queries in an
Access Database. The count of the records is then stored in a
For most of the queries, the figure stored in the Worksheet matches
the number of records if you run the query in Access. But for certain
queries, the count of the records does not match the number of records
when the query is run in Access.
If I change the query to a make table query and then base another
query on that table, the results are correct.
Can anybody suggest running the query from Excel would results in a
different number of records bein...como utilizar o access
ñ sei utilizar o access, preciso de ajuda!
Mary Sauer MSFT MVP
"garcia" <firstname.lastname@example.org> wrote in message
>� sei utilizar o access, preciso de ajuda!
I have set a user up so they can view another user's
inbox, calendar etc, but wish to allow the delegate
access to the other users folder via the Folder List,
rather than them having to go to File, Open, Other User's
How can I do this?
...Accessing user Mailboxes
I recently upgraded from SBS2K (exchange 2K) to Windows Server 2K3 and
Exchange 2K3 Enterprise. Before in exch 2k, I was able to access the other
users mailboxes. Either by File - Open Other Users folders, or by adding
the user from Tool - Email Accounts - View Change ..... Advanced tab - Add.
My Id is a member of the Administrators tab...
Is this still possible in 2k3? If so how?
You may want to take a look at the following article to grant an account
service account access to other user's mailboxes:
821897 How to assign service account access to all mailboxes...Task delegation not working
After reformatting my hard disk and reinstalling Windows, almost everything
on my computer works again. The one thing that doesn't is a bizarre change
to the way Outlook 2000 handles task delegation.
In the past, I could assign a task to a colleague, and it would appear on
both my colleague's and my own task lists. When my colleague completed the
task, I would get an 'update' message, and the task on my list would be
marked as completed.
I can still delegate tasks, but I no longer get the automatic updating of my
task list when they are complete. On my colleague's compute...Outlook Web Access Reply feature
I access our coporate exchange from two PC's at home using outlook web
access, on one PC all is fine. On the other, when I reply to a
message, I cannot access the body of the message. The option to press
space and then type does not appear. Shows an "x" similar to that
shown on a web site when image is not downloaded.
I suspect there is some Active X or similar control that has not
How can I fix this?
Oh yes, this PC on running Vista Ultimate.
Try reposting to an Exchange group as OWA belongs to Exchange, not =
Outlook. microsoft.publ...Convert secure access 97 dbase to access 2000
Anyone give me the easiest solution to converting a secure
access 97 database to a secure access 2000 database?
Open it in 2000 while joined to the 97 version mdw (2000 can read/use 97 mdw
files fine), and logged in as a member of the Admins group.
Another alternative is to open it in 97, unsecure it, convert it to 2000 and
Microsoft Access MVP
"Michael Curtis" <email@example.com> wrote in message
> Anyone give me the easiest solution to converting a secure
> access 97 database to a secure...Outlook blocks access
I am trying to sync my large address book in Outlook with
my phone using Bluetooth. When I open the connection
Outlook tells me an application is trying to open Outlook
& allows a maximum of 10minutes to get the information it
requires. Unfortunately that's not enough time for my
phone to sync all the contacts.
Can I disable this feature on a temporary or permanent
or can I increase the maximum allowed time currently
offered by Outlook.
Any help gratefully received
Check with your synchronization tool vendor for a newer version that avoids
the security prompt....Exclusive access in a shared environment
I'm having trouble with an application I'm distributing to multiple users on
a local network.
A certain percentage of the users are getting an error message saying that
they do not have exclusive access to the database and that 'any changes will
be lost'. The worst part is that this message is a 'looping popup', that is
when you click 'ok' the popup immediately reappears, ad infinitum.
-- These users have read/write access to the shared files in question.
-- Even though the looping popup effectively crashes the app, the ldb file
is being succe...Delegations?
Hi all, at work I am trying to set up a delegation. I am the boss and going
on holiday....I need my delegate (another member of my team) to be able to
access my email. I have set him up as a delegate with the correct
permissions BUT, is there any way he can gain access to my outlook inbox
automatically without having to do the FILE >> OPEN >> etc thing?
The mailbox owner (you) needs to grant Reviewer permission to the root of
the mailbox, as well as appropriate permission on the folder.
The user who needs access then goes into Tools | E-mail Accounts or Tools |
Servic...Too much access using Delegates.
Windows 2000 Server, Exchange 2000,
Outlook 2000 & XP mail clients.
10 Users, all are in the Domain Users Group,
Each User's MailBox Permissions is set to
Defualt - None.
Without even adding anyone to the Delegates Tab List,
users are able to add additional mail boxes, and view
the complete Mailbox tree of the added user.
We are looking to implement Delegates, but I haven't
been able to limit what users view additional mail boxes.
Sounds like someone mucked with the original/default Exchange permissions.
This doesn't happen by default. See the...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...eConnect Access Denied
I am trying to call the Com+ object in eConnect 8.0 from a
windows forms application and I am getting an Access is
Denied error. After the installation the COM+ object in
component services is configured as activation
type "Server Application", Impersonation Level -
"Impersonate" and Account - a domain user who has SQL
Server access and is a member of DYNGRP.
If I change the activation type to "Library Application"
it works, but then I can not use this with a web
application that calls the eConnect 8.0 component. I need
to configure the component in a w...Accessing Google SDK from Powershell.
So, far, I have managed to load the DLL libraries.
I have even managed to connect to picasaweb as a service.
Has anyone out there done anything with Google SDK in powershell? Is
Zend a requirement for .NET?
Thanks in advance!!!
Sorry, which SDK exactly?
"firstname.lastname@example.org" <email@example.com> wrote in message
> So, far, I have managed to load the DLL libraries.
> I hav...Delegate permissions lost after migration
Currently we have a exchange 5.5 and 2003 server running. We've migrated a
small pilot group but i've noticed the following:
When the users were migrated I cannot seem to set the Delegate permissions.
From Outlook 2003>Tools>Options>Select Delegates.
I add the proper user, add views and click apply>OK. Go back to double check
the permissions and the delegate I've just added is gone. For some reason it
is not retaining the settings.
Not too sure what else to look into.
Anyhelp would be appreciated.
I have imported address books for our salespeople and
want my department to be able to send out "blast" emails
on their behalf. All of the permissions seem to be set
just fine, BUT... when I send out the email merge, the
sender shows as me not the salesperson that I've chosen.
I know I can go into options and select the "reply to"
email address, I've also choses options, "From" and put
in the salesperson's email address. What am I doing
...how do I access my home cpu from work
I use hotmail at home. I receive my hotmail messages via Outlook frame. I
just want to be able to receive files (if possible) at work. HELP!
"D in Seattle" <D in Seattle@discussions.microsoft.com> wrote in message
>I use hotmail at home. I receive my hotmail messages via Outlook frame. I
> just want to be able to receive files (if possible) at work. HELP!
So you work bans your access to Hotmail and you think they really want you
downloading attachments from your Hotmail account to your, oops, *THEIR*
hosts?...Change data and form crashes Access
I have a split database in which there is a form based on a table (let's call
it Frm2). It has about eight fields on it, four comboboxes and four
textboxes. The form opens from a button on another form (call it Frm1),
based on the same table. When I close Frm2 I go back to Frm1. Seems
straight forward enough. If any data is changed on Frm2 it causes Access to
crash upon closing Frm2. If no data is changed, closing Frm2 causes no
Frm1 has a Tab Control on it with a subform on most tabs, each based on
seperate tables, and linked to the record on Frm1. I've recreated Frm2...Open an excel spreadsheet and run a macro from Access VB
I have an Access 2007 database that creates an Excel spreadsheet via the
DoCmd.OutputTo method. The method creates and opens the Excel spreadsheet.
Is there any way to have Access run an Excel macro from another spreadsheet
in the one that was just created?
(I need Access to create DataSpreadsheet, open DataSpreadsheet, then run a
macro from MacroSpreadsheet in DataSpreadsheet)
I'm not sure if you run Excel code in Access, per se, but why don't you just
put your excel code inside of an access module???
Make sure you set a reference to Excel, and then run this cod...access denied
cannot open completed worksheet from folder that is in My
documents. Cannot do anything with it.
If accidently deleted an user's account with mailbox.
After re-create the user account, how to recover the user mailbox?
Em Yeu wrote:
> If accidently deleted an user's account with mailbox.
> After re-create the user account, how to recover the user mailbox?
Answered your other post.
i have a user who tries isremoving a delegate from their
list but when she comes out and goes back into the list
the delegate reappears! any ideas anyone?
...Converting Microsoft Access data to Money
I have a small accounting database which was developed in microsoft access
earlier version. I would like to convert the existing data to Microsoft
money. Is there anyway I can achieve this. All I want is convert the income
data from my access database to Microsoft money 2005.
Any suggestion is highly appreciated.
In microsoft.public.money, DIL <firstname.lastname@example.org.(donotspam)>
>I have a small accounting database which was developed in microsoft access
>earlier version. I would like to convert the existing data to Microsoft
>money. Is ...Maximum number of pcs connected to access
I need to know hoy many simultaneous pc's connected to an access
client/server MDB can it be?
Can access 2003 handle 50+ connections?
How about access 2007?
Thanx a lot!
I've had 53 connections to a well-designed Access 2000 format Jet database.
Most were actively editing the 105+ MB database. It also depends upon record
structure and quality of the network. I know of a database in Texas with 75
concurrent users. Officially Access/Jet can handle 255 users, but I believe
that's pushing it. If you original spec call for 50 + users, you might
con...How do I access a sub in a New Class
From project "VBAProject(Book1.xlsm):"I am trying to access sub
"subInNewClass" in a new class that is in Project "newclass(class
test.xlsm)". Both methods below produce errors.
Any help would be appreciated.
In Project newclass(class test.xlsm)
In Class Module Class1:
Public Sub subInNewClass()
MsgBox "I'm in"
Set reference to Project newclass