View Single Post
  #5  
Old March 25th, 2010, 06:40 AM posted to microsoft.public.access.tablesdbdesign
Rick Brandt
external usenet poster
 
Posts: 4,354
Default Database Runtime Question

MFulton via AccessMonster.com wrote:

So basically once the runtime is installed, runtime users will have access
to
any changes made to the actual database as they are made. For example,
lets say I added a new button to a form, would they instantly see the new
button
or would the runtime user have to close and reopen the runtime. Thanks
for your responses


If you have all users opening the same shared file (bad practice) then you
cannot make any changes to the design while people are using it, at least
not since Access 97. If you made changes while everyone was out of the app
then they would see them when they next open the file.

In a version of Access old enough to allow design changes while people are
using the app (VERY BAD PRACTICE), the user might see the changes without
closing and re-opening the file, but I'm not sure if the behavior was
consistent.

As Daniel points out in his response you should always split your app when
you have multiple users and give each user a separate (usually local) copy
of the front end and only the file containing the tables is shared. Then
you would distribute new front end files after changes are made. To do
otherwise runs the risk of file corruption.