Connecting to a db on a laptop from a db on a server

[CJBIRKIN]

Hi

Is it possible to connect to a computer on a network that is not a server i.e.

I wish to "push" data onto a laptop from a database on a server. I know this is not the usual way round but it is for security reasons.


Cheers Chris

 

[Parker]

Hi

Is it possible to connect to a computer on a network that is not a server i.e.

I wish to "push" data onto a laptop from a database on a server. I know this is not the usual way round but it is for security reasons.


Cheers Chris

If the correct permissions are set then, once conected to the network, your laptop just becomes another PC so Yes

 

[CJBIRKIN]

Hi Parker,

any idea how to do this?

Chris

 

[Parker]

Hi Parker,

any idea how to do this?

Chris

sorry CJ I missed your post.

What network? Is it windows, Novell, Unix, a mixture, or what?

Who assigns your IP addy's ? is it DHCP or static?

What is the network security?

There are so many questions really you need to talk to your sys admin. I am asming, from your post, that this is not you because if it where you would no the answer unless it is a home style peer - to - peer.

If this is the case then I'll try and talk you through adding another computer but I will need to know your setup/what windows version etc.

I'm out for the next couple of hours but will be back later this evening if you need more help

 

[CJBIRKIN]

sorry CJ I missed your post.

What network? Is it windows, Novell, Unix, a mixture, or what?

Who assigns your IP addy's ? is it DHCP or static?

What is the network security?

There are so many questions really you need to talk to your sys admin. I am asming, from your post, that this is not you because if it where you would no the answer unless it is a home style peer - to - peer.

If this is the case then I'll try and talk you through adding another computer but I will need to know your setup/what windows version etc.

I'm out for the next couple of hours but will be back later this evening if you need more help

Yikes! I knew things were complex with networking but this...

Anyway, i've decided to do it by the tradtional route now! i.e. Laptop connects to network and pulls information from server. The problem is that the laptop DB (mobile db) won't know where on the network the server db is. The databases will be used in a number of hospitals so i can't know before hand where they are going to be stored. I've just set up a find db and save path dialog so each time a clean mobile db is set up it just asks the user where the server db is and saves the path. I just thought it would be safer and easier for one person who runs the admin db on the server to push the path of the central database onto the new mobile db on the laptop.

Thanks for your time

Chris

 

[Parker]

Yikes! I knew things were complex with networking but this...

Anyway, i've decided to do it by the tradtional route now! i.e. Laptop connects to network and pulls information from server. The problem is that the laptop DB (mobile db) won't know where on the network the server db is. The databases will be used in a number of hospitals so i can't know before hand where they are going to be stored. I've just set up a find db and save path dialog so each time a clean mobile db is set up it just asks the user where the server db is and saves the path. I just thought it would be safer and easier for one person who runs the admin db on the server to push the path of the central database onto the new mobile db on the laptop.

Thanks for your time

Chris

Networking is not that complex you just need the right information. A decent admin will take seconds to allow a conection.

If you are connecting to a network such as this you will prob. need security clearance anyway. They are unlikely to let anyone connect at random to their servers. So you may still need to talk to sys admin.And you will definately need to allow the right protocols on your lappie.

Unfortunately, sys admins are a necessary evil. Those that are good are great and easy to deal with. Others are often unavailable. ------Permanently. I have a theory that the later often don't know what they are doing and so hide behind a cup of coffee and the 'I'm too busy' syndrome.

Your idea is sound. Think about storing the paths in a table and use an identifier in a pick list. That waqy each time you re visit you shouldn't have to do a new search. You will prob. also need to store all the different WG files as well.

Read help on setting up multiple workgroup files.

Cheers

 

[CJBIRKIN]

Networking is not that complex you just need the right information. A decent admin will take seconds to allow a conection.

If you are connecting to a network such as this you will prob. need security clearance anyway. They are unlikely to let anyone connect at random to their servers. So you may still need to talk to sys admin.And you will definately need to allow the right protocols on your lappie.

Unfortunately, sys admins are a necessary evil. Those that are good are great and easy to deal with. Others are often unavailable. ------Permanently. I have a theory that the later often don't know what they are doing and so hide behind a cup of coffee and the 'I'm too busy' syndrome.

Your idea is sound. Think about storing the paths in a table and use an identifier in a pick list. That waqy each time you re visit you shouldn't have to do a new search. You will prob. also need to store all the different WG files as well.

Read help on setting up multiple workgroup files.

Cheers

Hi Parker,

The name of the game here is Mobile Db. I've designed my system so that a user (Nurse) can collect data whilst visiting a patient, later they will sync the database with one on a server. There could be many mobile db's. The idea is that they will synchronise the db's in the evening and then download any changes + addtionally data into there db in the morning so that they all have the same information. I have written all the sync stuff myself as the access version was v.unfriendly especially for non-IT type persons. Each IT dept in the hospitals will image their own laptops so network connection is not a problem. I've set it up so that there are a number of DB's running of a central "Hub" the admin db deals with adding new users/passwords/ encryption etc the mobile db has all the data entry tables and there is soon to be a reporting db which will run of the Hub as well. This was by far the easiest way of doing things especially if there are going to be upgrades.
I have also set it up so that the first time the admin db runs or a copy of the mobile part of the db it will ask the user to find the HUB and then download all of current data where applicable. The path to the HUB is stored in a table so that it can be re-used however it always checks to make sure that there is a connection everytime the user tries to sync their db. Addtionally it will register each of the laptops with the hub so when the users want to download all the data it will know if they have all been syncronised first.

I've been working on this for 5 months now and it is nearly finished but it seems to take an age to tidy up the loose ends. Each time i look at it i see something that i would like to improve/change i just have to draw the line somewhere!

Thanks again for your help

Chris