By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,264 Members | 1,087 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,264 IT Pros & Developers. It's quick & easy.

linking databases in two different countries

P: n/a
I need some advice about an MS Access database which is used to track
inventory shipped from the US to Bolivia. In the US, the data is
entered on a laptop and the database is stored on the laptop which is
not connected to the small office network or the internet. The
company's website host has a hosting option for an Access database.
Currently we enter the inventory data using barcodes in the US and
then ship the inventory to Bolivia. At the recieving end in Bolivia
we would like to scan the barcodes and record that the box has arrived
and where it will be stored in the warehouse. Sometimes the inventory
data is entered at a location that does not have a connection to the
internet so we would have to then connect the laptop to the internet
and synch up the database.
Before I start in on figuring this on on my own and learning from
trial and error I would appreciate any advice on this subject, both
general advice and especially programming details.
Thanks in advance.

Feb 19 '07 #1
Share this Question
Share on Google+
6 Replies


P: n/a
On Feb 19, 11:09 am, rcmail14...@yahoo.com wrote:
I need some advice about an MS Access database which is used to track
inventory shipped from the US to Bolivia. In the US, the data is
entered on a laptop and the database is stored on the laptop which is
not connected to the small office network or the internet. The
company's website host has a hosting option for an Access database.
Currently we enter the inventory data using barcodes in the US and
then ship the inventory to Bolivia. At the recieving end in Bolivia
we would like to scan the barcodes and record that the box has arrived
and where it will be stored in the warehouse. Sometimes the inventory
data is entered at a location that does not have a connection to the
internet so we would have to then connect the laptop to the internet
and synch up the database.
Before I start in on figuring this on on my own and learning from
trial and error I would appreciate any advice on this subject, both
general advice and especially programming details.
Thanks in advance.
1) Consider using remote desktop connection software such as Microsoft
Terminal Services:

http://www.microsoft.com/windowsserv...s/default.mspx

2) You can upsize your database tables to SQL Server and have all
front ends, wherever they may be in the world, connect to those
tables. If your location does not have an internet connection, you
need to come up with a system that appends new information to your
transaction details table for each item, checking first whether the
items exists, and adding the relevant information.

Also, consider using a portable scanner so that you don't have to
transport each individual item to the computer.

Alexandre Bejerman
Montreal, Canada

Feb 19 '07 #2

P: n/a
On Feb 19, 11:02 am, abe...@hotmail.com wrote:
On Feb 19, 11:09 am, rcmail14...@yahoo.com wrote:
I need some advice about an MS Access database which is used to track
inventory shipped from the US to Bolivia. In the US, the data is
entered on a laptop and the database is stored on the laptop which is
not connected to the small office network or the internet. The
company's website host has a hosting option for an Access database.
Currently we enter the inventory data using barcodes in the US and
then ship the inventory to Bolivia. At the recieving end in Bolivia
we would like to scan the barcodes and record that the box has arrived
and where it will be stored in the warehouse. Sometimes the inventory
data is entered at a location that does not have a connection to the
internet so we would have to then connect the laptop to the internet
and synch up the database.
Before I start in on figuring this on on my own and learning from
trial and error I would appreciate any advice on this subject, both
general advice and especially programming details.
Thanks in advance.

1) Consider using remote desktop connection software such as Microsoft
Terminal Services:

http://www.microsoft.com/windowsserv.../terminalservi...

2) You can upsize your database tables to SQL Server and have all
front ends, wherever they may be in the world, connect to those
tables. If your location does not have an internet connection, you
need to come up with a system that appends new information to your
transaction details table for each item, checking first whether the
items exists, and adding the relevant information.

Also, consider using a portable scanner so that you don't have to
transport each individual item to the computer.

Alexandre Bejerman
Montreal, Canada
Thanks for the reply and the advice. We connect a portable scanner to
the laptop and bring the laptop to the warehouse and scan the
inventory and since the database is on the laptop it is updated as we
go, but, when the database is moved to a hosted location on the
internet, then, after updating the laptop with new inventory, the
database on the laptop is going to need to be synched up with the
database on the internet. Sometimes, we will be able to have the
laptop connected to the internet while adding inventory data, but not
always. The same thing will happen at the sending and receiving ends
of the shipment (synching the laptop). I don't know anything about
synching up databases. Any tips to avoid deleting records or
generally messing up the database? Or is this easier than it looks?

Feb 20 '07 #3

P: n/a
On Feb 19, 7:08 pm, rcmail14...@yahoo.com wrote:
On Feb 19, 11:02 am, abe...@hotmail.com wrote:


