Emailing a database to a remote user

K

Kylie

I have an Access database set up with a table and form and the databse is
split into back and front ends as we have four users accessing the database.
My problem is that one member of our team resides in a different city and I
need her to have a copy of the database to enter and edit data in and then
return to me so that her data can be imported into the database at our end.

I know that it is not possible to email a form on its own from what I have
read here already. I would appreciate any suggestions of how this can work!!

Thanks.
 
A

A C

Kylie said:
I have an Access database set up with a table and form and the databse is
split into back and front ends as we have four users accessing the database.
My problem is that one member of our team resides in a different city and I
need her to have a copy of the database to enter and edit data in and then
return to me so that her data can be imported into the database at our end.

I know that it is not possible to email a form on its own from what I have
read here already. I would appreciate any suggestions of how this can work!!

Thanks.
Click to expand...

FWIW, we have had similar situation and we simply set up a system where the
remote user can dial in and use the front end situated in our offices. We
set up a VPN and used the standard MS NetMeeting shipped with Win2000/XP.
Very simple to do and eliminated needing anything special done to the
application, i.e. it was as if that user was in our offices as per normal.

If it is possible to set up a network that the remote user can access and
"see" the backend database then in most situations this will be even easier,
you can install the front end on the remote user's machine and just need to
(re)connect the tables to the back end. There may be performance issues
depending on the network and how often they need to access the backend
portion of things (ie use the back end data tables) however, but if you have
a good network then this may not be a problem.

This may help.

Regards
A
 
A

Albert D.Kallal

You can email the data part, and hte application part to the user.

However, that end user will have to have ms-access setup. And, after the
person enters data, you will have to come up with a way to get that data
back into your production system. If you only got one simple table, then
when the user is done, they can email you back the data part.
However, if your application has "many" tables, then importing the data can
become quite complex.

So, you could/might consider replication...

Another possible solution is to have the remote user "connect" to a central
system, and then use that....

I talk about using ms-access in a remote situation here:
http://www.members.shaw.ca/AlbertKallal//Wan/Wans.html

Which of the above approaches suits you will depend on your situation, and
how the "remote" user needs to enter the data.
 
Top