Save portion of DB as new free standing db

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I manage a large property database. I need to filter out one department's
list, save it as a database that can be sent to that department and they in
turn can open it at their location. I do not want to send the entire
database, just their part of it. Can Access do this? Filemaker does this
great but I can't find a way to get Access to produce the unique database
file. I can copy and paste copies of the database but this is cumbersome.
There must be a better way. They must be able to open the file at a remote
location with no connection to the original tables.
 
You can do this. It will take a little manual work.
I think the easiest approach would be to make a copy of your existing
database. Then for the copy you want to send to the other department, use
some queries to delete all records except those for that department. If you
have any referential integrity imposed, you will have to address that as well
when it comes to doing the deletes.
 
Back
Top