Network connection for query

G'day there One and All,

	I'm currently trying to adapt a few of the Dept's workbooks to suit our
district. There is a single master book, to produce reports, that
is available to all on a read only basis and read write to the
relevent manager. There are also a number of data entry books that are
identical to each other and that provide the data from each division.
The master book uses a query to obtain data from the division's books
and thereby build the reports. The data books are read write for
everyone with only a single sheet from each providing data for the
query.

	I've adapted the sheets to their new district, (quite simple) and
have amended a few bits & pieces to ensure dates are kept relevent
and stuff like that. I've also adapted the queries to their new
home, however I've never used queries before and now I've found that
although I am able to run the queries, the bloke who needs to do it
can't. The original author is no longer available for me to ask about
it all so I'm trying to do it by trial & error.

	I'm fairly sure that I've got the query correct as I've been able to
run it successfully. It's all about to be moved again, but that's an
easy fix. However I don't know how to ensure the manager can access
the queries from wherever he is. Does he need to set up the file server
as a mapped network drive separately on each of the pooters he uses? 

	Is there a way to set up the queries so that the manager or his relief
can use them without me or them having to map the drives wherever they
may be? I'm sure there is, but I've yet to find how. The only results
that Google has provided me (that I could understand) were helpful in
understanding how to build a query, but not how to permit everyone
else to use it once I've set it up - acls will be applied by our IT
person once the new home folder is arranged... and no; our IT person
has little knowledge of XL and can't help.

	I'm fairly sure there's a way to allow everybody to just open the
master book with the queries running automatically on open, and then get
the updated figures, but I'm not sure how to do it.

	If anyone can tell me, or point me at a web site that can do so then
I'll be extremely grateful.

Thanks for listening,
Ken
Qld, Australia
0
ken
2/12/2010 7:43:55 AM
excel.misc 78881 articles. 5 followers. Follow

0 Replies
459 Views

Similar Articles

[PageSpeed] 58

Reply:

Similar Artilces:

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
hello 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, tblCalendarHistory.Division FROM tblCalendarHistory WHERE (((tblCalendarHistory.Date) Between "StartDate" And "EndDate") AND ((tblCalendarHistory.Division)=[Forms]![frmDivision]![txtDivision])); 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 following error: "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 using is: -Unavailable -Protected with file permissions -On a share on a server and the network is down -Corrupt To correct this problem, store the OST or PST file on the local computer. 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 (12.0.0.6421) on my server. I have no problem connecting to SharePoint using anything else. Does anyone have any ideas? I have tried the basic authentication option, too but this has has no effect. Thanks in advance! Toby 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). -- Mark Matzke Hi Mark, 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
Hi All, 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 disk yo...

networking
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! Ted. 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 HTH Pete >-----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 Steve SELECT SupplierID FROM Item WHERE ItemLookupCode='RDB8020301' - Evan Culver New West Technologies "Steve" <Steve@discussions.microsoft.com> wrote in message news:E2ADBC85-AE2B-4C53-AF33-76720451F31C@microsoft.com... >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 appreciated. Thanks! 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 specifications. 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 network drive. Is there anyway around this w/out having the original installation CD? steve ...

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. "THPCT" wrote: > 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 fixes. 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. Thanks Joel ...

The connection was dropped by the remote host #3
Hi 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 seen this? Cheers Jason Omer 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 works fine. Is there something I need to do to format the query so it merges with the right format. Thanks Billa 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. Thanks, Scott ...

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 computer. Thanks "species8350" <not_here.5.species8350@xoxy.net> wrote in message news:d27bcce4-972e-4ee2-b9db-ddba5be8bedb@j14g2000yqm.googlegroups.com... > 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 butt. 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...