Question Locked

What to do

0 helpful
31 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
I have a user who telecommutes. There is an Excel file that many people access and modify. Being that she is a couple of states away, she can't access the file. The file resides on a certain computer which has file share enabled with all of the other XP machines. How could the same file be accessed by both her and everyone else?

31 replies

by Former member

To have the file in question as "shared" on her computer?

Please post back if you have anymore problems or questions.

by wesley.chin

Have not done that. She is three states away and can not access the network at headquarters...

by cg it

Bit of a mystery that needs to be resolved before one can make a useful suggestion.

for that matter you say the connection is a T1 provided by an internet service provider. However, you don't have a router. So that raises the question of is the T1 only for 1 computer? The ISP can provide you with global local addresses for each host but that's gotta cost mega bucks. If you only have 1 global local address, then only 1 host can gain access to the T1 line unless you have a router of some sorts that does many to one NAT.

by jiminpa

Have access to a SharePoint server? Or what about setting her up with VPN access?

by wesley.chin

No server here.

Internet is pumped through a T1 hosted by ISP. So no router

by jiminpa

No public IP at all? Hate to say this but it sounds like your out of luck. Only other thing I can think of off the top of my head is maybe setup on of the office PC's up with a logmein account or something she can access when she needs to access network resources. In a situation like yours your gonna have to think outside the box.

by jdclyde

And using that router, you can set up either VPN or PPTP from the remote user.

That will get the user to the LAN, and from there, they will have access to that file. Of course it will be slow, opening it over the internet, and may take a few minutes to open and close the file.

Are you the net admin for the company?

What are you using for a firewall?

Do you have static IP addresses from your IP provider? If not, it costs me very little for a 5 pack of IP's.

by cg it

stick a modem in the comp and have dialup remote access.

by wesley.chin

you know, I had suggested that, but it waws rejected. Privacy issues were the reason, since employees did not like the idea of someone remotely controlling a computer. Putting it on a dormant computer is not an option cause management thinks having a PC expressly for that is waste.

The ISP says that the IP is DHCP.

by jiminpa

Since your ISP connection is always on, in theroy your IP address would never change, at least not very frequently. Could you possibly setup a VPN connection with that IP and then if the ISP refreshes your IP you would just have to rebuild it? I know... PITA depending on how often it happens but it could be worth a try.
That is assuming you have a path to your internal network from the internet.

by dumphrey

as part of the T1 deal, and hence under their control, and running very minimal config. A nat box is priority, and a firewall as well...

by wesley.chin

Right now, she sends files she creates via email and vice versa.

by wesley.chin

The position of Net Admin. does not exist here.

For firewall, the one in XP.

ISP says the IP is dynamic.

by cg it

your "senario" of no remote access available, yet the problem is that a telecommuter needs companie files, plus you don't have any method for anyone to have remote access seems like you can't do what you want to do and have it cost effective.

the only way in which a telecommuter who need an up-to-date copy of files, and does not have remote access, is to have someone fax or email the files as they change.

by wesley.chin

Right now, what you describe is happening. But the telecommuter complains that she does not have enough time to make changes to the Excel file. I think what is desired is realtime, as in everyone modifies the same file.

by wesley.chin

Ideally, something like what you mentioned would work. I had mentioned it before, but it had been rejected.

There is a hesitancy to introduce new procedures or ways of doing tasks here. It has something to do with a belief by management that the accustomization and training needed will hinder productivity.

Also, there are telecommuters here, and at least one has expressed privacy issues.

FTP has been considered, though implementation has not happened. But with the degreee of security offered by FTP vs. Web server, I am not sure if it is a suitable solution. Security is paramount here.

by dumphrey

cost of implementing a vpn scenario, and training remote users to use the vpn? As compare to a google docs like scenario...
present them with a report on the cost of an entry cisco asa server, setting up a Windows AD radius server, and installing and traiing a user to use vpn.

then present google docs...

by nonapeptide

while gManagement==Happy

[i]Also, there are telecommuters here, and at least one has expressed privacy issues.[/i]

SFTP connected to CryptoHeavon. Done. :)

[i]But with the degreee of security offered by FTP vs. Web server, I am not sure if it is a suitable solution. Security is paramount here.[/i]

SFTP connected to CryptoHeaven... not done?

P.S. I'm assuming that CrpytoHeaven does SFTP. It would be silly if they didn't.

by sue t

storage that comes with the price you are already paying. why not put the file there and then since it is on the internet they can all access and it won't be accessible to other people becuase they won't have the username and password.

by wesley.chin

What you mentioned is all well and good, except ideally the location of the file would be not be static.

Management wants it such that both the file viewed locally and remotely is located in the same place.

For example, if there is example.xls in folder A, and local person makes modifications and telecommuter makes modifications, the file in folder A reflects the modifications made by both the telecommuter and local person.

by nonapeptide

[i]For example, if there is example.xls in folder A, and local person makes modifications and telecommuter makes modifications, the file in folder A reflects the modifications made by both the telecommuter and local person.[/i]

I don't think that's possible with something like an Excel doc. Unless you code some crazy bit level grep doo-hickey.

~~~:-|

by dumphrey

set up and document management server such as MS Sharepoint. open source dms exist, but can not recall names atm.

by sue t

the closest you will be able to come to having them all having the same doc locally and remotely is for all of them to link to this document so that when they open it they will get the updated data. As for 2 people working in the same doc at the same time I am fairly positive Excel won't let you do that but will ask you if you want to open a read only copy.

by wesley.chin

I am looking for something that does to call for a server.

by dumphrey

our firewall handles the vpn connections. We use the radius part of RRS in server2003 to authenticate against AD, and then VPN users become a part of the domain, including permissions to access file shares. But even without active directory, you should be able to use standard work group permissions for the VPN access. Its really the only viable solution. How else is a remote user going to access the network?

Sounds like your supervisor wants the old FM networking solution...

by wesley.chin

So a server is not needed. How could it be done wihout one? Active Directory is not present here, neither is a server. From my understanding (the setup was here when I got here) all of the computers are connected via ethernet cables to a hub. Through this hub, a T1 line, file sharing, and printer sharing is done. Is there some guide that is available?

by dumphrey

no mistake. Each computer is a stand alone system, responsible for all its own log ins and permissions.
Do you have a firewall between your T1 and the hub? And are you sure its a hub and not a switch? If you have no firewall, thats priority 1. And this will let you buy one with VPN capability. But, I would expect you have something in the way of a router/firewall between the T1 card and you, either a CSU unit in a router or a dedicated HW CSU. Each piece of networking gear implements VPN a little differently.

This discussion is closed to new replies.