On Feb 19, 11:09 am, rcmail14...@yahoo.com wrote:
I need some advice about an MS Access database which is used to track
inventory shipped from the US to Bolivia. In the US, the data is
entered on a laptop and the database is stored on the laptop which is
not connected to the small office network or the internet. The
company's website host has a hosting option for an Access database.
Currently we enter the inventory data using barcodes in the US and
then ship the inventory to Bolivia. At the recieving end in Bolivia
we would like to scan the barcodes and record that the box has arrived
and where it will be stored in the warehouse. Sometimes the inventory
data is entered at a location that does not have a connection to the
internet so we would have to then connect the laptop to the internet
and synch up the database.
Before I start in on figuring this on on my own and learning from
trial and error I would appreciate any advice on this subject, both
general advice and especially programming details.
Thanks in advance.
1) Consider using remote desktop connection software such as Microsoft
Terminal Services:
http://www.microsoft.com/windowsserv.../terminalservi...
2) You can upsize your database tables to SQL Server and have all
front ends, wherever they may be in the world, connect to those
tables. If your location does not have an internet connection, you
need to come up with a system that appends new information to your
transaction details table for each item, checking first whether the
items exists, and adding the relevant information.
Also, consider using a portable scanner so that you don't have to
transport each individual item to the computer.
AlexandreBejerman
Montreal, Canada

Thanks for the reply and the advice. We connect a portable scanner to
the laptop and bring the laptop to the warehouse and scan the
inventory and since the database is on the laptop it is updated as we
go, but, when the database is moved to a hosted location on the
internet, then, after updating the laptop with new inventory, the
database on the laptop is going to need to be synched up with the
database on the internet. Sometimes, we will be able to have the
laptop connected to the internet while adding inventory data, but not
always. The same thing will happen at the sending and receiving ends
of the shipment (synching the laptop). I don't know anything about
synching up databases. Any tips to avoid deleting records or
generally messing up the database? Or is this easier than it looks?- Hide quoted text -

- Show quoted text -
Let's consider what you're going to do and what you already have.

Presumably, since you're scanning items, you have already created
those items: Each of those items has a unique identifier and resides
on the table tblItems. Using a one-to-many relationship, you also
need a table called tblTransactions, in which each item can have many
transactions. You can perform one of two transactions at any given
moment: _Add_ a product or _Remove_ a product. The amount available
(quantity) for an item is determined by summing up all the "adds" and
subtracting the "removes." There is no other way of doing this. This
should be your primary setup.

All you need to do is create a temporary table tblTempTransactions
that performs the exact same operations as its original and append it
when need be to your main copy:

1) No items in tblItems are lost or overwritten since they presumably
already exist before you even go about scanning. Remember all those
cute little labels you printed out in the first place? If for some
reason the item does not exist when you try to append, you will have
to determine why before you create it.

2) Each transaction is a separate entity. If you add an item in
Bolivia and remove it in Texas, none will affect the other.

Good luck.

Alexandre Bejerman
Montreal, Canada

Feb 20 '07 #4

P: n/a
On Feb 19, 8:32 pm, abe...@hotmail.com wrote:
On Feb 19, 7:08 pm, rcmail14...@yahoo.com wrote:
On Feb 19, 11:02 am, abe...@hotmail.com wrote:
On Feb 19, 11:09 am, rcmail14...@yahoo.com wrote:
I need some advice about an MS Access database which is used to track
inventory shipped from the US to Bolivia. In the US, the data is
entered on a laptop and the database is stored on the laptop which is
not connected to the small office network or the internet. The
company's website host has a hosting option for an Access database.
Currently we enter the inventory data using barcodes in the US and
then ship the inventory to Bolivia. At the recieving end in Bolivia
we would like to scan the barcodes and record that the box has arrived
and where it will be stored in the warehouse. Sometimes the inventory
data is entered at a location that does not have a connection to the
internet so we would have to then connect the laptop to the internet
and synch up the database.
Before I start in on figuring this on on my own and learning from
trial and error I would appreciate any advice on this subject, both
general advice and especially programming details.
Thanks in advance.
1) Consider using remote desktop connection software such as Microsoft
Terminal Services:
>http://www.microsoft.com/windowsserv.../terminalservi...
2) You can upsize your database tables to SQL Server and have all
front ends, wherever they may be in the world, connect to those
tables. If your location does not have an internet connection, you
need to come up with a system that appends new information to your
transaction details table for each item, checking first whether the
items exists, and adding the relevant information.
Also, consider using a portable scanner so that you don't have to
transport each individual item to the computer.
AlexandreBejerman
Montreal, Canada
Thanks for the reply and the advice. We connect a portable scanner to
the laptop and bring the laptop to the warehouse and scan the
inventory and since the database is on the laptop it is updated as we
go, but, when the database is moved to a hosted location on the
internet, then, after updating the laptop with new inventory, the
database on the laptop is going to need to be synched up with the
database on the internet. Sometimes, we will be able to have the
laptop connected to the internet while adding inventory data, but not
always. The same thing will happen at the sending and receiving ends
of the shipment (synching the laptop). I don't know anything about
synching up databases. Any tips to avoid deleting records or
generally messing up the database? Or is this easier than it looks?- Hide quoted text -
- Show quoted text -

