Same copies of file on 3 different pc's change simultaneously

[Glory]

I set up a project and have to make weekly changes to it. I also set up
copies of the file for 2 of my bosses on the community drive so they can
access the report. But I noticed when I make the changes on my computer,
their files also change! How do I keep their files from being altered while
I'm working on the file on my computer until I'm ready to do the final
change, and then go in and change their files? Thank you, Glory

 

[Wayne-I-M]

Hi

You need to split your application so that the data is stored in one area
(back end) and the forms, etc in another area (front end)

This way you will be able to work on the application locally and only when
you are happy with it will you need to copy it to your boss's front end
computer. You boss will continue to work with the thier front end until you
alter it

Search this forum for "split database" - there are many post here concerning
this

Good luck

 

[Peter Hibbs]

As Wayne says, you need to split the database into Front-End and
Back-End files. When you have that working properly on your
development system and your bosses PCs you will need to relink the
front-end to the common back-end whenever you send them an update.
Have a look at this site for code to do that automatically :-

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE_ReLink.mdb'

Also, you will probably need to make occasional changes to the
back-end file like adding new fields and/or tables, have a look at
this site for code to do that automatically.

http://www.rogersaccesslibrary.com/Otherdownload.asp?SampleName='BE Update Utility.mdb'

HTH

Peter Hibbs.