Remote location Access

[skin76]

Hello,
My question is, how do I make my DB accessable to users in a different location (two different states) in real-time?

I want both location to be able to add and edit data and that it is current for others to view.

We were using the DB (split) on a server in one location, but now a part of the co. has moved and we all need to be able to run in the same fashion with is DB if possible.

Please advise in the steps we need to take.

Thanks in advance

 

[HitechUser]

Split your application to create a FE(frontend) and BE(backend) database. Keep you applications code, screens, reports, etc. in the FE. Store all tables in the BE.

From the FE create linked tables (name them the same as the table) and the application will not need to be changed.

Place the BE on a network share accessibe to all users. Place the FE on each machine (better performance).

Some ideas. Microsoft and MultiUser


Then go to it...

 

[skin76]

Thanks for your reply, but all of the things you mentioned above for me to do have been done. My question is how do I let multi-users some located in the state of Florida and some in California to have access to the DB off of my server in real time.

Do I need a FTP, VPN, etc?

Thanks

 

[HitechUser]

FTP will NOT work. FTP is for file transfers only. If you want realtime access to the file, you will have to create a connection.

If your company has some sort of VPN configuation, then all you will have to do is utilize this configuration then just Map a network drive to the remote server.

If not, for reasons of security you will need to setup a VPN connection or some sort of secure tunnel. Have a look at SSH (secure shell) and PUTTY. There are open sourcde (freeware) and commercial versions available. Any of these will allow you to open a connection over the internet that is secure.

There are many VPN packages and solutions "out there", without knowing more about your infrastructure these are just a starting point.

 

[skin76]

Great Thanks!!!