Partially Disconnected Databases

I'm hoping to get a little advice.

I currently have a repository db that is located on a server. There
are a number of client databases that have their own interfaces (forms,
reports, queries) but use the repository db for storing data.

There is a new requirement for some users to be able to upload limited
and specific information to a laptop (or tablet), take it into a remote
(ie disconnected) environment, and update the information. On
returning to the office (and connecting to the network, either wireless
or with a network cable), the users need to be able to update the
repository db with the information they have entered in the remote
environment.

I've been instructed that Access is what the application MUST use.

So this is what I'm thinking of doing:

Each laptop would have a small db of its own. This would contain the
information the user requires in the field.

There would be 2 different Access applications on the laptop.

One would work with the data on the laptop and allow them to update the
information as required. This would not require a link to the
repository db.

The second application would use linked tables from the repository db
to "synch" the data. This would be a manually initiated process but
that's ok. This would involve queries to determine what data needed to
be updated back to the repository and what new data would be pulled
from it.

I've looked into replication but the addition of GUIDs and the
limitations imposed on the auto-number fields would make it a less than
desireable option.

Any advice?

.

Relevant Pages

  • Re: Why SVN?
    ... connection all my changes will show up as one big lump. ... functional repository with "commits" as I need ... network, I use SVN, because it fits the environment better. ... working from a laptop most of the day, ...
    (comp.lang.ruby)
  • Re: Partially Disconnected Databases
    ... to real connections. ... I currently have a repository db that is located on a server. ... queries) but use the repository db for storing data. ... Each laptop would have a small db of its own. ...
    (comp.databases.ms-access)
  • Re: Partially Disconnected Databases
    ... I currently have a repository db that is located on a server. ... queries) but use the repository db for storing data. ... Each laptop would have a small db of its own. ... limitations imposed on the auto-number fields would make it a less than ...
    (comp.databases.ms-access)
  • Re: Offline updates on 10.3?
    ... using my home LAN? ... to a downloaded repository on my laptop, but I would imagine this is ... On a hunch, I'd say you could obviously pull all the patches, which should come as rpms. ...
    (alt.os.linux.suse)
  • How to create a USB flash software repository?
    ... Is there a tool that can create a software repository on a USB flash ... laptop which hasn't been connected to any network for years. ... have also failed to get a WIFI network connection running between the ... OpenSUSE install DVD. ...
    (alt.os.linux.suse)