Go Back   Access World Forums > Microsoft Access Discussion > General

Thread Tools Rate Thread Display Modes
Old 02-22-2011, 04:24 AM   #1
Newly Registered User
Join Date: Jul 2008
Posts: 279
Thanks: 2
Thanked 3 Times in 3 Posts
Chrisopia is on a distinguished road
Site to site network - what are my options?

My client has just told me that he would prefer the database I am working on to be able to be accessible from the 2 different branches.

At first I was going to create 2 completely separate databases with date fields so I knew which was new information so I could combine the databases for marketing, but he now wants me to create 1 MAIN back end database and have the front ends on the computers at 2 different locations.

The trouble is, one location has been there for 5 years longer than the other, and hence is 5,000 invoices extra in counting. My main issue is that they wont really combine unless I create a duplicate "invoice" table - one for either branch. Which could get messy.

My other concern is I am not very knowledgeable about the whole internet database options, as the 2 sites aren't linked via network already. I have heard of database servers but not actually sure what they are or what they do, and I fear the programming involved to link to those online servers.

I think this could get quite messy.

Chrisopia is offline   Reply With Quote
Old 02-22-2011, 07:25 AM   #2
boblarson's Avatar
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,818 Times in 1,575 Posts
boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold boblarson is a splendid one to behold
Re: Site to site network - what are my options?

The optimal is to use Terminal Services to do this. The user essentially logs in to a session AT the location the database is hosted at and therefore becomes a "local" user. This will keep speed issues to a minimum and will help avoid corruption. It also will avoid the problem in that a LAN is many times faster than the Internet connection. So, users who might connect using a frontend to the backend using a WAN would find the app running EXTREMELY slower.

To view links or images in signatures your post count must be 10 or greater. You currently have 0 posts.
boblarson is offline   Reply With Quote

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Site Nav tmb904 General 6 06-29-2010 09:21 AM
New to the site. Subcancel Introduce Yourself 4 04-21-2010 09:10 AM
New To Site Need Some Help virodriguez General 2 07-25-2005 12:51 PM
Site mission2java_78 General 2 01-20-2003 01:53 PM
site ID! andrewvranjes Queries 1 07-02-2002 03:08 AM

All times are GMT -8. The time now is 09:52 PM.

Microsoft Access Help
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post

Sponsored Links

Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World