How to carry unique ID through several forms

  • Thread starter Thread starter Cathy
  • Start date Start date
C

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
 
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
 
Cathy said:
How do I make updates or changes to the front end that is
on everyone's PC?
Click to expand...

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.
 
How do I make updates or changes to the front end that is
on everyone's PC?
Click to expand...

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.
 
John Vinson said:
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.
Click to expand...

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