Let's consider what you're going to do and what you already have.

Presumably, since you're scanning items, you have already created
those items: Each of those items has a unique identifier and resides
on the table tblItems. Using a one-to-many relationship, you also
need a table called tblTransactions, in which each item can have many
transactions. You can perform one of two transactions at any given
moment: _Add_ a product or _Remove_ a product. The amount available
(quantity) for an item is determined by summing up all the "adds" and
subtracting the "removes." There is no other way of doing this. This
should be your primary setup.

All you need to do is create a temporary table tblTempTransactions
that performs the exact same operations as its original and append it
when need be to your main copy:

1) No items in tblItems are lost or overwritten since they presumably
already exist before you even go about scanning. Remember all those
cute little labels you printed out in the first place? If for some
reason the item does not exist when you try to append, you will have
to determine why before you create it.

2) Each transaction is a separate entity. If you add an item in
Bolivia and remove it in Texas, none will affect the other.

Good luck.

Alexandre Bejerman
Montreal, Canada
I am thinking of using the Access drop-down menus Tools Replication
Create Replica, and then copy the design master to the internet
host. Then make another copy for Bolivia and then before and after
the user updates the database on the laptop they can use the Access
menu to synchronize the laptop database to the internet master
database.

Feb 20 '07 #5

P: n/a
On Feb 19, 10:55 pm, rcmail14...@yahoo.com wrote:
On Feb 19, 8:32 pm, abe...@hotmail.com wrote:


On Feb 19, 7:08 pm, rcmail14...@yahoo.com wrote:
On Feb 19, 11:02 am, abe...@hotmail.com wrote:
On Feb 19, 11:09 am, rcmail14...@yahoo.com wrote:
I need some advice about an MS Access database which is used to track
inventory shipped from the US to Bolivia. In the US, the data is
entered on a laptop and the database is stored on the laptop which is
not connected to the small office network or the internet. The
company's website host has a hosting option for an Access database.
Currently we enter the inventory data using barcodes in the US and
then ship the inventory to Bolivia. At the recieving end in Bolivia
we would like to scan the barcodes and record that the box has arrived
and where it will be stored in the warehouse. Sometimes the inventory
data is entered at a location that does not have a connection to the
internet so we would have to then connect the laptop to the internet
and synch up the database.
Before I start in on figuring this on on my own and learning from
trial and error I would appreciate any advice on this subject, both
general advice and especially programming details.
Thanks in advance.
1) Consider using remote desktop connection software such as Microsoft
Terminal Services:
http://www.microsoft.com/windowsserv.../terminalservi...
2) You can upsize your database tables to SQL Server and have all
front ends, wherever they may be in the world, connect to those
tables. If your location does not have an internet connection, you
need to come up with a system that appends new information to your
transaction details table for each item, checking first whether the
items exists, and adding the relevant information.
Also, consider using a portable scanner so that you don't have to
transport each individual item to the computer.
AlexandreBejerman
Montreal, Canada
Thanks for the reply and the advice. We connect a portable scanner to
the laptop and bring the laptop to the warehouse and scan the
inventory and since the database is on the laptop it is updated as we
go, but, when the database is moved to a hosted location on the
internet, then, after updating the laptop with new inventory, the
database on the laptop is going to need to be synched up with the
database on the internet. Sometimes, we will be able to have the
laptop connected to the internet while adding inventory data, but not
always. The same thing will happen at the sending and receiving ends
of the shipment (synching the laptop). I don't know anything about
synching up databases. Any tips to avoid deleting records or
generally messing up the database? Or is this easier than it looks?- Hide quoted text -
- Show quoted text -
Let's consider what you're going to do and what you already have.
Presumably, since you're scanning items, you have already created
those items: Each of those items has a unique identifier and resides
on the table tblItems. Using a one-to-many relationship, you also
need a table called tblTransactions, in which each item can have many
transactions. You can perform one of two transactions at any given
moment: _Add_ a product or _Remove_ a product. The amount available
(quantity) for an item is determined by summing up all the "adds" and
subtracting the "removes." There is no other way of doing this. This
should be your primary setup.
All you need to do is create a temporary table tblTempTransactions
that performs the exact same operations as its original and append it
when need be to your main copy:
1) No items in tblItems are lost or overwritten since they presumably
already exist before you even go about scanning. Remember all those
cute little labels you printed out in the first place? If for some
reason the item does not exist when you try to append, you will have
to determine why before you create it.
2) Each transaction is a separate entity. If you add an item in
Bolivia and remove it in Texas, none will affect the other.
Good luck.
Alexandre Bejerman
Montreal, Canada

