Solved

Increasing Locations of Dbase Use VPN for regular backup to Master DB on Headoffice DBServer

Posted on 2004-09-08
13
236 Views
Last Modified: 2006-11-17
Experts, I have a current company DB (Access XP 2K {Front / Back} on Win XP / 2000 machines) The data is stored on an SBS2000 server. I am now wanting to expand the company network to include multiple geographical locations using 1.5/256 ADSL connection (VPN) to transfer current days data input to the Master DB. My database is based on records that span multple tables as much as total 250+ fields, is there a way to extract only the changes made to the branch DB since the last backup. I would like to automate the backup to happen throughout early morning for all Branches then automate the update of the master each morning. Your thoughts
0
Comment
Question by:citywide
  • 6
  • 4
  • 3
13 Comments
 
LVL 41

Expert Comment

by:shanesuebsahakarn
Comment Utility
1) Replication:
http://support.microsoft.com/default.aspx?scid=kb;en-us;282977&Product=acc

2) Terminal Services
Since you have an ADSL link, TS is a good option, to allow your users to work directly on the database. We have multiple users working on TS, and it works extremely well. This would involve changing your configuration to eliminate branch copies of the database and only have a single master DB.
0
 

Author Comment

by:citywide
Comment Utility
At present the Application side of the DB has all the code attached to use remote access does this need to go across to the server side. Is the terminal services access similar to using a VPN connection then loging into a workstation using something like TightVNC for remote access.
0
 
LVL 4

Expert Comment

by:Excalibur_Software
Comment Utility
Another option that is safer would be to convert your back end to either SQL server or MSDE.  How many users are going to be using your database?
How time sensitive is your data?
Both SQL server or MSDE have the ably to roll back transactions so you can recover your database faster and easier if one of your user lose connection while writing data to your database
Access 2000 can be destroyed by lose of connection while writing to the dB.

I would still use Terminal Service to connect to your database.

Thank you for your time
Al
0
 
LVL 4

Expert Comment

by:Excalibur_Software
Comment Utility
Here is a link you might want to read before you make up your mind
http://msdn.microsoft.com/chats/office/Office_100302.asp
0
 

Author Comment

by:citywide
Comment Utility
I'm Happy for the data to be stored locally and packed up and sent through the VPN Daily to the server so that the data i have on the master is no more then 24hrs old. I want this process to occur automatically after hours from the Branch. I will need to implement some type of branch numbering so or assign a unique ID on the server (ApplicationID). I am the only one that needs access to all data, each branch does need to see the other branches data. I will certainly use Terminal services / remote access for tech support etc... Does this sound like I am on the right track, If so what methods could i look into to extract daily data and send automatically through VPN then automate the upload to the master DB.

Thanks for the quick reply's GREAT STUFF...
0
 
LVL 4

Expert Comment

by:Excalibur_Software
Comment Utility
I think you are setting yourself up for some major headacks with data syn. issues
Example Branch 1 changes record 13
The same time branch 3 changes the same record
that night you update the data what will happen?
0
Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

 

Author Comment

by:citywide
Comment Utility
I am looking at the master to only view the branches data and extract the info i need, each branch works on its own work if I need to transfer an application between branches I will need to setup an export facility for that. I wont be changing data on the Master but I will need administor the DB be able to keep it clean etc....
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
Comment Utility
citywide,

Terminal Services is like using VNC. The performance across a DSL line is extremely good - we have a 2MB/512MB connection and we often have 6-7 simultaneous users without any problems. Of course, your server would need to be powerful enough to handle this.
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
Comment Utility
If you still prefer the synching method, have a look at the Replication FAQ that I posted a link to.
0
 
LVL 4

Expert Comment

by:Excalibur_Software
Comment Utility
I think what shanesuebsahakarn and I am both are saying that we have tried the database Replication method and have found out that it is not the best way to go. Even Microsoft says that it is possible but does not  recommended the Replication method. But if you still want to do the Replication method the first link I posted has some good information you should know. One other issue you may want to think about is when using Replication as you have described if you get a error on the first transfer you lose all data from all branch’s not just the data from the one with the error. The other method allows you to setup a script that can backup your database every few second so if you get an error you lose at most one transaction.
Here is a link to all the information telling you how to Replicate a Access database
http://office.microsoft.com/en-us/assistance/CH062526841033.aspx?TopLevelCat=CH790018001033
0
 
LVL 4

Accepted Solution

by:
Excalibur_Software earned 500 total points
Comment Utility
I hope we have been of help, if you need more help before closing down this question please let us know
Thank you
Al
0
 
LVL 41

Expert Comment

by:shanesuebsahakarn
Comment Utility
Al,

If a question has not had any comments for 21 days, it is classified as abandoned and will be handled by the cleanup process - you don't need to post comments in each of these questions. If you do, it means the cleanup volunteers will have to leave it for a further 21 days from the date of your comment before they can close it.
0
 
LVL 4

Expert Comment

by:Excalibur_Software
Comment Utility
Thank you Shane I just ask that question of the cleanup
0

Featured Post

What Security Threats Are You Missing?

Enhance your security with threat intelligence from the web. Get trending threat insights on hackers, exploits, and suspicious IP addresses delivered to your inbox with our free Cyber Daily.

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Describes a method of obtaining an object variable to an already running instance of Microsoft Access so that it can be controlled via automation.
As developers, we are not limited to the functions provided by the VBA language. In addition, we can call the functions that are part of the Windows operating system. These functions are part of the Windows API (Application Programming Interface). U…
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…

744 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now