Troubles with sharing over business network
I am trying to set up computers that are running on a small business network.
We need to share folders that are on the desktop but when we set them up to
be shared they are not recognized by the other computers. There are a few
computers that are working but our newer computers are not.
Nathan Niewohner wrote:
> I am trying to set up computers that are running on a small business network.
> We need to share folders that are on the desktop but when we set them up to
> be shared they are not recognized by the other computers. There are a few
> computers that are worki...too complex query
I'm using Access 2003 SP3 and here is my query based on single table
PARAMETERS StartDate DateTime, EndDate DateTime;
SELECT tblCalendarHistory.CalendarID, tblCalendarHistory.Date,
WHERE (((tblCalendarHistory.Date) Between "StartDate" And "EndDate") AND
At first I created a form for imputting start and End dates, but I was
getting "Too complex" message. So I created parameters - same message. If I
replace parameters ...Outlook and Being Networked
I have a two PC running Outlook 2003. Both our networked together through
our wireless network, both running XP Home Edition. I'm wanting to keep
both .pst files current on each PC so that no matter what PC you currently
use, you can access your files and such.
I've looked and have read most of the links and articles on
http://www.slipstick.com/outlook/sync.htm and have read many KB articles on
Microsoft. Most of these programs cost and I've tried some over their trial
period and didn't quite like how they operated or it just wasn't what I
needed. So, how can one...Outlook 2003: Cannot connect to Exchange Server 2000
We have installed Outlook 2003, and have configured it to
connect to Exchange Server 2000. But each time we try to
open any Exchange mailboxes in Outlook, we get the
"The set of folders could not be opened."
The details button shows the follows:
"This error usually appears if the OST or PST file you are
-Protected with file permissions
-On a share on a server and the network is down
To correct this problem, store the OST or PST file on the
You may also want to run the scanost.exe and scanpst.exe
tools t...Microsoft Document Connection gives error "Only connections to SharePoint or SkyDrive servers are supported."
Trying to connect to my SharePoint server using Microsoft Document
Connection with Mac Office 2011. Getting this frustrating error:
"Only connections to SharePoint or SkyDrive servers are supported."
I have the full version of Mac Office 2011 (not student/teacher
edition) and am running MOSS 2007 Service Pack 2 (22.214.171.12421) on my
server. I have no problem connecting to SharePoint using anything
Does anyone have any ideas?
I have tried the basic authentication option, too but this has has no
Thanks in advance!
On Jan 25, 8:22=A0pm, Toby <tobybore...@gmail...Create Email From Access W/Information From Form or Query in
I have designed Databases for many years now, but never attempted this:
I need to know how to create an email with information located in the active
form or off of a query. I would like to have the email automatically
generated with the To Address, The Subject Line and the Body of the Text. I
would like that email to open but not to send until the operator has a chance
to make modifications. (one record per email).
You could try the following to start:
Place a button on a form and place the following behind the on click event
Dim objApp as New Outlook.Applic...Current Date in Query
Hoping you can help.
I'm using the following to get current age in a query:
NewCurrAge: (DateDiff("m",[DOB],Date())+(Day([DOB])>Day(Date())))\12 & " yrs
" & (DateDiff("m",[DOB],Date())+(Day([DOB])>Day(Date()))) Mod 12 & " mos"
My BIG problem is that I also want to pull certain ages, especially 9 to 13
for one query and 14 to 17 in another query.
So, in the same query for criteria I used:
Between 9 yrs 0 mos And 13 yrs 12 mos
Error: the expression contains invalid syntax. you entered an operator
witho...SBS Connectivity issues
Experiencing intermittent delays and dropped connections to Small Business
Server. Config is: SBS2003 SP2 (all current patches) running on HP ML110
server; 4 PCs onsite - 3 used by onsite staff; 1 used by remote user to
access server via RWW.
Users run basic Office apps, Outlook, Quickbooks, internet access. Also
have an Avaya VIOP phone system (4 phones) on the network. Everything has
been in place for almost 4 years.
Having more frequent connectivity issues. Onsite PCs show delays in Outlook
connecting to Exchange ('Trying to connect ...). Remote user reports...File opening problem over network
I have what seems to be a strange excel file opening issue that I can't
pinpoint and I would greatly appreciate any ideas to try for this problem.
We have a network computer running windows 98 SE. On this computer there
are many .xls files stored for users to access. Often when opening the
files users get an error that reads: Microsoft Excel cannot open or save any
more documents because there is not enough available memory or disk
pace. -To make more memory available, close workbooks or programs you no
longer need. -To free disk space, delete files you no longer need from the
My question is, we want to setup a calander for
everybodies use at our office. Do we need a server or can
we run off of our office network? Bottom line question
is, can 6 to 8 people use Outlook at the same time without
a dedicated server? If so how?
Thanks for the help!
simply setup a calendar on a single users outlook
installation, then give all other users permission to
view and edit that calendar.
you may also have to look at some kind of sharing for the
drive the outlook is on.
It's just like giving your secretary access to your inbox
>-----Original ...SupplierID Query Help
I found this query in an old post.
SELECT SupplierID FROM Item WHERE ItemLookupCode'RDB8020301'
When I run it, I receive this error message:
An error occurred while executing query:
Line 1: Incorrect syntax near 'RDB8020301'.
Can anyone throw me a bone and let me know how to correct. Thanks
SELECT SupplierID FROM Item WHERE ItemLookupCode='RDB8020301'
New West Technologies
"Steve" <Steve@discussions.microsoft.com> wrote in message
>I found this query in an old p...moniter network usage on the network
I want to moniter the bandwidth/internet usage of all of the devices on our
network. Some are wired and some are wireless through a wifi connection. How
would I get started doing something like this?
> I want to moniter the bandwidth/internet usage of all of the devices on
> our network. Some are wired and some are wireless through a wifi
> connection. How would I get started doing something like this?
Might be outside the C# topic, but IF your traffic (even internal) is
passing through a firewall, or it's passing through a switch that supports
mirroring, you...How can invoices be generated from multiple queries in Access?
I am an office manager for my local synogogue. I have created an Access
database to track our membership and their pledges and payments. I would
like to be able to generate quartetly statements that indicates a previous
balance, each pledge and payment (i.e., transaction) for the quarter and the
current balance. In the past I have used Mail Merge for things like this,
but this time I am having trouble embedding in a document information from
multiple tables/queries. Any assistance with this task would be greatly
There are some free church management ...Help to create a querie / Great Challange
Hello. I need to create a querie that analise a a specific value and compare
to some standards. Well, I was able to create this querie if the were no such
Imagine that I have a value, i.e.: 1.50
My standards columns are:
UMin; Min; Nom; Max; UMax.
If the value if less then UMIn or bigger then Umax the value should be
represented like this *1.50*.
If the value is bigger then UMin and less then Min or Less the UMax and
bigger the Max should be represented like this *1.50.
If the value is between Max and Min should be represented like this 1.50.
Now it comes the problem....Network resource error
I'm attempting to use a laptop on a new network. I've
configured it on the new domain and now I'm trying to get
Outlook to connect to my email account on the Exchange
server. When I open up Outlook it attempts to access or
install a "resource" called data1.msi that's on the old
Is there anyway around this w/out having the original
...How do i add the values of a column in a query in Access
This is driving me mad can someone help please:
How do i add the values of a column in a query in Access
You do a totals query and use the Sum function.
Jerry Whittle, Microsoft Access MVP
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.
> This is driving me mad can someone help please:
> How do i add the values of a column in a query in Access
Let's say you have two fields, Price and Tax both defined as currency.
Place those in columns 1 and 2 of the query design panel. In the 3rd column
put in an Express...Network Connection
How do I remove or delete a network connection. I bought
my laptop to the office and connected to our network, now
I can't get on the internet using my phone line.
...Outlook 2007 to Hotmail
Hello from my wit's end! My Outlook 2007 (Win XP) has merrily connected via
Outlook Connector for over a year (though perhaps weekly I have to go through
the repair process). Still it WORKED, and that solution was an easy fix.
Around mid-April, NOTHING has worked. Here are my symptoms and attempted
MS Office diagnostic tells me I have no LAN connection
I get the messages 0x800CCC0F and E (mostly) "cannot connect to server"
at other times shows OFFLINE
at all times I'm able to connect to the Internet through my wireless router
I've the same proble...Web Query from multiple tables
I'm using a web query to import data from multiple consecutive tables.
However when it imports the data, it leaves a blank row in between the data
from each table. Anyone know of any way to get rid of this- meaning to just
have it list one table after another with no breaks.
...The connection was dropped by the remote host #3
I'm having a problem with my SBS 2003, iot receives emails
fine, but sending is not working. I was getting an error
about 'could not bind to Destination in DNS' now i
get 'The connection was dropped by the remote host'. I get
the error when i highlight messages in the Q's, but
nothing in Event log.
If you need any info please ask, otherwise has anybody
I have a forward and reverse look up zone, nslookup works
as far as it can resovle the domain names in the Q's.
1 domain controller which is also the exchange server,
hen...Query to Mail Merge issue
I am running Access2003 on WinXP SP2.
I send out dues letters for members of a retiree group. When I try to do a
mail merge to my Dues Query all goes fine except the telephone number in the
query which is (555)555-1234 comes out 5555551234. If I copy the query into
an excel spreadsheet and use that as the datasource for the mail merge it
Is there something I need to do to format the query so it merges with the
In the query format the field to include the parentheses and dash. In query
design view, instead of the field name put an expression alo...Network password on Office 2003
I'm having an odd issue.
At random times Outlook pops up a box asking me to enter network password.
I have, by default saved my password. However, when the "enter network
password" dialog box appears, the password is there in astrisk form. But the
save password box isn't checked. I check the "save password" box and click
OK. It then accesses my email. And later, from 15 minutes to over an hour it
does the same process all over again.
Anyone have any input on this issue? It gets Kind of frustrating.
...Outlook 2003 connecting to mail server problem
I have three mail boxes set up at my Mail Hosting company (I have my own
domain). Each mail box connects to the same mail server for my domain.
Each mail account is set up separately as POP in Outlook 2003 and they
are set to connect at different time intervals.
During the day, I get frequent error messages from Outlook saying either
it can't connect to the server or it timed out waiting for a response
from the server. This does NOT happen to all accounts every time, but
seems to be at random. It's NOT the same account each time that gets
this message, and it could be one, two o...Understanding Networking
We have recently installed another computer in the house. I can detect
it in 'Network'.
If I click on the this new computer icon and login, what features and
facilities will be available to me when working on the original
"species8350" <email@example.com> wrote in message
> We have recently installed another computer in the house. I can detect
> it in 'Network'.
> If I click on the this new computer icon and login, what features...Outlook 2003 and Wireless Network Conectivity
Often, my wireless connection is "taken-over" ( while Outlook is open ) by
another nearby wireless network signal with little or very low signal
strength, screwing up my send/recieves. Is there a way to keep this from
happening. It's not a big deal in that once I notice the problem I can
easily go and reconnect to my own signal again. It's just a pain in the
Fly Man <Fly Man@discussions.microsoft.com> wrote:
> Often, my wireless connection is "taken-over" ( while Outlook is open
> ) by another nearby wireless network signal with little o...