Connecting Tech Pros Worldwide Forums | Help | Site Map

Database Replication and Linked Tables

Michael Teare
Guest
 
Posts: n/a
#1: Nov 12 '05
I have a database that I need to create a replicated copy of. The
database app. is 2 mdb files one of which contains the forms, reports,
queries etc the other contains only the tables.

Do I create replicated copies of the form mdb, the table.mdb or both
separately, or is there some trick to replication with linked tables?

Any help would be appreciated
Michael.



Elisabeth Zachary
Guest
 
Posts: n/a
#2: Nov 12 '05

re: Database Replication and Linked Tables


Try both seperatly.
Goodluck,
Lizi
booboo@cs.utah.edu

"Michael Teare" <Michael@Teare.us> wrote in message
news:8tUNb.48767$6y6.1005652@bgtnsc05-news.ops.worldnet.att.net...[color=blue]
> I have a database that I need to create a replicated copy of. The
> database app. is 2 mdb files one of which contains the forms, reports,
> queries etc the other contains only the tables.
>
> Do I create replicated copies of the form mdb, the table.mdb or both
> separately, or is there some trick to replication with linked tables?
>
> Any help would be appreciated
> Michael.
>
>[/color]


Arvin Meyer
Guest
 
Posts: n/a
#3: Nov 12 '05

re: Database Replication and Linked Tables


Replication is for the data tables only. It is not reliable to try and
replicate the front-end.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

"Michael Teare" <Michael@Teare.us> wrote in message
news:8tUNb.48767$6y6.1005652@bgtnsc05-news.ops.worldnet.att.net...[color=blue]
> I have a database that I need to create a replicated copy of. The
> database app. is 2 mdb files one of which contains the forms, reports,
> queries etc the other contains only the tables.
>
> Do I create replicated copies of the form mdb, the table.mdb or both
> separately, or is there some trick to replication with linked tables?
>
> Any help would be appreciated
> Michael.
>
>[/color]


---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.561 / Virus Database: 353 - Release Date: 1/13/2004


Michael Teare
Guest
 
Posts: n/a
#4: Nov 12 '05

re: Database Replication and Linked Tables


When I try to create a replica of the data mdb I get the following message:

Microsoft Access can't convert the database to a Design Master.
Cannot make the [table] object in tables container replicable.

Any ideas?

"Arvin Meyer" <a@m.com> wrote in message
news:uncXJDF3DHA.2136@TK2MSFTNGP12.phx.gbl...[color=blue]
> Replication is for the data tables only. It is not reliable to try and
> replicate the front-end.
> --
> Arvin Meyer, MCP, MVP
> Microsoft Access
> Free Access downloads:
> http://www.datastrat.com
> http://www.mvps.org/access
>
> "Michael Teare" <Michael@Teare.us> wrote in message
> news:8tUNb.48767$6y6.1005652@bgtnsc05-news.ops.worldnet.att.net...[color=green]
> > I have a database that I need to create a replicated copy of. The
> > database app. is 2 mdb files one of which contains the forms, reports,
> > queries etc the other contains only the tables.
> >
> > Do I create replicated copies of the form mdb, the table.mdb or both
> > separately, or is there some trick to replication with linked tables?
> >
> > Any help would be appreciated
> > Michael.
> >
> >[/color]
>
>
> ---
> Outgoing mail is certified Virus Free.
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.561 / Virus Database: 353 - Release Date: 1/13/2004
>
>[/color]


Closed Thread