How to carry unique ID through several forms

[Cathy]

In a multi-user environment, how do I carry a unique part
number from a main form through several forms without
keeping the main form open? (I need to close the main
form, not just minimize it.)

The process I've constructed seems to work with two users,
but the database becomes corrupt once three or more users
are involved. Right now I'm holding the ID using a Public
Function.

Thanks for any help!
Cathy

 

[Gary Miller]

Cathy,

Split your database into a frontend/backend model with the data in the
backend and all the forms,code, reports,queries, etc.. in the front end
which is then copied to each users local machine and linked to the back end.
This is the recommended setup for multi-user environments and in this
situation your Public variables will remain local to the user.

Gary Miller

 

[Rick Brandt]

How do I make updates or changes to the front end that is
on everyone's PC?

You don't. If everyone has their own local copy of the front end that is linked
to a common back end on the network then you simply replace the entire front end
file with a new modified one. This ease of distributing front end changes is
one of the primary benefits of splitting an application.

 

[John Vinson]

How do I make updates or changes to the front end that is
on everyone's PC?

Just make changes in a master copy and write that copy over everyone's
frontend. The frontend doesn't contain any data so this won't erase
anybody's work.

You can do this with a small batch file, called from an icon on the
desktop or at startup; when the user clicks the icon, or every time
they boot up, they get a fresh new frontend.

 

[Douglas J. Steele]

Just make changes in a master copy and write that copy over everyone's
frontend. The frontend doesn't contain any data so this won't erase
anybody's work.

You can do this with a small batch file, called from an icon on the
desktop or at startup; when the user clicks the icon, or every time
they boot up, they get a fresh new frontend.

Or you can use the Auto FE Update Tony Toews has (for free) at
http://www.granite.ab.ca/access/autofe.htm <g>