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. 3 3044
Try both seperatly.
Goodluck,
Lizi bo****@cs.utah. edu
"Michael Teare" <Mi*****@Teare. us> wrote in message
news:8t******** *************@b gtnsc05-news.ops.worldn et.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.
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******** *************@b gtnsc05-news.ops.worldn et.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
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******** ******@TK2MSFTN GP12.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******** *************@b gtnsc05-news.ops.worldn et.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
This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics |
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 create a SQL 2000 Database that is exactly like
the MSDE version. What I wish to do, is at regularly scheduled
intervals, update the SQL 2000 Data...
|
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 happened (hourglass
for about 2 seconds then nothing).
I tried relinking the tables and got the same response. (Access even
completely bombed out...
|
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.
For some reason today, it won't open my first database at all citing that
the database path for one of the linked databases isn't valid.
What would...
|
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 are linked. Would there be a way to
modify the table links to direct them to two seperate backends? Could
there also be a non-linked table stored in...
|
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 on numerous
laptops.
I know that it can be done using the Access replication manager
(although without a simple UI in the front end mde), but the...
| |
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 by owner, Owner name/address, etc)
TblInspection
InspectionID
|
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 central-database Asynchronously, how could we do that?
single replication sounds work,but it will replicate all update
,including delete ,we dont...
|
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 about doing this. I
have designed databases with access before, but not when replication
was used.
So, should I first get everyone out of the...
|
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 bunch
of tables only he and his assistant use. Most of the data on the
network he only needs to read, not change. He uses the laptop both in
the...
|
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 tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that...
|
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 Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For...
| |
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, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then...
|
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 presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules.
He will explain when you may want to use classes...
|
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 then checking html paragraph one by one.
At the time of converting from word file to html my equations which are in the word document file was convert...
|
by: TSSRALBI |
last post by:
Hello
I'm a network technician in training and I need your help.
I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs.
The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols.
I succeeded, with both firewalls in...
|
by: 6302768590 |
last post by:
Hai team
i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
|
by: muto222 |
last post by:
How can i add a mobile payment intergratation into php mysql website.
| |
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 can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating...
| |