2 Masters

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andro Dgebuadze - 30 Jan 2004 10:58 GMT

Hi

I want people from different location to add their record in 1 database.
The connection is through Internet (no LAN).
I found that an mdb file can not have 2 master files.
What should I do then?
Can you append your recods on the remote database with Replication or ASP is
a must?

Andro

Reply to this Message

Michael \(michka\) Kaplan [MS] - 30 Jan 2004 11:06 GMT

Replication allows data to be entered in multiple locations. A design master
is only needed for SCHEMA changes. So your scenario should work.

Signature

MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

> Hi
>
[quoted text clipped - 6 lines]
>
> Andro

Reply to this Message

Andro Dgebuadze - 30 Jan 2004 11:48 GMT

Thanks Michka

But in this case when the remote user is entering data and replicates with
the database which is located on the server, the remote user gets empty
tables (meaning that data flows from server to remote replica).

My understanding is that replication direction is from Master to replica
(cause when I replicate database, Access asks file location of master
design, and I can only indicate 1 file).

So can you give me a hint how can I create several databases which are
appending data into 1 mdb file?

Thansk again

"Michael (michka) Kaplan [MS]" <michkap@online.microsoft.com> wrote in
message news:e308vEy5DHA.2392@TK2MSFTNGP11.phx.gbl...

> Replication allows data to be entered in multiple locations. A design master
> is only needed for SCHEMA changes. So your scenario should work.
[quoted text clipped - 18 lines]
> >
> > Andro

Reply to this Message

Michael \(michka\) Kaplan [MS] - 30 Jan 2004 12:30 GMT

"Andro Dgebuadze" <andro@gboc.ge> wrote...

> But in this case when the remote user is entering data and replicates with
> the database which is located on the server, the remote user gets empty
> tables (meaning that data flows from server to remote replica).

In a normal Jet replica set, data flows BOTH ways after synchronization. Are
you deleting data in one and not expecting it to be deleted in the other?

> My understanding is that replication direction is from Master to replica
> (cause when I replicate database, Access asks file location of master
> design, and I can only indicate 1 file).

Your understanding us incorrect. You can create as many replicas as you
like, and any replica can sync with any other.

> So can you give me a hint how can I create several databases which are
> appending data into 1 mdb file?

Again, think in terms of all data flowing in BOTH directions. You can create
as many replicas as you want.

Signature

MichKa [MS]
NLS Collation/Locale/Keyboard Development
Globalization Infrastructure and Font Technologies

This posting is provided "AS IS" with
no warranties, and confers no rights.

Reply to this Message