🚀 go-pugleaf

It does'nt really matter what LAN system you are using (we use Banyan
Vines), the trick is to separate your database into two.  One database
holds just the tables and data.  This is the database that you install
permanently on the network and is known as the backend database.  The other
database holds all the forms, queries, reports etc and is known as the
front end database. A copy of the front end database can reside on either
the network drive or on any work station hard drive.  You attach the back
end tables to the front end database and bob's your uncle you can have 20
people accessing the same data tables from their work stations with the
front end database installed on the work station hard drive.

The beauty of this system is that the corporate data resides on the network
and you can continue to develop your application from your own work station
or home computer.  When you install an upgrade of you application, always
ensure that the attachment paths are correct.  Also ensure that when you
open the backend database for the first time you disable the exclusive
access check box.  I would only use replication for out of office use not
the other way around.  The main database should always reside on the office
network. 

Hope this helps.

David Wresinski <david@catterton.com> wrote in article
<683rbb$lr6$1@gte2.gte.net>...
> I have developed a rather large database that can be used in my job.
> The company I work for uses a Novell LAN. I have no experience in
> LAN/WAN.
> 
> The problem...The company can now see the benefit of my program and
> wants to put it on the server so other office personnel can use it.
> Since I would want to keep the Design Master on my desktop at home,
> could I just:
> 
> 1. Using Replication Manager, create the Design Master and Replica,
> and upload the Replica to the server, then install Office 97 DE Tools
> on the server, then create addtional replica's from the copy on the
> server.
> 
> 2. Would I be able to syncronize from the Design Master at home to the
> Replica on the server at work thru the internet?
> 
> 3. How involved would this get? Is there a sequence of steps somewhere
> that one could follow. Online Help talks about Replication under MS
> SQL Server and Windows NT but the office uses Novell.
> 
> 4. Would the office need to bring in a contract LAN/WAN guy. 
>