Re: Access database

IT involvement should not be required.
But, this is a clue to an additional issue.
All users need to have read, write, and delete permissions on the network
folder where the backend mdb is placed. Without these rights, an ldb file
cannot be created and this will certainly result in locking issues in a multi
user environment.

If the proper rights are assigned, then all you need to do is put the master
copy of the front end in the folder with the back end where it can be copied.

If IT refuses to grant the rights described above, you will never have a
successful multi user implementation.
--
Dave Hargis, Microsoft Access MVP


"Gwen" wrote:

Thank you for your advice. I will need to speak to our IT department about
trying your suggestion. Hopefully they will be able to accommodate with
deploying a front end to each user and allowing the automatic front end
update. Thanks again.

Gwen

"Klatuu" wrote:

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: Access database
    ... 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 ... a problem where some users click the control on the second page to open ... opens the form in add mode and another opens it in edit mode). ...
    (microsoft.public.access.forms)
  • Re: MonthCalendar in form
    ... testing it on the network with another user that will be ... >> opens it out on the network it gives a compile error ... >> The library I have selected is the Microsoft DAO 3.6 ... >> some control on ...
    (microsoft.public.access.formscoding)
  • Re: Opening / viewing jpeg files
    ... of a jpeg file on our network, on clicking the control, it opens the jpeg ... the program that opens them normally and the one I would prefer. ... network are pretty much all about 2500x1800 pixels each. ...
    (microsoft.public.access.formscoding)
  • Re: MCE 2005 Xbox 360 Extender PC Setup Cannot find Xbox 360 on Ne
    ... the only Network Service I have enabled is the "Internet Gateway ... Gateway Device Discovery and Control Client), the Internet Gateway Device ...
    (microsoft.public.windows.mediacenter)
  • 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)