Go Back   Access World Forums > Microsoft Access Discussion > General

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 02-22-2011, 04:24 AM   #1
Chrisopia
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
Smeghead
 
boblarson's Avatar
 
Join Date: Jan 2001
Location: Oregon, USA
Posts: 32,068
Thanks: 97
Thanked 1,811 Times in 1,573 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
Reply

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 02:44 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


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