Sharing Database on Network

[mvpejp]

Wasn't sure which forum was best to put this in. I have five reps that will all be using the same database. Is it possible for each rep to have a copy of the database on the network for themselves and then have a master database that pulls all records from each of the five individual database together. If so how would I do this.

Database Splitter? Not sure any and all help is appreciated thanks.

MVPEJP

 

[Nero]

What is the pupose for each rep needing their own database?
If each rep only want access to their records then just filter the form based on the rep Id.

 

[mvpejp]

The current database I'm running has about 10 forms, 10 reports, 20 queries for each rep. Thus 50 forms, 50 reports, 100 queries all together.

So I made the assumption that there might be a way to make five unique databases having the limited forms, queries etc. for each rep and then have a main database that all this info flows into.

Not sure how I can decrease the number of forms/queries etc.

Tx for your reply

MVPEJP

 

[Nero]

You could split the database keeping the back end on the server and then customising 5 front ends for the reps which would sit on their pc.
The only problem with front ends on the reps pc is when you want to make any changes or updates. If you would need to make regular updates then it would probably be best leaving the front ends on the server in a separate folder.