Making changes while others are in Database.

[Guest]

This might just be a big "NO", but is there any way to make changes to forms,
reports, etc. without having to make the other five users get out of our
database? It's such a pain (especially cause we are on different floors!)

 

[Alex Dybenko]

Hi,
just split your database:
http://alexdyb.blogspot.com/2005/07/how-to-split-database-into-be-and-fe.html

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Guest]

I do have my database split between one for tables and one for everything
else (forms,reports, etc.) but I still need to get everyone out of the
database if I want to change a form. What am I doing wrong?

 

[Guest]

First, you can't. But, if you have your environment configured correctly, it
is no hassle.
Correct configuration. (Use database splitter)

All data and relationship object in the "Back End" mdb. This file should be
on a shared folder where all users have rights.

All other objects in "Front End" mdb. A copy of this file should be on each
user's own computer. You will want to use UNC path names to link the Front
End to the tables in the Back End because each user may have different drive
mappings.

You as the developer should have a separate Development copy of each mdb.
Once you have completed your bugging*, you need to deploy only the front end
to the users. There are a number of ways to do that. The simplest is to put
a copy in a location the users have access to, and notify them to copy the
new version into place.

* bugging (buh' gi'ng) The act of creating computer applications. Anonym,
Debugging.

 

[Alex Dybenko]

Hi,
once you split - you have to install database with forms/reports (frontend)
on every user PC, so every user run his own copy. then nothing prevents from
making design changes in your copy of frontend. and after this - you can
give new version to your users

--
Best regards,
___________
Alex Dybenko (MVP)
http://alexdyb.blogspot.com
http://www.PointLtd.com

 

[Kevin K. Sullivan]

Also check out:

http://www.granite.ab.ca/access/autofe.htm

Tony Toews has developed an incredibly helpful and shockingly free
system that lets even the most novice users automatically download the
latest front-end version of your database each time they use a desktop
shortcut. No emailing files, no calling folks to ask them to log out.
This has been a real timesaver.

HTH,

Kevin