C
Chip
Hi All...
First, thank you again for all your help. I continue to develop my
projects with information I get to from this board on almost a daily
basis.
What is the best way for me to deploy a database to users who will be
using it both on and off site. I'm structured like this. I have the
back end, consisting of my tables located on a server. Some of the
tables are populated with information recieved from a ShraePoint
site. Some of the tables are traditional data tables. In our office,
within our network, things work beautifully.
However, this is an education database. We adminster a state
certification program, and routinely go to Training Facility to give
and administer certificaiton exams. Right now we track educator and
training site performance, but we need to drill down another layer.
We need to start track individual student performance, so I can start
gleaning information like how well students perform grouped by age
group, instructor, training facility, etc. So each Class is an entry
in my database. Each class has multiple students in it.
Without getting into too much detail about what I plan on including,
what I need to know is how to make my database functional off site.
We have access to our network via VPN and tethered BlackBerries but
working on a share database via a WAN isnt the most robust solution.
So how can I get the database to work off campus? Is there a way of
taking the database off the hook if you will, and then when the
employee returns to the office, have the database synchronize with the
data that the employee put into the database when they were in the
field?
I want to put it all in one database rather than split it up. But I
was thinking a new database with linked tables is the better optoin.
Chip Franklin
First, thank you again for all your help. I continue to develop my
projects with information I get to from this board on almost a daily
basis.
What is the best way for me to deploy a database to users who will be
using it both on and off site. I'm structured like this. I have the
back end, consisting of my tables located on a server. Some of the
tables are populated with information recieved from a ShraePoint
site. Some of the tables are traditional data tables. In our office,
within our network, things work beautifully.
However, this is an education database. We adminster a state
certification program, and routinely go to Training Facility to give
and administer certificaiton exams. Right now we track educator and
training site performance, but we need to drill down another layer.
We need to start track individual student performance, so I can start
gleaning information like how well students perform grouped by age
group, instructor, training facility, etc. So each Class is an entry
in my database. Each class has multiple students in it.
Without getting into too much detail about what I plan on including,
what I need to know is how to make my database functional off site.
We have access to our network via VPN and tethered BlackBerries but
working on a share database via a WAN isnt the most robust solution.
So how can I get the database to work off campus? Is there a way of
taking the database off the hook if you will, and then when the
employee returns to the office, have the database synchronize with the
data that the employee put into the database when they were in the
field?
I want to put it all in one database rather than split it up. But I
was thinking a new database with linked tables is the better optoin.
Chip Franklin