Sharing Access databases remotely

[Rafi]

Are there any good primers / sites / docs on how to share an access database
among remote users? My business has a network of field agents, all of whom
need to obtain and submit various data to headquarters on a daily basis.
We're having a system custom-built for this, but need a solution in the
meantime that is quick/simple to implement and easy to use. Sorry, I know
this probably is an amateur question...

 

[Albert D. Kallal]

Are there any good primers / sites / docs on how to share an access
database
among remote users? My business has a network of field agents, all of
whom
need to obtain and submit various data to headquarters on a daily basis.
We're having a system custom-built for this, but need a solution in the
meantime that is quick/simple to implement and easy to use. Sorry, I know
this probably is an amateur question...

I mention some options here:

http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html


In addition to the above, you can use SharePoint, and even the free "office
live" edition. Using office.com you can be sharing your data in an access
application in very little time..and no sql server (in fact you don't need
any server -- just install your software on each pc..and they are up and
running).

 

[Noel]

If you are trying to access the data in an Access .mdb file, you can
interrogate that file using ADO. You can do this from any office application
using VBA code. You can also do it from Internet Explorer using either
VBScript or JavaScript. I cannot testify as to the use of other browsers, but
I feel reasonably sure that it can be done. Incidentally, the browser does
not need to be looking at a web server to be able to access the file; it can
simply be looking at a file held by an intranet file server, if that is your
situation.

Cheers, Noel

 

[Dominic Vella]

Best idea is to create a new table for the purpose of updating. Copy data
from the field agents using a predetermined format and then use an update
query to do the comparisons/updates. I think it a pretty tricky task, but
under the circumstances it is the simplest solution I can think of.

Still, I'd suggest that you should go to the contractors who are doing your
custom-built database and tell them to fix your immediate problem first as
the project their working on now has to do the same thing anyway.

I hope that gives you a head start. Just yell out if you need more
assistance.

Dominic
www.effectivedata.com.au