Filtering form with Specific Data

D

D Collins

Hello,

I have a database that I am replicating to several other
locations. I would like each location only to be able to
access their data. I would also like the computer to
identify which location is adding the record.

What would be the best approach to doing this? How would
the database know to filter for a certain location?

Thx.
 
A

Allen Browne

Hmm. Looks like you did not get replies on your original post.

D, I don't think I would use replication for this scenario.
Split the database into the usual front end/back end.
Each location has just the data for their own location.

The central office that needs the summary data can then accept a copy of the
branch databases periodically, and run a series of Append query statements
so they have the data from each one.

Since your question suggests the data at each location is independent, this
seems like a simpler approach.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
Adding Network Trusted Location on MS O365 Word per Computer Registry Setting 1
Help creating a search form in Access XP 0
Copy previous record into form field 0
Filtering a Form with Specific Data 0
How do I clear a form? 0
Filter Options in Form 2
Assigning specific record data to fields on a form Access 2003 0

Top