|
 |
access thread: Database in Two Different countries / Replication
Message #1 by "Zaragoza, Enzo" <enzaux@y...> on Mon, 28 Jan 2002 23:53:00 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_01E6_01C1A856.EABC3020
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Hi guys!!!!
I have used database replication as a solution to my subject. But
problem arises as I go through here are some of them:
1.) To update both database in Country1 and Country2, both of them
should send a replica of their database to update the databases. The
problem is with my Autonumber field which is also my TranNo and my
primary key of the table. When Country1 made an addition to the table
and also Country2 made an addition too. When sychronized, the field
goes berserk. For ex.
Last TranNo is 0008, then country1 made an addition so country1
has TranNo 0009. On the other side, Country2 made an addition so he
will have TranNo 0009 too. When this two tables are synchronized. the
TranNo of this two records that were added would become 10267829 and the
other one 102983325. So my TranNo is messed up.
2.) If I make my TranNo not an autonumber but still the primary key of
the table still problem arise. I changed the TranNo to text so that we
can have a TranNo like PO-0001. Now the problem is, when Country1 made
a PO-0002 and Country made also PO-0002 and sychronized an error occurs
(Type Mismatch). Any solutions?
3.) Is it possible to make a replicate databases that will contain ONLY
those Records that were updated. I tried using partial replica but
still not good because I have to put a condition.
3.) As time goes by the database will grow insize definitely. What if
it's about 10 mb or greater, how would I transport the replica? For
smaller size I can attach it on emails but with large size it would be
impractical to attach it in email. Any ideas?
4.)I was trying to find Report Manager but I couldn't find it. Any
ideas where I can download it or find it?
Any suggestions or help would be greatly appreciated!!! Thanks!!!
Pleeeeeeez help :(
Thanks,
Enzo :)
----- Original Message -----
From: robin5151
To: ms_access@y...
Sent: Wednesday, January 16, 2002 7:49 PM
Subject: [ms_access] Re: Database in Two Different countries
Hello Enzo,
By far the easiest way to handle this is by using replication. Then
the replication manager (a piece of software not a person) will take
care of all the data and ID number issues for you (or most of them).
Replication is available in 97 and is documented so you can look it
up in the help files.
If you need any help give me a yell.
Regards
Robin.
--- In ms_access@y..., "Enzo Zaragoza" <enzaux@y...> wrote:
> Hello!!!
>
> I would like to ask you some idea or suggestions on how would I
setup the database program that I will do.
>
> What is the best way of setting up the database if there are
two similar dbase program in Country1 and Country2. what they want
is that all the updates made in Country1 will also reflect in
Country2. And also the same the other way around, if Country2 makes
an update Country1 should also be updated. Any ideas?? Thanks!!!
>
> Enzo :)
>
>
> [Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
http://groups.yahoo.com/group/visual-basic-beginners/
http://groups.yahoo.com/group/ms_excel
http://groups.yahoo.com/group/screenprinting
http://groups.yahoo.com/group/powerpoint
http://groups.yahoo.com/group/pkunzip
http://groups.yahoo.com/group/photoshop-beginners
http://groups.yahoo.com/group/ms_access
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Message #2 by "Zaragoza, Enzo" <enzaux@y...> on Tue, 29 Jan 2002 11:42:37 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0050_01C1A8BA.0CDD7CF0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Help me guys pleeeeeeeeeeezzzzzzeeeeeeeeee
Enzo
----- Original Message -----
From: Zaragoza, Enzo
To: Access
Sent: Monday, January 28, 2002 11:53 PM
Subject: [access] Database in Two Different countries / Replication
Hi guys!!!!
I have used database replication as a solution to my subject. But
problem arises as I go through here are some of them:
1.) To update both database in Country1 and Country2, both of them
should send a replica of their database to update the databases. The
problem is with my Autonumber field which is also my TranNo and my
primary key of the table. When Country1 made an addition to the table
and also Country2 made an addition too. When sychronized, the field
goes berserk. For ex.
Last TranNo is 0008, then country1 made an addition so country1
has TranNo 0009. On the other side, Country2 made an addition so he
will have TranNo 0009 too. When this two tables are synchronized. the
TranNo of this two records that were added would become 10267829 and the
other one 102983325. So my TranNo is messed up.
2.) If I make my TranNo not an autonumber but still the primary key of
the table still problem arise. I changed the TranNo to text so that we
can have a TranNo like PO-0001. Now the problem is, when Country1 made
a PO-0002 and Country made also PO-0002 and sychronized an error occurs
(Type Mismatch). Any solutions?
3.) Is it possible to make a replicate databases that will contain
ONLY those Records that were updated. I tried using partial replica but
still not good because I have to put a condition.
3.) As time goes by the database will grow insize definitely. What if
it's about 10 mb or greater, how would I transport the replica? For
smaller size I can attach it on emails but with large size it would be
impractical to attach it in email. Any ideas?
4.)I was trying to find Report Manager but I couldn't find it. Any
ideas where I can download it or find it?
Any suggestions or help would be greatly appreciated!!! Thanks!!!
Pleeeeeeez help :(
Thanks,
Enzo :)
----- Original Message -----
From: robin5151
To: ms_access@y...
Sent: Wednesday, January 16, 2002 7:49 PM
Subject: [ms_access] Re: Database in Two Different countries
Hello Enzo,
By far the easiest way to handle this is by using replication. Then
the replication manager (a piece of software not a person) will take
care of all the data and ID number issues for you (or most of them).
Replication is available in 97 and is documented so you can look it
up in the help files.
If you need any help give me a yell.
Regards
Robin.
--- In ms_access@y..., "Enzo Zaragoza" <enzaux@y...> wrote:
> Hello!!!
>
> I would like to ask you some idea or suggestions on how would
I
setup the database program that I will do.
>
> What is the best way of setting up the database if there are
two similar dbase program in Country1 and Country2. what they want
is that all the updates made in Country1 will also reflect in
Country2. And also the same the other way around, if Country2 makes
an update Country1 should also be updated. Any ideas?? Thanks!!!
>
> Enzo :)
>
>
> [Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
http://groups.yahoo.com/group/visual-basic-beginners/
http://groups.yahoo.com/group/ms_excel
http://groups.yahoo.com/group/screenprinting
http://groups.yahoo.com/group/powerpoint
http://groups.yahoo.com/group/pkunzip
http://groups.yahoo.com/group/photoshop-beginners
http://groups.yahoo.com/group/ms_access
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
$subst('Email.Unsub').
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Message #3 by "David Chapman" <luckychap@b...> on Tue, 29 Jan 2002 19:28:57 +1030
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0006_01C1A8FB.31FE6DA0
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
I solved a similar problem by discontinuing autonumber in favour of a
devised numbering system prefixed by the first letter of the city. "Devised"
means use a one row table where in the only data item is a number which is
incremented by the function that returns a string containing the next
number. When introduced nobody noticed any difference in speed, and they
liked their "individuality".
The unique strings are the keys which allow me to combine the records in the
master database without worrying about duplicated numbers. There are several
other advantages of knowing the next number (or string link) before updating
a table, the best is that it is available for use in further code, ie
updateing a secodary table.
David
-----Original Message-----
From: Zaragoza, Enzo [mailto:enzaux@y...]
Sent: Tuesday, January 29, 2002 2:23 AM
To: Access
Subject: [access] Database in Two Different countries / Replication
Hi guys!!!!
I have used database replication as a solution to my subject. But
problem arises as I go through here are some of them:
1.) To update both database in Country1 and Country2, both of them should
send a replica of their database to update the databases. The problem is
with my Autonumber field which is also my TranNo and my primary key of the
table. When Country1 made an addition to the table and also Country2 made
an addition too. When sychronized, the field goes berserk. For ex.
Last TranNo is 0008, then country1 made an addition so country1 has
TranNo 0009. On the other side, Country2 made an addition so he will have
TranNo 0009 too. When this two tables are synchronized. the TranNo of this
two records that were added would become 10267829 and the other one
102983325. So my TranNo is messed up.
2.) If I make my TranNo not an autonumber but still the primary key of the
table still problem arise. I changed the TranNo to text so that we can have
a TranNo like PO-0001. Now the problem is, when Country1 made a PO-0002 and
Country made also PO-0002 and sychronized an error occurs (Type Mismatch).
Any solutions?
3.) Is it possible to make a replicate databases that will contain ONLY
those Records that were updated. I tried using partial replica but still
not good because I have to put a condition.
3.) As time goes by the database will grow insize definitely. What if it's
about 10 mb or greater, how would I transport the replica? For smaller size
I can attach it on emails but with large size it would be impractical to
attach it in email. Any ideas?
4.)I was trying to find Report Manager but I couldn't find it. Any ideas
where I can download it or find it?
Any suggestions or help would be greatly appreciated!!! Thanks!!!
Pleeeeeeez help :(
Thanks,
Enzo :)
----- Original Message -----
From: robin5151
To: ms_access@y...
Sent: Wednesday, January 16, 2002 7:49 PM
Subject: [ms_access] Re: Database in Two Different countries
Hello Enzo,
By far the easiest way to handle this is by using replication. Then
the replication manager (a piece of software not a person) will take
care of all the data and ID number issues for you (or most of them).
Replication is available in 97 and is documented so you can look it
up in the help files.
If you need any help give me a yell.
Regards
Robin.
--- In ms_access@y..., "Enzo Zaragoza" <enzaux@y...> wrote:
> Hello!!!
>
> I would like to ask you some idea or suggestions on how would I
setup the database program that I will do.
>
> What is the best way of setting up the database if there are
two similar dbase program in Country1 and Country2. what they want
is that all the updates made in Country1 will also reflect in
Country2. And also the same the other way around, if Country2 makes
an update Country1 should also be updated. Any ideas?? Thanks!!!
>
> Enzo :)
>
>
> [Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
http://groups.yahoo.com/group/visual-basic-beginners/
http://groups.yahoo.com/group/ms_excel
http://groups.yahoo.com/group/screenprinting
http://groups.yahoo.com/group/powerpoint
http://groups.yahoo.com/group/pkunzip
http://groups.yahoo.com/group/photoshop-beginners
http://groups.yahoo.com/group/ms_access
Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service.
Message #4 by "Yehuda Rosenblum" <Yehuda@I...> on Tue, 29 Jan 2002 09:12:21 -0500
|
|
This is a multi-part message in MIME format.
------_=_NextPart_001_01C1A8CE.F7B1616B
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
I think the issue of the Trans numbers is because they are using the
same number. My guess is its a primary key which means when they update
the main database you end upo with duplicates in a primary key table.
The easiest solution is to generate the number programatically with the
country name as part of the number.
I know very little about database replication so I can't really tell you
much on that topic. My way of tackling the issue would be to write my
own replication program, which would place new entries (flagged by a
date stamp) into an empty database and send the new database that just
contains the new records.
I am not sure if youare sending the database manually or
programatically. Manually, you could create an ftp site and place the
database there and dowload it.
I do not know the Report Manager, but I would guess as it is attached to
Access www.microsoft.com has a link to it.
Yehuda
-----Original Message-----
From: Zaragoza, Enzo [mailto:enzaux@y...]
Sent: Monday, January 28, 2002 10:43 PM
To: Access
Subject: [access] Re: Database in Two Different countries /
Replication
=09
=09
Help me guys pleeeeeeeeeeezzzzzzeeeeeeeeee
Enzo
----- Original Message -----
From: Zaragoza, Enzo <mailto:enzaux@y...>
To: Access <mailto:access@p...>
Sent: Monday, January 28, 2002 11:53 PM
Subject: [access] Database in Two Different countries /
Replication
Hi guys!!!!
I have used database replication as a solution to my
subject. But problem arises as I go through here are some of them:
1.) To update both database in Country1 and Country2,
both of them should send a replica of their database to update the
databases. The problem is with my Autonumber field which is also my
TranNo and my primary key of the table. When Country1 made an addition
to the table and also Country2 made an addition too. When sychronized,
the field goes berserk. For ex.
Last TranNo is 0008, then country1 made an
addition so country1 has TranNo 0009. On the other side, Country2 made
an addition so he will have TranNo 0009 too. When this two tables are
synchronized. the TranNo of this two records that were added would
become 10267829 and the other one 102983325. So my TranNo is messed up.
2.) If I make my TranNo not an autonumber but still the
primary key of the table still problem arise. I changed the TranNo to
text so that we can have a TranNo like PO-0001. Now the problem is,
when Country1 made a PO-0002 and Country made also PO-0002 and
sychronized an error occurs (Type Mismatch). Any solutions?
3.) Is it possible to make a replicate databases that
will contain ONLY those Records that were updated. I tried using
partial replica but still not good because I have to put a condition.
3.) As time goes by the database will grow insize
definitely. What if it's about 10 mb or greater, how would I transport
the replica? For smaller size I can attach it on emails but with large
size it would be impractical to attach it in email. Any ideas?
4.)I was trying to find Report Manager but I couldn't
find it. Any ideas where I can download it or find it?
Any suggestions or help would be greatly appreciated!!!
Thanks!!! Pleeeeeeez help :(
Thanks,
Enzo :)
----- Original Message -----
From: robin5151 <mailto:falconer5@b...>
To: ms_access@y...
Sent: Wednesday, January 16, 2002 7:49 PM
Subject: [ms_access] Re: Database in Two
Different countries
Hello Enzo,
=09
By far the easiest way to handle this is by
using replication. Then
the replication manager (a piece of software not
a person) will take
care of all the data and ID number issues for
you (or most of them).
=09
Replication is available in 97 and is documented
so you can look it
up in the help files.
=09
If you need any help give me a yell.
=09
Regards
Robin.
=09
--- In ms_access@y..., "Enzo Zaragoza"
<enzaux@y...> wrote:
> Hello!!!
>
> I would like to ask you some idea or
suggestions on how would I
setup the database program that I will do.
>
> What is the best way of setting up the
database if there are
two similar dbase program in Country1 and
Country2. what they want
is that all the updates made in Country1 will
also reflect in
Country2. And also the same the other way
around, if Country2 makes
an update Country1 should also be updated. Any
ideas?? Thanks!!!
>
> Enzo :)
>
>
> [Non-text portions of this message have been
removed]
=09
=09
=09
Yahoo! Groups Sponsor=09
ADVERTISEMENT
<http://rd.yahoo.com/M=3D213858.1791435.3314591.1261774/D=3Degroupweb/S=3D
1705
115370:HM/A=3D763352/R=3D0/*http://www.classmates.com/index.tf?s=3D5085>
=09
<http://us.adserver.yahoo.com/l?M=3D213858.1791435.3314591.1261774/D=3Deg
rou
pmail/S=3D1705115370:HM/A=3D763352/rand=3D506684245> =09
=09
http://groups.yahoo.com/group/visual-basic-beginners/
http://groups.yahoo.com/group/ms_excel
http://groups.yahoo.com/group/screenprinting
http://groups.yahoo.com/group/powerpoint
http://groups.yahoo.com/group/pkunzip
=09
http://groups.yahoo.com/group/photoshop-beginners
http://groups.yahoo.com/group/ms_access
=09
Your use of Yahoo! Groups is subject to the
Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
=09
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #5 by "Zaragoza, Enzo" <enzaux@y...> on Tue, 29 Jan 2002 22:39:27 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0083_01C1A915.CEC8D480
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
MessageThank you very much David and Yehuda!!!! It is a great idea.
One question, if you are making the programatic Autonumber (with country
name or first letter of the city) do you still create a field which
holds an Access Autonumber, like in this case TranID to be the primary
key or you make the TranNo already the primary key?
Thanks,
Enzo :)
----- Original Message -----
From: Yehuda Rosenblum
To: Access
Sent: Tuesday, January 29, 2002 10:12 PM
Subject: [access] Re: Database in Two Different countries /
Replication
I think the issue of the Trans numbers is because they are using the
same number. My guess is its a primary key which means when they update
the main database you end upo with duplicates in a primary key table.
The easiest solution is to generate the number programatically with the
country name as part of the number.
I know very little about database replication so I can't really tell
you much on that topic. My way of tackling the issue would be to write
my own replication program, which would place new entries (flagged by a
date stamp) into an empty database and send the new database that just
contains the new records.
I am not sure if youare sending the database manually or
programatically. Manually, you could create an ftp site and place the
database there and dowload it.
I do not know the Report Manager, but I would guess as it is attached
to Access www.microsoft.com has a link to it.
Yehuda
-----Original Message-----
From: Zaragoza, Enzo [mailto:enzaux@y...]
Sent: Monday, January 28, 2002 10:43 PM
To: Access
Subject: [access] Re: Database in Two Different countries /
Replication
Help me guys pleeeeeeeeeeezzzzzzeeeeeeeeee
Enzo
----- Original Message -----
From: Zaragoza, Enzo
To: Access
Sent: Monday, January 28, 2002 11:53 PM
Subject: [access] Database in Two Different countries /
Replication
Hi guys!!!!
I have used database replication as a solution to my subject.
But problem arises as I go through here are some of them:
1.) To update both database in Country1 and Country2, both of them
should send a replica of their database to update the databases. The
problem is with my Autonumber field which is also my TranNo and my
primary key of the table. When Country1 made an addition to the table
and also Country2 made an addition too. When sychronized, the field
goes berserk. For ex.
Last TranNo is 0008, then country1 made an addition so
country1 has TranNo 0009. On the other side, Country2 made an addition
so he will have TranNo 0009 too. When this two tables are synchronized.
the TranNo of this two records that were added would become 10267829 and
the other one 102983325. So my TranNo is messed up.
2.) If I make my TranNo not an autonumber but still the primary
key of the table still problem arise. I changed the TranNo to text so
that we can have a TranNo like PO-0001. Now the problem is, when
Country1 made a PO-0002 and Country made also PO-0002 and sychronized an
error occurs (Type Mismatch). Any solutions?
3.) Is it possible to make a replicate databases that will contain
ONLY those Records that were updated. I tried using partial replica but
still not good because I have to put a condition.
3.) As time goes by the database will grow insize definitely. What
if it's about 10 mb or greater, how would I transport the replica? For
smaller size I can attach it on emails but with large size it would be
impractical to attach it in email. Any ideas?
4.)I was trying to find Report Manager but I couldn't find it.
Any ideas where I can download it or find it?
Any suggestions or help would be greatly appreciated!!! Thanks!!!
Pleeeeeeez help :(
Thanks,
Enzo :)
----- Original Message -----
From: robin5151
To: ms_access@y...
Sent: Wednesday, January 16, 2002 7:49 PM
Subject: [ms_access] Re: Database in Two Different countries
Hello Enzo,
By far the easiest way to handle this is by using replication.
Then
the replication manager (a piece of software not a person) will
take
care of all the data and ID number issues for you (or most of
them).
Replication is available in 97 and is documented so you can look
it
up in the help files.
If you need any help give me a yell.
Regards
Robin.
--- In ms_access@y..., "Enzo Zaragoza" <enzaux@y...> wrote:
> Hello!!!
>
> I would like to ask you some idea or suggestions on how
would I
setup the database program that I will do.
>
> What is the best way of setting up the database if there
are
two similar dbase program in Country1 and Country2. what they
want
is that all the updates made in Country1 will also reflect in
Country2. And also the same the other way around, if Country2
makes
an update Country1 should also be updated. Any ideas??
Thanks!!!
>
> Enzo :)
>
>
> [Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
http://groups.yahoo.com/group/visual-basic-beginners/
http://groups.yahoo.com/group/ms_excel
http://groups.yahoo.com/group/screenprinting
http://groups.yahoo.com/group/powerpoint
http://groups.yahoo.com/group/pkunzip
http://groups.yahoo.com/group/photoshop-beginners
http://groups.yahoo.com/group/ms_access
Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
Message #6 by "Yehuda Rosenblum" <Yehuda@I...> on Tue, 29 Jan 2002 09:36:54 -0500
|
|
This is a multi-part message in MIME format.
------_=_NextPart_001_01C1A8D2.658A360B
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
No. I have the program parse the last records number and then increment
the number by one. This allows me to have full control over the number.
-----Original Message-----
From: Zaragoza, Enzo [mailto:enzaux@y...]
Sent: Tuesday, January 29, 2002 9:39 AM
To: Access
Subject: [access] Re: Database in Two Different countries /
Replication
=09
=09
Thank you very much David and Yehuda!!!! It is a great idea.
One question, if you are making the programatic Autonumber (with country
name or first letter of the city) do you still create a field which
holds an Access Autonumber, like in this case TranID to be the primary
key or you make the TranNo already the primary key?
Thanks,
Enzo :)
----- Original Message -----
From: Yehuda Rosenblum <mailto:Yehuda@I...>
To: Access <mailto:access@p...>
Sent: Tuesday, January 29, 2002 10:12 PM
Subject: [access] Re: Database in Two Different
countries / Replication
I think the issue of the Trans numbers is because they
are using the same number. My guess is its a primary key which means
when they update the main database you end upo with duplicates in a
primary key table. The easiest solution is to generate the number
programatically with the country name as part of the number.
I know very little about database replication so I can't
really tell you much on that topic. My way of tackling the issue would
be to write my own replication program, which would place new entries
(flagged by a date stamp) into an empty database and send the new
database that just contains the new records.
I am not sure if youare sending the database manually or
programatically. Manually, you could create an ftp site and place the
database there and dowload it.
I do not know the Report Manager, but I would guess as
it is attached to Access www.microsoft.com has a link to it.
Yehuda
-----Original Message-----
From: Zaragoza, Enzo [mailto:enzaux@y...]
Sent: Monday, January 28, 2002 10:43 PM
To: Access
Subject: [access] Re: Database in Two Different
countries / Replication
=09
=09
Help me guys pleeeeeeeeeeezzzzzzeeeeeeeeee
Enzo
----- Original Message -----
From: Zaragoza, Enzo
<mailto:enzaux@y...>
To: Access <mailto:access@p...>
Sent: Monday, January 28, 2002 11:53 PM
Subject: [access] Database in Two
Different countries / Replication
Hi guys!!!!
I have used database replication as
a solution to my subject. But problem arises as I go through here are
some of them:
1.) To update both database in Country1
and Country2, both of them should send a replica of their database to
update the databases. The problem is with my Autonumber field which is
also my TranNo and my primary key of the table. When Country1 made an
addition to the table and also Country2 made an addition too. When
sychronized, the field goes berserk. For ex.
Last TranNo is 0008, then country1
made an addition so country1 has TranNo 0009. On the other side,
Country2 made an addition so he will have TranNo 0009 too. When this
two tables are synchronized. the TranNo of this two records that were
added would become 10267829 and the other one 102983325. So my TranNo
is messed up.
2.) If I make my TranNo not an
autonumber but still the primary key of the table still problem arise.
I changed the TranNo to text so that we can have a TranNo like PO-0001.
Now the problem is, when Country1 made a PO-0002 and Country made also
PO-0002 and sychronized an error occurs (Type Mismatch). Any solutions?
3.) Is it possible to make a replicate
databases that will contain ONLY those Records that were updated. I
tried using partial replica but still not good because I have to put a
condition.
3.) As time goes by the database will
grow insize definitely. What if it's about 10 mb or greater, how would I
transport the replica? For smaller size I can attach it on emails but
with large size it would be impractical to attach it in email. Any
ideas?
4.)I was trying to find Report Manager
but I couldn't find it. Any ideas where I can download it or find it?
Any suggestions or help would be greatly
appreciated!!! Thanks!!! Pleeeeeeez help :(
Thanks,
Enzo :)
----- Original Message -----
From: robin5151
<mailto:falconer5@b...>
To: ms_access@y...
Sent: Wednesday, January 16, 2002 7:49
PM
Subject: [ms_access] Re: Database in Two
Different countries
Hello Enzo,
=09
By far the easiest way to handle this is
by using replication. Then
the replication manager (a piece of
software not a person) will take
care of all the data and ID number
issues for you (or most of them).
=09
Replication is available in 97 and is
documented so you can look it
up in the help files.
=09
If you need any help give me a yell.
=09
Regards
Robin.
=09
--- In ms_access@y..., "Enzo Zaragoza"
<enzaux@y...> wrote:
> Hello!!!
>
> I would like to ask you some idea
or suggestions on how would I
setup the database program that I will
do.
>
> What is the best way of setting up
the database if there are
two similar dbase program in Country1
and Country2. what they want
is that all the updates made in Country1
will also reflect in
Country2. And also the same the other
way around, if Country2 makes
an update Country1 should also be
updated. Any ideas?? Thanks!!!
>
> Enzo :)
>
>
> [Non-text portions of this message
have been removed]
=09
=09
=09
Yahoo! Groups Sponsor=09
ADVERTISEMENT
<http://rd.yahoo.com/M=3D213858.1791435.3314591.1261774/D=3Degroupweb/S=3D
1705
115370:HM/A=3D763352/R=3D0/*http://www.classmates.com/index.tf?s=3D5085>
=09
<http://us.adserver.yahoo.com/l?M=3D213858.1791435.3314591.1261774/D=3Deg
rou
pmail/S=3D1705115370:HM/A=3D763352/rand=3D506684245> =09
=09
http://groups.yahoo.com/group/visual-basic-beginners/
http://groups.yahoo.com/group/ms_excel
=09
http://groups.yahoo.com/group/screenprinting
http://groups.yahoo.com/group/powerpoint
http://groups.yahoo.com/group/pkunzip
=09
http://groups.yahoo.com/group/photoshop-beginners
http://groups.yahoo.com/group/ms_access
=09
Your use of Yahoo! Groups is subject to
the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .
=09
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #7 by "Randy Cornish" <rlcornish@c...> on Wed, 30 Jan 2002 00:24:58
|
|
If its easier, you can create two fields: CountryCode (String) and ID
(AutoNumber). Then, make the Primary Key a two-field key.
Example:
USA-000101 and UK-000101
Then, you just need to make sure that each database persists a
CountryCode in some other table in the database. Create a rule that
records cannot be added if the countrycode is not setup.
R
> No. I have the program parse the last records number and then increment
> the number by one. This allows me to have full control over the number.
>
> Thank you very much David and Yehuda!!!! It is a great idea.
> One question, if you are making the programatic Autonumber (with country
> name or first letter of the city) do you still create a field which
> holds an Access Autonumber, like in this case TranID to be the primary
> key or you make the TranNo already the primary key?
>
> Thanks,
>
> Enzo :)
Message #8 by "David Chapman" <luckychap@b...> on Wed, 30 Jan 2002 19:14:47 +1030
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_0036_01C1A9C2.61FB6720
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: 7bit
MessageForget the words "autonumber". You have to create a unique key which
will be your primary Key - for both data bases.
-----Original Message-----
From: Zaragoza, Enzo [mailto:enzaux@y...]
Sent: Wednesday, January 30, 2002 1:09 AM
To: Access
Subject: [access] Re: Database in Two Different countries / Replication
Thank you very much David and Yehuda!!!! It is a great idea. One
question, if you are making the programatic Autonumber (with country name or
first letter of the city) do you still create a field which holds an Access
Autonumber, like in this case TranID to be the primary key or you make the
TranNo already the primary key?
Thanks,
Enzo :)
----- Original Message -----
From: Yehuda Rosenblum
To: Access
Sent: Tuesday, January 29, 2002 10:12 PM
Subject: [access] Re: Database in Two Different countries / Replication
I think the issue of the Trans numbers is because they are using the
same number. My guess is its a primary key which means when they update the
main database you end upo with duplicates in a primary key table. The
easiest solution is to generate the number programatically with the country
name as part of the number.
I know very little about database replication so I can't really tell you
much on that topic. My way of tackling the issue would be to write my own
replication program, which would place new entries (flagged by a date stamp)
into an empty database and send the new database that just contains the new
records.
I am not sure if youare sending the database manually or
programatically. Manually, you could create an ftp site and place the
database there and dowload it.
I do not know the Report Manager, but I would guess as it is attached to
Access www.microsoft.com has a link to it.
Yehuda
-----Original Message-----
From: Zaragoza, Enzo [mailto:enzaux@y...]
Sent: Monday, January 28, 2002 10:43 PM
To: Access
Subject: [access] Re: Database in Two Different countries /
Replication
Help me guys pleeeeeeeeeeezzzzzzeeeeeeeeee
Enzo
----- Original Message -----
From: Zaragoza, Enzo
To: Access
Sent: Monday, January 28, 2002 11:53 PM
Subject: [access] Database in Two Different countries / Replication
Hi guys!!!!
I have used database replication as a solution to my subject.
But problem arises as I go through here are some of them:
1.) To update both database in Country1 and Country2, both of them
should send a replica of their database to update the databases. The
problem is with my Autonumber field which is also my TranNo and my primary
key of the table. When Country1 made an addition to the table and also
Country2 made an addition too. When sychronized, the field goes berserk.
For ex.
Last TranNo is 0008, then country1 made an addition so
country1 has TranNo 0009. On the other side, Country2 made an addition so
he will have TranNo 0009 too. When this two tables are synchronized. the
TranNo of this two records that were added would become 10267829 and the
other one 102983325. So my TranNo is messed up.
2.) If I make my TranNo not an autonumber but still the primary key
of the table still problem arise. I changed the TranNo to text so that we
can have a TranNo like PO-0001. Now the problem is, when Country1 made a
PO-0002 and Country made also PO-0002 and sychronized an error occurs (Type
Mismatch). Any solutions?
3.) Is it possible to make a replicate databases that will contain
ONLY those Records that were updated. I tried using partial replica but
still not good because I have to put a condition.
3.) As time goes by the database will grow insize definitely. What
if it's about 10 mb or greater, how would I transport the replica? For
smaller size I can attach it on emails but with large size it would be
impractical to attach it in email. Any ideas?
4.)I was trying to find Report Manager but I couldn't find it. Any
ideas where I can download it or find it?
Any suggestions or help would be greatly appreciated!!! Thanks!!!
Pleeeeeeez help :(
Thanks,
Enzo :)
----- Original Message -----
From: robin5151
To: ms_access@y...
Sent: Wednesday, January 16, 2002 7:49 PM
Subject: [ms_access] Re: Database in Two Different countries
Hello Enzo,
By far the easiest way to handle this is by using replication.
Then
the replication manager (a piece of software not a person) will
take
care of all the data and ID number issues for you (or most of
them).
Replication is available in 97 and is documented so you can look
it
up in the help files.
If you need any help give me a yell.
Regards
Robin.
--- In ms_access@y..., "Enzo Zaragoza" <enzaux@y...> wrote:
> Hello!!!
>
> I would like to ask you some idea or suggestions on how
would I
setup the database program that I will do.
>
> What is the best way of setting up the database if there are
two similar dbase program in Country1 and Country2. what they
want
is that all the updates made in Country1 will also reflect in
Country2. And also the same the other way around, if Country2
makes
an update Country1 should also be updated. Any ideas?? Thanks!!!
>
> Enzo :)
>
>
> [Non-text portions of this message have been removed]
Yahoo! Groups Sponsor
ADVERTISEMENT
http://groups.yahoo.com/group/visual-basic-beginners/
http://groups.yahoo.com/group/ms_excel
http://groups.yahoo.com/group/screenprinting
http://groups.yahoo.com/group/powerpoint
http://groups.yahoo.com/group/pkunzip
http://groups.yahoo.com/group/photoshop-beginners
http://groups.yahoo.com/group/ms_access
Your use of Yahoo! Groups is subject to the Yahoo! Terms of
Service.
$subst('Email.Unsub').
$subst('Email.Unsub').
Message #9 by "Zaragoza, Enzo" <enzaux@y...> on Wed, 30 Jan 2002 22:30:57 +0800
|
|
This is a multi-part message in MIME format.
------=_NextPart_000_002F_01C1A9DD.C9A22D80
Content-Type: text/plain;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Thanks Randy for the idea eventhough I quitted using replication method.
It may be of used in the future, Thanks!!!!!
I used the importing and exporting method its not as credible as
REplication but it is more convenient sending updates everyday in each
country especially when the database grow in size.
Enzo :)
----- Original Message -----
From: Randy Cornish
To: Access
Sent: Wednesday, January 30, 2002 12:24 AM
Subject: [access] Re: Database in Two Different countries /
Replication
If its easier, you can create two fields: CountryCode (String) and ID
(AutoNumber). Then, make the Primary Key a two-field key.
Example:
USA-000101 and UK-000101
Then, you just need to make sure that each database persists a
CountryCode in some other table in the database. Create a rule that
records cannot be added if the countrycode is not setup.
R
> No. I have the program parse the last records number and then
increment
> the number by one. This allows me to have full control over the
number.
>
> Thank you very much David and Yehuda!!!! It is a great idea.
> One question, if you are making the programatic Autonumber (with
country
> name or first letter of the city) do you still create a field which
> holds an Access Autonumber, like in this case TranID to be the
primary
> key or you make the TranNo already the primary key?
> =3D20
> Thanks,
> =3D20
> Enzo :)
$subst('Email.Unsub').
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
|
|
|
View Cart
