Design changes to a replicated database

aine_canby

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 database, then make a copy
of the database to which I will add my changes to. Then finally,
delete the old database (after backing up), and rename the copy to
that of the old database.

Of course, everyone will then have to open the new version before
chosing Click Tools -Replication -Create Replica...

Any other tips?

Thanks,

Aine.

Aug 6 '07 #1

Subscribe Reply

1716

David W. Fenton

ai********@yaho o.com wrote in
news:11******** **************@ r34g2000hsd.goo glegroups.com:

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 database, then make a
copy of the database to which I will add my changes to. Then
finally, delete the old database (after backing up), and rename
the copy to that of the old database.

Of course, everyone will then have to open the new version before
chosing Click Tools -Replication -Create Replica...

There are a number of bad problems lurking in the situation you
describe:

1. there is no Access application that should not be split into
front end and back end.

2. replication works repliably only for back end data tables, so
your front end should not be replicated, only the back end.

3. when you make a change to the front end, you just give your users
a new copy of it, leaving the replicated data tables alone.

To split your current application, the easiest thing to do is create
a new MDB and import everything into it except the tables. Then in
the new MDB, create links to the back end replica.

In the DESIGN MASTER, delete everything but the tables. To convert
over to the new version, send everyone the new front end, and tell
them to synch with the updated repica you use as a hub for synching.

If everyone has the same location for their app, there should be no
need to relink tables. But if they store the app in different
locations on their PCs, then they will either have to use the Linked
Table Manager each time you send out a new front end, or you will
have to provide code that does the relinking for them. There's
plenty of code around that will relink to a back end in the same
folder as the front end.

Last of all, you should consider why the app is replicated. If the
users are all connected to the same LAN at all times, there is no
role for replication at all.

If, on the other hand, they are using laptops and need to edit data
in the field, that's a perfectly good justification for replication.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/

Aug 6 '07 #2

Similar topics

1885

Replication - Changes to Server database's impact to local database

by: Michael diPilla | last post by:

We have a SQLSERVER database that is replicated to many users. We are currently in an expansion phase where we need to make changes to the server database. Each time we rollout a new release, we are deleting the local replicating database and recreating. Is there any way to automatically transfer the changes from the server to existing local database without deleting?

Microsoft SQL Server

2578

Merge Replication + Structure Changes

by: Martin McNally | last post by:

My company maintains 40 replicated Sybase databases using a merge replication approach. It's difficult to update all 40 databases when a structure change occurs. Structure changes are minor, usually adding fields. We are considering moving to SQL Server 2000 in the hope that these updates will be easier to do. Does SQL Server 2000 support structure updates accross replicated databases? Martin

Microsoft SQL Server

1868

How to query for records that have not been replicated

by: miltonmoura | last post by:

Hi, I am using Merge Replication for synchronizing a bunch of laptops running MSDE with a central SQL Server 2000 production server. This database is used by an application that needs to know which records have not yet been replicated, at any givem time. Here's a simple scenario:

Microsoft SQL Server

3492

about replicated summary table on two base tables

by: jane | last post by:

HI, I try to create summary table like following: create table summary (a int, b int, c int) (select a.aa, b.bb, b.cc from table_a a ,table_b b where a.key=b.key) data initially deferred refresh immediate enable query optimization in tablespace_test replicated;

DB2 Database

1435

Best design for replicated database

by: Bill Ehrreich | last post by:

I have an A2000 application that I have designed to use a replicated Access database. The application permits information to be gathered on cardiac patients in a hospital system. Most users will be viewing or entering data at their workstations attached to the network. However, there will be one mobile user who will walk around a hospital with a tablet PC entering data. It was this user's needs that drove me to use a replication...

Microsoft Access / VBA

2256

Synchronizing with a non-replicated database is not allowed. The <name> database is not a Design Master or replica

by: MAILTONRK | last post by:

Hi, I am a Mainframe guy. I am working with MS access(maintaining a application) for the last 2 weeks. I had one master database and four replicas. One of my replica had trouble in synchronization(It said, database is in use..). After searching google, I ran "Compact and repair" utlity against my replica. It looks like, it has changed the attribute of my replica.

Microsoft Access / VBA

11630

Design Patterns: Visitor

by: weaknessforcats | last post by:

Design Patterns: Visitor Introduction Polymorphism requires a class hierarchy where the interface to the hierarchy is in the base class. Virtual functions allow derived classes to override base class functions. Applications using polymorphism typically have functions with base class pointers or references as arguments. Then derived objects are created and used as arguments to these functions. Inside the function, only the base class methods...

C / C++

1060

Can changes done by the trigger be replicated back?

by: marek2 | last post by:

DB2 8.1.14 on win XP but later will be moved to AIX. The peer to peer replica bewtween server1 and server2 is setup (just one table now) - and it works when the changes are done to the table using just update. On the server1 the the status column is set to 1 (update sql) and then the change is replicated to server2 where there is a trigger: CREATE TRIGGER DB2ADMIN.MAINT AFTER UPDATE OF STATUS ON DBO.TBLLOCK REFERENCING OLD AS o NEW AS n ...

DB2 Database

2614

Frequency of compressing/repair replicated databases

by: Bob Alston | last post by:

I have a system built using Access replication. After some initial problems dealing with memo fields, it now seems to be working well. I am curious as to how frequently others Compress & Repair replicated databases? Bob

Microsoft Access / VBA

9666

What is ONU?

by: marktang | last post by:

ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...

General

9511

Changing the language in Windows 10

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 effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...

Windows Server

10139

The easy way to turn off automatic updates for Windows 10/11

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 most users, this new feature is actually very convenient. If you want to control the update process,...

Windows Server

9983

Discussion: How does Zigbee compare with other wireless protocols in smart home applications?

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 protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...

General

9020

AI Job Threat for Devs

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 launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...

Career Advice

5417

Trying to create a lan-to-lan vpn between two differents networks

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 the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...

Networking - Hardware / Configuration

5551

Windows Forms - .Net 8.0

by: adsilva | last post by:

A Windows Forms form does not have the event Unload, like VB6. What one acts like?

Visual Basic .NET

3700

How to add payments to a PHP MySQL app.

by: muto222 | last post by:

How can i add a mobile payment intergratation into php mysql website.

PHP

2909

Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy

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 effective websites that not only look great but also perform exceptionally well. In this comprehensive...

General