Guests Setting Global For Host 
Author Message
 Guests Setting Global For Host

I have a database that's being served to several users in a
cross-platform environment.  I want any of the users to be able to set a
global field and have it be effective for all users next time they open
the database.  My experience is that only the host of a multi-user file
can set a global field for all users, and that guest globals are not
retained once the user exits the session.

Is there a way -- via plugin, scripting, etc. -- to enable a guest to
force the host to set a global?

Note that for the purposes of this database, it's important to use a
global field, since there are over 20,000 records.  If I used a text
field, it would require a lengthy "replace" step every time a user
wanted to change the contents of the field.

To reply to this email directly, please remove or replace the x's.

Thanks in advance.

Adam Sugerman
(206) 328-8835
asugermanxxxjetcityxxxcom



Fri, 27 Sep 2002 03:00:00 GMT
 Guests Setting Global For Host

Quote:

> I have a database that's being served to several users in a
> cross-platform environment.  I want any of the users to be able to set a
> global field and have it be effective for all users next time they open
> the database.  My experience is that only the host of a multi-user file
> can set a global field for all users, and that guest globals are not
> retained once the user exits the session.

> Is there a way -- via plugin, scripting, etc. -- to enable a guest to
> force the host to set a global?

> Note that for the purposes of this database, it's important to use a
> global field, since there are over 20,000 records.  If I used a text
> field, it would require a lengthy "replace" step every time a user
> wanted to change the contents of the field.

The answer is No, a guest may not ever permanently affect a global on
hosted files. It's designed that way.

What you CAN do is create a one-record, one-field file (ok, two fields
with one being a constant relater), with a regular text or number field,
and have guests set that field and read from that field.  Many
developers use this method for providing custom ID numbers.  Use the
field as if it were a global in your other files. You can make a
constant universal relationship to this file and the field will behave
as if it were a global for purposes of calcs and such.

Lynn Allen
http://www.semiotics.com
FSA Associate



Sat, 28 Sep 2002 03:00:00 GMT
 Guests Setting Global For Host
Instead of a global OR a field in the current database, create a new
database with two fields and one record.  The first field is Match (number)
and enter the number 1 and the second field is your Global field, only not
defined as a global field but either text, number, date or time (depending
upon the type of information being stored).

Now add a global number field to your original database, fill it with a 1
and then remove it from all layouts so it can't easily be changed.  Create
a relationship between that global field and the Match field in the new
database.  Now use the relationship to allow users to change Match.



Quote:
> I have a database that's being served to several users in a
> cross-platform environment.  I want any of the users to be able to set a
> global field and have it be effective for all users next time they open
> the database.  My experience is that only the host of a multi-user file
> can set a global field for all users, and that guest globals are not
> retained once the user exits the session.

> Is there a way -- via plugin, scripting, etc. -- to enable a guest to
> force the host to set a global?

> Note that for the purposes of this database, it's important to use a
> global field, since there are over 20,000 records.  If I used a text
> field, it would require a lengthy "replace" step every time a user
> wanted to change the contents of the field.

> To reply to this email directly, please remove or replace the x's.

> Thanks in advance.

> Adam Sugerman
> (206) 328-8835
> asugermanxxxjetcityxxxcom



Sat, 28 Sep 2002 03:00:00 GMT
 Guests Setting Global For Host

Quote:
(Lynn Allen) writes:
>The answer is No, a guest may not ever permanently affect a global on
>hosted files. It's designed that way.

Does this apply to internet hosting as well?  If so, one of my problems is
solved - resetting globals for the next user in a calculator program. But it
leaves another unresolved, at least as far as instant web publishing is
concerned:  how to reset the globals if a user wants to run a second
calculation rather than reviewing the current one.
Steve Andrews
Andrews Technologies Management


Sat, 28 Sep 2002 03:00:00 GMT
 Guests Setting Global For Host

Quote:

> Is there a way -- via plugin, scripting, etc. -- to enable a guest to
> force the host to set a global?

No.  That's not how globals work.  If you want the different users
to share data, create another database to store those values in.

Simon.
--
http://www.hearsay.demon.co.uk | _Microsoft_ is going to write the software
No junk email please.          | that spies on me? I feel better already.
                               |                         -- John D. Goulden



Sun, 29 Sep 2002 03:00:00 GMT
 
 [ 5 post ] 

 Relevant Pages 

1. hosts/guest determination

2. Guest computer doesn't recognize the host when it's turned on again

3. Host/Guest Question

4. Message to host or another guest.

5. Host/Guest vs Opening a file

6. Guests disconnected from hosts...

7. Host/Guest wierdness

8. Setting Application/Host name in ODBC?

9. Setting the HOST Name on SQL 7

10. HELP: iAS Display /etc/hosts settings?

11. Setting Global Permissions in SQL 2000

12. Passing global parameter settings to DTS


 
Powered by phpBB® Forum Software