Okay let me lay out the situation.
My Squadron has tasked me to create a Database for my squadron it has to be able to do the following.
1. Hold all personal information on every Marine in the database and be userfriendly
2. It also will have to allow access to updates for certain people on every computer in the domain and read only for everyone else at the same time.
3. I can't buy any other programs or run server systems like SQL Server, Nor can I use linux on the domain.

I have the database created in MS Access (It happens to be a program that every marine has access to) and used the partial replication feature to replicate child databases for each shop that will only hold the records for that shop. I have secured the actual files Master and Child databases so that the individual Marines Domain User Account has the appropriate permissions to the database. Either Read Only or Modify.

My porblem comes with the Syncronization function. I can teach the uses that use the database to run the syncronizing function but the command wants me to find a way to make it so that the user themselved do not have to run the syncornizer. thus my problem.

I can't right the macro code that runs the syncronizer from the child database to the master database. Thats something beyond my experiance.

Any chance I get pointed in the right direction.

Thank you
Joel

Hmm...I don't have experencise with Access, but would a Windows Sechudled Task do the job? (like, make a small program that updates the database every day at 1 AM?)

I would have used linked tables instead. You have all the tables in one database that is located on the server. Then the "database" that the clients use contains all your forms, queries, etc. but only linked tables, so it works mainly as just an interface for the tables in the other database. No need for synchronization, and all permissions can be set up in the interface "database."

Although, I don't know if it would allow for multiple simultaneous access, I've never tried that before.

Sorry about the late post. but I'm aat work right now.

The task scheduler won't work as far as I know cause the only database that is stationary is the Master DAtabase. the people who use the child database's can take them home and work on them their. that is the same reason Linked tables won;t work either. this thing needs to be totally portable. Meaning if we send out three detachments they all need to have a database for to use.


Thanks for the input though. I really appreaciate it.

Joel