Integrating Data from multiple Access databases

[Guest]

What would be the best way to integrate data from multiple access databases
into a single database on a regular basis (needed to be done everyday)
- Users will be entering data into an access database in multiple locations.
The forms and DB structure will be the same. Basically they will have a VBA
application on their laptops.
-The data from these multiple databases needs to loaded into a single
central database so as to drive a web application and make this data
available online.

** As the data entry people will not have access to internet, this cannot be
made an online application with simple ASP forms and a single database.

-Is it possible to have a way to load data from multiple access DBs into a
single SQL server db on a regular basis? Is SQL server a solution to having a
single DB - is importing data from access into SQL a smooth process?

Have not done adequate homework but any kind of suggestions would greatly
help. I can give more details as they become available.

Thanks
Ram

 

[Dirk Goldgar]

What would be the best way to integrate data from multiple access
databases into a single database on a regular basis (needed to be
done everyday) - Users will be entering data into an access database
in multiple locations. The forms and DB structure will be the same.
Basically they will have a VBA application on their laptops.
-The data from these multiple databases needs to loaded into a single
central database so as to drive a web application and make this data
available online.

** As the data entry people will not have access to internet, this
cannot be made an online application with simple ASP forms and a
single database.

-Is it possible to have a way to load data from multiple access DBs
into a single SQL server db on a regular basis? Is SQL server a
solution to having a single DB - is importing data from access into
SQL a smooth process?

Have not done adequate homework but any kind of suggestions would
greatly help. I can give more details as they become available.

This may be a good situation to use Replication. I haven't used it
much, but you should be able to read about it in the help file.
Basically, you designate one copy of the database as the "design master"
and clone a bunch of "replicas". Each remore user gets a replica.
Periodically, the replicas are brought together and synchronized with
the design master, so everyone ends up with the same data. As I said,
I'm no expert on it, but you should be able to find out a lot more about
it if you poke around.