Re: 127 Column Limit

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

David,

Thanks for the quick response!

No, I didn't have SHOW HIDDEN OBJECTS on. I don't really want to see them
but when I do, now I'll know how.

As far as the schema and normalization... You are certainly correct. There
is always a better way to do things. However the take-away, for anyone else
reading this post, should be don't expect an Access application to work with
replication just because it worked without replication. If you do, the best
advice you may get is to start over and rethink it from the ground up.

To make a test-only design master, I navigated to Tools>Replication>Recover
Design Master. I clicked Yes, Yes, and OK. Now, I appear to have two
unlinked design masters, which is what I wanted.

Thanks again!
b


"David W. Fenton" <XXXusenet@xxxxxxxxxxxxxxxxxxx> wrote in message
news:Xns9941DB6C8E19Af99a49ed1d0c49c5bbb2@xxxxxxxxxxxx
"Bill" <b@xxxxx> wrote in
news:#u9ZjT9oHHA.3264@xxxxxxxxxxxxxxxxxxxx:

I inherited a small Access database that uses replication to
support a mobile application. While I'm not new to MS-Access, I am
new to its replication functionality.



.

Relevant Pages

  • Re: Replication Best Practices
    ... Q1) You can keep the Design Master on your laptop. ... corruption between the Design Master and the server backend, ... You stated that replication does not copy forms, queries, ...
    (microsoft.public.access.replication)
  • Re: 1st Time Replicator Needs Advice on How to Proceed
    ... Remote users ... connection. ... The DESIGN MASTER should be compacted at ... replication is good for JET objects and not ...
    (microsoft.public.access.replication)
  • Re: 1st Time Replicator Needs Advice on How to Proceed
    ... It means either by filesystem or vy internt connection. ... > compact/repair on the design master on a weekly basis (which is how often ... The DESIGN MASTER should be compacted at least once before ... replication is good for JET objects and not ACCESS PROJECT ...
    (microsoft.public.access.replication)
  • Re: Replication***Please Help***
    ... with different security levels access the database at the same time. ... database at one time without using replication, ... In the design master all of the links are working fine, ...
    (microsoft.public.access.replication)
  • Some questions about Replication
    ... I am running a research on replication and now have some questions. ... there's only 1 design master and multiple replicas. ... What if there are 2 design masters and they sync each other? ...
    (microsoft.public.access.replication)