Re: Access database

A different form will have no benefit here. You reall need to deploy a copy
of the front end to each user.
Managing version updates is not that difficult. There are automatic front
end updaters you can download (can't find a link right now or I would send
it), but it is also simple enought the create a .bat file that copies the mdb
from a specific network folder the the user's computer.

Here is an example of a .bat file for an application that is updated from
the network server every time it is loaded. In this case, it not only
ensures the user has the most current version, but there are several local
tables used in reporting that cause some bloat, so this keeps the file size
down without a compact/repair as well as keeping the version up to date:

Copy "O:\Installation\RealPro Install\Update MDE\*.*" "C:\Program
Files\RealPro\"
"C:\Program Files\Microsoft Office\OFFICE11\MSACCESS.EXE" "C:\Program
Files\RealPro\REALPRO.mde" /runtime
--
Dave Hargis, Microsoft Access MVP


"Gwen" wrote:

The problem is the number of work stations that it would have to be installed
on, and also managing any design changes to the front end.
Would creating my own form to navigate through rather using the switchboard
manager be of benefit?

Gwen

"Douglas J. Steele" wrote:

Each user should have his/her own copy of the front-end, ideally on his/her
hard drive. Splitting the application into a front-end and back-end, but
sharing the front-end, really doesn't buy you anything.

--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)


"Gwen" <Gwen@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:430D036F-80E7-4EB7-A23D-174814993038@xxxxxxxxxxxxxxxx
The database is split, there is one front end accessed via a link on our
intranet as opposed to having a front end loaded on individual work
stations.
The actual drive the front end is located on is not visible/accessable to
the
end users.

Gwen

"NetworkTrade" wrote:

first point of resolution is to be sure that this is a split database and
that each user is operating their own individual front end application.

--
NTC


"Gwen" wrote:

I have a database that opens with a switchboard page. Clicking one of
the
controls takes you to another switchboard page where the controls open
forms
to enter or edit data. It is a multi user environment. I've been
encountering
a problem where some users click the control on the second page to open
a
form and the control appears to be pressed, but nothing happens (one
control
opens the form in add mode and another opens it in edit mode). This
occurs
intermittenly to different users at different times. At the same time
that
some users encounter this problem, other users do not.



.

Relevant Pages

  • Re: Open and close a second instance of a form?
    ... As you found, you can use the New keyword to open another instance of the same form, but managing the independly of each other takes a little more effort. ... I created a field and control named Suppliers.LinkedCompany. ... hop into any supplier's linked company and that's fine, it opens the ... linked company but the original Supplier record as well. ...
    (microsoft.public.access.forms)
  • full control not working
    ... I have a share on my network named Install. ... all is see is Everyone with Full Control. ... whenever I try to open this file from my notebook, the only way it opens is ... The server with the share is a Windows 2003 Standard box with all updates, ...
    (microsoft.public.windows.server.security)
  • Task updates
    ... If I have a project manager that is a resource on a project that they are not managing how do you control where the updates are performed...web or professional if the person has both? ...
    (microsoft.public.project.pro_and_server)
  • are you asleep, I mean, remembering next to cold vans
    ... who's managing into the pence's earth. ... Try clinging the bias's protective tumour and ... You control too, unless Saad restricts specimens ... special respect wounds airlines in Daoud's pregnant frog. ...
    (sci.crypt)
  • Re: Want to enable fields after combox selection
    ... and it opens up teh code and highlights HideFormText ... Dim ctl As Control 'Each control on the form ... Dim bSkip As Boolean ...
    (microsoft.public.access.forms)
Loading