Re: Replication Best Practices

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Douglas J. Steele (NOSPAM_djsteele_at_NOSPAM_canada.com)
Date: 12/15/04 

Date: Tue, 14 Dec 2004 19:19:17 -0500

While it will copy forms, queries, etc., it's not intended for that purpose.
As Cheval stated, you should only be replicating the data. Your application
should be split into a front-end, with only the back-end being replicated. 

-- 
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"AWM" <awmohrjr@yahoo.com> wrote in message
news:1103059291.466045.230340@c13g2000cwb.googlegroups.com...
> 3.  fyi... You stated that replication does not copy forms, queries,
> etc but it certainly does copy forms.  I have checked the replicated db
> after replication and confirm that the form designs have changed but
> the code has not.  Perhaps an issue with Access 2003.
> Thanks again for your help.
>
> Art
>

Relevant Pages

  • Re: Replicate Extended Schema Attributes
    ... The suse web uses LDAP queries to retrieve these UNIX ... If the SUSE box queries our primary domain controller, ... it seems to be a replication problem. ...
    (microsoft.public.win2000.active_directory)
  • Re: How do I replicate forms, reports, code, etc. in an upsized databa
    ... Replication is not intended to be used for queries, forms, reports, macros ... The appropriate approach to updating a front-end is to copy the file, ...
    (microsoft.public.access.setupconfig)
  • Re: Locking problem with Access 2002 and SQL 2000
    ... and Queries hold Shared Locks on the SQL tables while they browse data. ... subsequently prevents the replication task from inserting records into the ... the default isolation level to read uncommitted? ...
    (microsoft.public.sqlserver.odbc)
  • RE: convert replica
    ... You didn't say if I need to import the tables nor queries. ... Just one table has 27 data fields. ... > also copy the replication information and you will still have the problems ... but the only way to convert a replicated database to a simple ...
    (microsoft.public.access.replication)
  • Re: Replication
    ... Replication is *perfect* for queries, ... Jet objects. ... back-end. ...
    (microsoft.public.access.queries)