database replication

[hinser13]

I am trying to create a replica database for remotley collect data "quotations" mainly from our or CRM System.

I only want the replica therefore to have the quotation related tables, forms, reports, and quries. Not all the other tables etc.

When I replicate the CRM there does not appear to be an option to choose which tables etc to replicate, only the whole databse.

What is the best way to only replicate a small portion of a database.

Thanks anyone

Mark

 

[dfenton]

Partial replication is supported, but based on data-based filters that have to respect relational integrity. I don't recommend mucking about with partial replicas. Having all your data in multiple replicas is a great backup when something goes wrong. Instead, I'd filter the data in the front end application and show each user only their own data.

It sounds like you haven't split your database into data tables (replicated) and application (forms/reports/etc.). That's a recipe for disaster and eventual corruption/loss of the VBA project. There is no replicated app that should ever be unsplit.

For more on replication, see the Jet Replication Wiki:

http://dfenton.com/DFA/Replication/