473,508 Members | 2,263 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Database Replication and Linked Tables

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
3 3037
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
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
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 thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
2170
by: smahler | last post by:
Hi all, Here is my situation. I have an application that uses SQL 2000. The client has a program that uses MSDE. The client MUST have the MSDE version of the Database. What I have done is to...
2
2672
by: Robert McGregor | last post by:
Hi all, I've got a Front End / Back End database that was working just fine. One day i opened the FE to find that if I tried to open one of the linked tables from the database window, nothing...
3
3567
by: MeganF via AccessMonster.com | last post by:
Hi. I've been working on a database for a while now between my desktop and my laptop. Each time I copy the files, I go into the Linked Table Manager and update my path to my linked databases....
7
2361
by: nydiroth | last post by:
Our servers went down for over 6 hours yesterday and I was asked if there was a way to store the database on the server and a local station at the same time. My datbase is split and the tables...
8
1946
by: Rick | last post by:
I'm running an Access2000 front end mde linked to an Access2000 back end mdb. I need to set up replication and synchronization of only the data tables between the master db on the pc and replicas...
7
2404
by: PC Datasheet | last post by:
Looking for suggestions ---- A database was designed for a national automobile inspection program. In it's simplest form, the database has two tables: TblOwner OwnerID <Year/Make/Model owned...
1
1934
by: rolandsun | last post by:
we are designing a data collecting system, at each site we have a database and have a central database,we will write data to site's database, we want the site-database can publish the data to...
1
1703
by: aine_canby | last post by:
Hi, My company has an old access database which has been in use for many years now by a few employees. I need to make some design changes to one of the forms, but I'm not sure how I should go...
1
1210
by: Terri | last post by:
I have a client with several different types of users. Most use desktops and work off of the standard tables in a common backend from specific frontends. The sales manager uses a laptop and needs a...
0
7132
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
7401
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...
1
7063
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows...
0
7504
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
0
5640
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing,...
1
5059
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new...
0
4720
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and...
1
773
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
0
432
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.