473,320 Members | 1,870 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Design changes to a replicated database

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
1 1690
ai********@yahoo.com wrote in
news:11**********************@r34g2000hsd.googlegr oups.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

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

1
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...
2
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,...
1
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...
4
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...
0
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...
1
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...
0
weaknessforcats
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...
0
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...
3
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...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
1
isladogs
by: isladogs | last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM). In this month's session, we are pleased to welcome back...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: jfyes | last post by:
As a hardware engineer, after seeing that CEIWEI recently released a new tool for Modbus RTU Over TCP/UDP filtering and monitoring, I actively went to its official website to take a look. It turned...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: af34tf | last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you

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.