I am thinking of using the Access drop-down menus Tools ReplicationCreate Replica, and then copy the design master to the internet

host. Then make another copy for Bolivia and then before and after
the user updates the database on the laptop they can use the Access
menu to synchronize the laptop database to the internet master
database.- Hide quoted text -

- Show quoted text -
Be my guest. But as you'll see from previous comments here, that road
is more grief than gravy.

Feb 20 '07 #6

P: n/a
On Feb 19, 11:21 pm, abe...@hotmail.com wrote:
On Feb 19, 10:55 pm, rcmail14...@yahoo.com wrote:


On Feb 19, 8:32 pm, abe...@hotmail.com wrote:
On Feb 19, 7:08 pm, rcmail14...@yahoo.com wrote:
On Feb 19, 11:02 am, abe...@hotmail.com wrote:
On Feb 19, 11:09 am, rcmail14...@yahoo.com wrote:
I need some advice about an MS Access database which is used to track
inventory shipped from the US toBolivia. In the US, the data is
entered on a laptop and the database is stored on the laptop which is
not connected to the small office network or the internet. The
company's website host has a hosting option for an Access database.
Currently we enter the inventory data using barcodes in the US and
then ship the inventory toBolivia. At the recieving end inBolivia
we would like to scan the barcodes and record that the box has arrived
and where it will be stored in the warehouse. Sometimes the inventory
data is entered at a location that does not have a connection to the
internet so we would have to then connect the laptop to the internet
and synch up the database.
Before I start in on figuring this on on my own and learning from
trial and error I would appreciate any advice on this subject, both
general advice and especially programming details.
Thanks in advance.
1) Consider using remote desktop connection software such as Microsoft
Terminal Services:
>http://www.microsoft.com/windowsserv.../terminalservi...
2) You can upsize your database tables to SQL Server and have all
front ends, wherever they may be in the world, connect to those
tables. If your location does not have an internet connection, you
need to come up with a system that appends new information to your
transaction details table for each item, checking first whether the
items exists, and adding the relevant information.
Also, consider using a portable scanner so that you don't have to
transport each individual item to the computer.
AlexandreBejerman
Montreal, Canada
Thanks for the reply and the advice. We connect a portable scanner to
the laptop and bring the laptop to the warehouse and scan the
inventory and since the database is on the laptop it is updated as we
go, but, when the database is moved to a hosted location on the
internet, then, after updating the laptop with new inventory, the
database on the laptop is going to need to be synched up with the
database on the internet. Sometimes, we will be able to have the
laptop connected to the internet while adding inventory data, but not
always. The same thing will happen at the sending and receiving ends
of the shipment (synching the laptop). I don't know anything about
synching up databases. Any tips to avoid deleting records or
generally messing up the database? Or is this easier than it looks?- Hide quoted text -
- Show quoted text -
Let's consider what you're going to do and what you already have.
Presumably, since you're scanning items, you have already created
those items: Each of those items has a unique identifier and resides
on the table tblItems. Using a one-to-many relationship, you also
need a table called tblTransactions, in which each item can have many
transactions. You can perform one of two transactions at any given
moment: _Add_ a product or _Remove_ a product. The amount available
(quantity) for an item is determined by summing up all the "adds" and
subtracting the "removes." There is no other way of doing this. This
should be your primary setup.
All you need to do is create a temporary table tblTempTransactions
that performs the exact same operations as its original and append it
when need be to your main copy:
1) No items in tblItems are lost or overwritten since they presumably
already exist before you even go about scanning. Remember all those
cute little labels you printed out in the first place? If for some
reason the item does not exist when you try to append, you will have
to determine why before you create it.
2) Each transaction is a separate entity. If you add an item in
>Boliviaand remove it in Texas, none will affect the other.
Good luck.
Alexandre Bejerman
Montreal, Canada
I am thinking of using the Access drop-down menus Tools ReplicationCreate Replica, and then copy the design master to the internet
host. Then make another copy forBoliviaand then before and after
the user updates the database on the laptop they can use the Access
menu to synchronize the laptop database to the internet master
database.- Hide quoted text -
- Show quoted text -

Be my guest. But as you'll see from previous comments here, that road
is more grief than gravy.- Hide quoted text -

- Show quoted text -
Thanks for the info *not* to use Access drop-down menus Tools >
ReplicationCreate Replica. that's why I am asking for advice, which
method should I use to do this?

Feb 20 '07 #7

This discussion thread is closed

Replies have been disabled for this discussion.