Hi.
Access 2007.
Back-end is in server. Front-end is located in a laptop. When laptop is
outside the office it is not possible to work with FE database. Is there a
way to work offline. Thanks a lot.
Not directly. If you do not have any connection to the database
containing the tables, it's more than a bit difficult to work with
those tables!
One possibility is to drastically change your database architecture,
in one of two ways. One would be to use Windows Terminal Server or
Citrix so that the laptop user logs on (over the internet) to your
network, and runs the database *on a network attached server*; they
would not need Access or the database installed on the laptop at all,
it's just being used as a remote terminal.
The other is to use Replication: the host machine and the laptop would
each have the entire database, and you would use replication to
resynchronize them when the laptop is connected to the network. This
is a complex technique and needs to be done right if you do it at
all... get the Replication Whitepaper from
http://support.microsoft.com and study it carefully.
John W. Vinson [MVP]
