Remote database

[salimshahzad]

Dear Gurus,

we have 3 branches in variuos locations say various city. they are
linked as VPN, WAN...you can say internal LAN.

we wanted to developed a centeralised database where all users from
branches enter at a single locations.

I need to know 2scenerio solutions
- if v have single db and all remote users accessing, what method, and
if we make web pages in as or access web page does this helps, can v
print report queries from web access page?
- if v have 3 various locations database, and wanted to data come as
batch at the end of day so how will it process
any ideas will be appreciated

thanks and regards
shahzad

 

[Joseph Meehan]

Dear Gurus,

we have 3 branches in variuos locations say various city. they are
linked as VPN, WAN...you can say internal LAN.

we wanted to developed a centeralised database where all users from
branches enter at a single locations.

I need to know 2scenerio solutions
- if v have single db and all remote users accessing, what method, and
if we make web pages in as or access web page does this helps, can v
print report queries from web access page?
- if v have 3 various locations database, and wanted to data come as
batch at the end of day so how will it process
any ideas will be appreciated

thanks and regards
shahzad

How many users at one time?

I suggest a split database with all (or almost all) the data stored in
an Access database (the back end) on a server where each user has access to
read, write, create, delete, and modify data and files.

Each user then has another Access database on their machine with
queries, forms and reports as they need as well as possibly some tables.
They will also have links to the data on the back end database.

How successful this will be depends on how stable your communications
are and how many users may be on the system at the same time

Security can be provided by Access user level security.

 

[MacDermott]

Do not confuse a WAN with an internal LAN.
Just because you can view directories and transfer files over it,
doesn't mean that its capabilities are anything like those of an in-house
network.
While Access databases can work very well over an internal LAN, WANs in
general do not easily support the level of network traffic an Access
database requires.