Is it recommended to share a database with FS and CS users simultaneously?  If so then
what pathname strategy should be used for the database and where should the config file be
located?  Sorry if this has been answered but i couldn't find it.  

Rob,

<< Is it recommended to share a database with FS and CS users
simultaneously? >>

Only if the the Local users are accessing via the same machine, such as the
case with a web application or terminal services.  If the Local users are
accessing via a different machine, then you're effectively defeating most of
the benefits of using C/S access in the first place.

Perhaps you could give me an idea of your requirements.  There may be a
different way to structure things.

--
Tim Young
Elevate Software
www.elevatesoft.com

Tim,

Maybe a better question is there a way to prevent FS and CS users from accessing the same
database?  In my application I give the user a setup screen with the option of single user
or multi user.  If they choose single user then I create a database using a path such as
(EXEPath)+'\Data\'.  If they choose CS then I ask them for the IP address, loginid,
password, connect to server, create the database if needed.  What is to prevent a rouge
user from running my program and choosing single user mode even though other users are
currently using CS mode?  Is there any way to lock them out while CS users are active?

Rob

"Tim Young [Elevate Software]" wrote:

Rob,

<< Is it recommended to share a database with FS and CS users
simultaneously? >>

Only if the the Local users are accessing via the same machine, such as the
case with a web application or terminal services.  If the Local users are
accessing via a different machine, then you're effectively defeating most of
the benefits of using C/S access in the first place.

Perhaps you could give me an idea of your requirements.  There may be a
different way to structure things.

--
Tim Young
Elevate Software
www.elevatesoft.com

Rob Fletcher wrote:
<< What is to prevent a rouge
> user from running my program and choosing single user mode even though other users are
> currently using CS mode?  >>

How about if they want to run as a single user, have them enter the ip
as 127.0.0.1 or host as "localhost".  Then they would still be using
C/S, wouldn't they?  Its just that both the client and server are
running on the same machine.

Dale

Rob,

<< Maybe a better question is there a way to prevent FS and CS users from
accessing the same database? >>

The only surefire way is to prevent FS users from accessing the data
directly, i.e. sequester the data on the server machine and don't make the
applicable directories be shareable resources.

<< In my application I give the user a setup screen with the option of
single user or multi user.  If they choose single user then I create a
database using a path such as (EXEPath)+'\Data\'.  If they choose CS then I
ask them for the IP address, loginid, password, connect to server, create
the database if needed.  What is to prevent a rouge user from running my
program and choosing single user mode even though other users are currently
using CS mode?  Is there any way to lock them out while CS users are active?
>>

There really isn't any foolproof way to prevent them from doing so other
than the above.  However, if they already have control over what is shared,
etc., then they can still get around any access restrictions by simply
changing them.

--
Tim Young
Elevate Software
www.elevatesoft.com

If simultaneous FS and CS access to a database is not recommended then why doesn't the
server open the files exclusively?  

Rob

"Tim Young [Elevate Software]" wrote:

Rob,

<< Maybe a better question is there a way to prevent FS and CS users from
accessing the same database? >>

The only surefire way is to prevent FS users from accessing the data
directly, i.e. sequester the data on the server machine and don't make the
applicable directories be shareable resources.

<< In my application I give the user a setup screen with the option of
single user or multi user.  If they choose single user then I create a
database using a path such as (EXEPath)+'\Data\'.  If they choose CS then I
ask them for the IP address, loginid, password, connect to server, create
the database if needed.  What is to prevent a rouge user from running my
program and choosing single user mode even though other users are currently
using CS mode?  Is there any way to lock them out while CS users are active?
>>

There really isn't any foolproof way to prevent them from doing so other
than the above.  However, if they already have control over what is shared,
etc., then they can still get around any access restrictions by simply
changing them.

--
Tim Young
Elevate Software
www.elevatesoft.com

Rob,

<< If simultaneous FS and CS access to a database is not recommended then
why doesn't the server open the files exclusively? >>

Web apps, and other local applications that run directly on the server
machine.

--
Tim Young
Elevate Software
www.elevatesoft.com