By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,829 Members | 1,798 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,829 IT Pros & Developers. It's quick & easy.

Database Replication and Linked Tables

P: n/a
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.
Nov 12 '05 #1
Share this Question
Share on Google+
3 Replies


P: n/a
Try both seperatly.
Goodluck,
Lizi
bo****@cs.utah.edu

"Michael Teare" <Mi*****@Teare.us> wrote in message
news:8t*********************@bgtnsc05-news.ops.worldnet.att.net...
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.

Nov 12 '05 #2

P: n/a
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" <Mi*****@Teare.us> wrote in message
news:8t*********************@bgtnsc05-news.ops.worldnet.att.net...
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.

---
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
Nov 12 '05 #3

P: n/a
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:un**************@TK2MSFTNGP12.phx.gbl...
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" <Mi*****@Teare.us> wrote in message
news:8t*********************@bgtnsc05-news.ops.worldnet.att.net...
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.

---
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

Nov 12 '05 #4

This discussion thread is closed

Replies have been disabled for this discussion.