compile data from multiple locations

[Alice]

Hello-
I would like to create a database where data from multiple sites can be
compiled into one. One option to have each site email the data, and for me to
compile it manually into one database.

However, with data access page, is it possible for each site to add to the
same database (stored, say, on my computer) over the internet? They do not
need to view or manipulate the data from each site; what I want to do is to
have it all compiled in one place, such that I can view/manipulate the data.

Thanks!

Alice

 

[John W. Vinson]

However, with data access page, is it possible for each site to add to the
same database (stored, say, on my computer) over the internet? They do not
need to view or manipulate the data from each site; what I want to do is to
have it all compiled in one place, such that I can view/manipulate the data.

It's just barely possible... but Microsoft has basically abandoned the DAP as
a practical solution. It's got lots of problems.

What my clients (and lots of others facing this issue) are doing is using a
remote terminal approach such as Citrix Server or Windows Terminal. The remote
users actually log on to your computer which runs Access and has the database.

An alternative would be to use SQL/Server Express and a web-based interface
such as an Access Data Project.

John W. Vinson [MVP]

 

[David W. Fenton]

It's just barely possible... but Microsoft has basically abandoned
the DAP as a practical solution. It's got lots of problems.

What my clients (and lots of others facing this issue) are doing
is using a remote terminal approach such as Citrix Server or
Windows Terminal. The remote users actually log on to your
computer which runs Access and has the database.

An alternative would be to use SQL/Server Express and a web-based
interface such as an Access Data Project.

Replication is also a candidate, but I'd use Windows Terminal
Server, instead, unless I had users who needed to edit the data
while disconnected from the Internet.

 

[John W. Vinson]

Replication is also a candidate, but I'd use Windows Terminal
Server, instead, unless I had users who needed to edit the data
while disconnected from the Internet.

I don't have any direct experience with Windows Terminal Server - my big
clients already had chosen Citrix - but by all accounts it's equally
appropriate.

I'd use replication only if pushed to the wall... it's a pain to manage!!! (I
*have* used it... but I was pushed to the wall.)

John W. Vinson [MVP]

 

[David W. Fenton]

I don't have any direct experience with Windows Terminal Server -
my big clients already had chosen Citrix - but by all accounts
it's equally appropriate.

I consider Citrix to be the same as WTS, at least from the point of
view of the Access developer and the end users. It's the
administration and app installation that's different, but
functionally, they are equivalent.

I'd use replication only if pushed to the wall... it's a pain to
manage!!! (I *have* used it... but I was pushed to the wall.)

For supporting laptops who come into the office and plug back into
the LAN, it's pretty darned trivial. It's only when they need to
synch remotely, across the Internet or a WAN that it gets
complicated.

Or, so it seems to someone who's been doing replication since 1997.

 

[John W. Vinson]

For supporting laptops who come into the office and plug back into
the LAN, it's pretty darned trivial. It's only when they need to
synch remotely, across the Internet or a WAN that it gets
complicated.
Agreed.

Or, so it seems to someone who's been doing replication since 1997.

Well, I wish I had your experience!

John W. Vinson [MVP]

 

[David W. Fenton]

Well, I wish I had your experience!

No you don't! The experiences caused me to lose a lot of my hair!