|
Home > Archive > dBASE Questions and Answers > October 2006 > Help - How to get dBase 5.7 to work off a server!
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Help - How to get dBase 5.7 to work off a server!
|
|
| Michael 2006-10-25, 7:34 am |
| I am wanting to get my program to be stored on a server, or atleast just the data files with all my inventory, etc, so that I can have this program run on three systems, and they are all working off of one database, so that each will be up to date, with w
hat has been received, or sold, etc.
Seeing as how I am not sure how to do this, although if explained, and done well, I will be able to do it (meaning I'm not as dumb as I sound, I just need direction), I was hoping someone could walk me through this, direct me to an explanation of doing th
is, or atleast just send me in the right direction for what applications, or avenue I should be looking at, to get this done. Just ask if you want more information. Thanks, Mike
| |
| David Kerber 2006-10-25, 7:34 am |
| In article <QJ3mc0t8GHA.1684@news-server>, mikef@rgmazergroup.ca says...
> I am wanting to get my program to be stored on a server, or atleast just the data files with all my inventory, etc, so that I can have this program run on three systems, and they are all working off of one database, so that each will be up to date, with
what has been received, or sold, etc.
> Seeing as how I am not sure how to do this, although if explained, and done well, I will be able to do it (meaning I'm not as dumb as I sound, I just need direction), I was hoping someone could walk me through this, direct me to an explanation of doing
this, or atleast just send me in the right direction for what applications, or avenue I should be looking at, to get this done. Just ask if you want more information. Thanks, Mike
The devil is in the details for something like this, but basically you
put the data files on the server in a shared folder, and set up the app
to point to the correct network spot. The program files can live on the
server or on the clients. The BDE must be installed on each client
machine. You have to make sure your program handles locking and sharing
correctly for this to work (it can't have exclusive access to the
..dbf's, for example).
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
| |
| Michael 2006-10-25, 7:34 am |
| David Kerber Wrote:
The devil is in the details for something like this, but basically you
put the data files on the server in a shared folder, and set up the app
to point to the correct network spot. The program files can live on the
server or on the clients. The BDE must be installed on each client
machine. You have to make sure your program handles locking and sharing
correctly for this to work (it can't have exclusive access to the
..dbf's, for example).
I just want to make sure I understand this, that this is a "simple" matter of installing the program on the systems that I want it to run on, and then telling it that the database files are over the network, located on the server. However, I will also ne
ed to make sure the permissions on the database files are set so that they will not be allowing only 1 user to be accessing, or modifying at one time. They will need to be set so that multiple users can access and modify the same file at the same time.
Is this an easy thing to do? To set the permissions, to allow for multiple user access to the same file?
Thanks David, you reinforced something I thought I could do, but just wasn't 100% sure of. I appreciate the quick response. Thanks, Mike
| |
| David Kerber 2006-10-25, 7:34 am |
| In article <UdDBxs48GHA.880@news-server>, mikef@rgmazergroup.ca says...
> David Kerber Wrote:
>
> The devil is in the details for something like this, but basically you
> put the data files on the server in a shared folder, and set up the app
> to point to the correct network spot. The program files can live on the
> server or on the clients. The BDE must be installed on each client
> machine. You have to make sure your program handles locking and sharing
> correctly for this to work (it can't have exclusive access to the
> .dbf's, for example).
>
>
> I just want to make sure I understand this, that this is a "simple" matter of installing the program on the systems that I want it to run on, and then telling it that the database files are over the network, located on the server.
Yes.
> However, I will also need to make sure the permissions on the database files are set so that they will not be allowing only 1 user to be accessing, or modifying at one time. They will need to be set so that multiple users can access and modify the same
file at the same time.
> Is this an easy thing to do? To set the permissions, to allow for multiple user access to the same file?
Yes. In fact, that's the default on file servers; you need to do extra
configuration to prevent it. As long as your dBase app doesn't "USE ...
EXCLUSIVE", and doesn't try to reindex or pack tables while others are
using them, it's pretty easy.
> Thanks David, you reinforced something I thought I could do, but just wasn't 100% sure of. I appreciate the quick response. Thanks, Mike
>
--
Remove the ns_ from if replying by e-mail (but keep posts in the
newsgroups if possible).
|
|
|
|
|