iheartvba
171 New Member
Hi,
I already have 3 Databases running:
A. they all have the same tables and the same structure
B. There is no 1 Master table they are all separate tables
What I want to do is to merge them into 1 Master Table to be able to generate reports etc. An append query will not suffice because some fields get updated in the orginial databases.
I have looked into database replication and I think it would work. I have considered the following method:
1. Merge all Data into 1 table
2. create 3 replica's
Issue with this method:
1. Each Database will be populated with data from 2 other databases which is not needed.
Is there a way to resolve this, because if I delete the data from the 2 other tables, wouldn't the replication wizard want to delete that data from the Master aswell?
Best Regards
Sep 29 '08
Subscribe Reply
30 2956 
- <
- 1
- 2
- 3
- 4
- >
iheartvba 171 New Member
I've just reread post #16 and it seems you may want to update the remote databases too. If so, this is a far more complicated problem. Is this the case?
Yes thats right, I also need to update the remote databases but even if I can just get the remote office data to the Main office that would be sufficient, it's not essential for me to update the remote databases, I can do that manually.
I still don't understand, how would I go about doing this. Shouldn't I just be able to connect to a VPN, there by creating a Wide Area Interoffice network and connect the main office front end to both the remote office back ends. Please excuse me if I am repeating the same question but I am still genuinley utterly confused.
Oct 11 '08 #21
NeoPa 32,569 Recognized Expert Moderator MVP
If you have a working VPN available, then yes. This is perfectly true.
Unfortunately, there is a world of problems (Networking not Access problems) in setting up a VPN safely. I would never personally recommend anyone just try it out for themselves. Maybe there are other networking experts who may feel comfortable with that, but I don't. It's too easy to leave a link into your actual private network accessible by third parties.
What position are you in exactly relative to VPNs in your organisation?
Oct 11 '08 #22
NeoPa 32,569 Recognized Expert Moderator MVP
Yes that's right, I also need to update the remote databases but even if I can just get the remote office data to the Main office that would be sufficient, it's not essential for me to update the remote databases, I can do that manually.
With a VPN, both way transfers are possible (feasible even).
Without it, external transfers (of whatever variety) will be necessary. The reporting is relatively straightforward . Updating the remote DBs is a little more complex. Possible, but more fiddly.
Oct 11 '08 #23
iheartvba 171 New Member
With a VPN, both way transfers are possible (feasible even).Without it, external transfers (of whatever variety) will be necessary. The reporting is relatively straightforward . Updating the remote DBs is a little more complex. Possible, but more fiddly.
What I currently do is this:
I generate the required information from the data available in the remote office, that information (query) is then exported to a text file. The text file is manually e-mailed to head office. Then someone at head office downloads the report from their e-mail and imports it into their database. This works fine but it isn't foolproof, if I am just contemplating whether to invest time in making it foolproof, or whether there is a more sensible way of doing what I was trying to do. So if you have any suggetions please provide them
Your Help is Much Appreciated
Oct 12 '08 #24
NeoPa 32,569 Recognized Expert Moderator MVP
What position are you in exactly relative to VPNs in your organisation?
That depends fundamentally on your answer to the question above (from post #22).
Oct 12 '08 #25
iheartvba 171 New Member
Sorry I just realised I didn't answer that question.
I use Windows XP Professional VPN. We are a small accounting firm and do not have servers in any office, we have peer-to-peer networks in all offices. So all I have done so far is setup the Windows VPN connection in all of our offices, then connected those VPN's, a VPN network connected icon came up near where the clock is on the right hand side of the windows toolbar, showing there is a connection, but I am stuck after that. I thought the computers on the remote office LAN would just show up in my network places.
Just as a note the DNS server Address for the head office and remote office is different so could be that is the problem.
Oct 12 '08 #26
NeoPa 32,569 Recognized Expert Moderator MVP
The DNS thing certainly won't help.
This is a networking issue then.
It's good news you have a VPN, but you need to be able to browse to the other offices (at least access them across the network) otherwise it is no help.
Oct 12 '08 #27
iheartvba 171 New Member
I will have to dig up some time to play around with this, because i would need to change the DNS server for the main office. Would you be able to refer me to a good forum where I can get more info about accessing remote office computers using windows VPN?
Thanks alot for your help
Oct 13 '08 #28
NeoPa 32,569 Recognized Expert Moderator MVP
Have you tried either of our Windows or Networking forums?
Oct 14 '08 #29
iheartvba 171 New Member
Just to update, yes I have tried the networking forum, I have continued this question on:
http://bytes.com/answers/networking/...opeer-networks
Nov 24 '08 #30
- <
- 1
- 2
- 3
- 4
- >
This thread has been closed and replies have been disabled. Please start a new discussion.
Similar topics
| 2 2780 Help needed for Database Replication by: Anshul Seth |last post by: Hi All, I am currently handling a J2EE application with the Application server as Weblogic 7.0 SP2 and Database on Oracle 9.2.1.0. The client wants to setup a test environment, and as the application is mission-critical, it would be of great help if the production and test DB are in sync in real-time. Can any one of you please guide me on this issue? Oracle Database |
| 557 Replication and mysqdump issue with database name by: Jon |last post by: I have a database called abc-100 which seems to cause problems with replication and importing sql files created with mysqldump. First, if on the master we create a temporary table (because we don't have subselects yet) it causes the slave to die with the following. Relay log says: DROP /*!40005 TEMPORARY */ TABLE abc-100.temp_summary MySQL Database |
| 1 1902 How to automatically replicate remote database which is not permanently online by: Uli |last post by: Dear group, I have to replicate remote data to a SQL Server in the headquarter. The data are on a site which does not have permanent online-connection to the headquarter. I have written a script which replicates the data and i want to set up a process / batch on the headquarter-machine which roughly does the following Microsoft SQL Server |
| 5 1952 database syncing by: Ken Massey |last post by: First let me say I'm not interested in replication. I want to sync a target database with a source database at regular intervals (say weekly), but in the intermediate time they may differ. The sync process should essentially "make the remote copy of this database look exactly like the local copy". I have seen some tools online that claim to do something like this, but I was wondering if there are any free tools, or other clever... MySQL Database |
| 1 1830 Database Replication A97 vs A2003 by: Andrew Chanter |last post by: I developed 3 different replicated database applications in MS Access for 3 different corporate clients in Access 97 several years ago to enable data to be shared across wide area networks. I observed 2 issues that plagued all 3 systems. 1. the database files continually became corrupt during synchronization. Most times this was easily fixed via a repair and compact, but the frequency with which this occurred was of concern, and... Microsoft Access / VBA |
| 1 2250 Synchronizing with a non-replicated database is not allowed. The <name> database is not a Design Master or replica by: MAILTONRK |last post by: Hi, I am a Mainframe guy. I am working with MS access(maintaining a application) for the last 2 weeks. I had one master database and four replicas. One of my replica had trouble in synchronization(It said, database is in use..). After searching google, I ran "Compact and repair" utlity against my replica. It looks like, it has changed the attribute of my replica. Microsoft Access / VBA |
| 18 2702 Remote Database Access by: Asif |last post by: Hi all, I am working on portal which is using MS Access 2003 database. The problem that I am facing is that once I received data from vendors I have to upload whole Access Database file to server. Initially it is not an issue but after increasing the size of database file(nearly to 50 MB) it is now difficult to upload such file on server. Microsoft Access / VBA |
| 3 6911 Multi-user, offline use for Access database by: Alex |last post by: Hello, I am running an Access 2003 database, quite modest in size, that is used by upwards of 5 users. I need to modify the database such that these users can work simultaneously and, in some cases, offline. It is split to front and back ends and works over Citrix. So the multi-user is working fine. Microsoft Access / VBA |
| 2 4237 Replication issues after a Database Restore - Unable to drop or create Transactional Replication by: Query Builder |last post by: Hi, I have transactional replication set up on on of our MS SQL 2000 (SP4) Std Edition database server Because of an unfortunate scenario, I had to restore one of the publication databases. I scripted the replication module and dropped the publication first. Then did a full restore. When I try to set up the replication thru the script, it created the Microsoft SQL Server |
| 8674
What is ONU? by: marktang |last post by: ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, well explore What is ONU, What Is Router, ONU & Routers main usage, and What is the difference between ONU and Router. Lets take a closer look ! Part I. Meaning of... General |
| 8603 Changing the language in Windows 10 by: Hystou |last post by: Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,... Windows Server |
| 1 8893 The easy way to turn off automatic updates for Windows 10/11 by: Hystou |last post by: Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,... Windows Server |
| 1 6518
Access Europe - Using VBA to create a class based on a table - Wed 1 May by: isladogs |last post by: The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will... Microsoft Access / VBA |
| 5860 Couldnt get equations in html when convert word .docx file to html file in C#. by: conductexam |last post by: I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();... C# / C Sharp |
| 4366 Trying to create a lan-to-lan vpn between two differents networks by: TSSRALBI |last post by: Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls... Networking - Hardware / Configuration |
| 1 3045 transfer the data from one system to another through ip address by: 6302768590 |last post by: Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system C# / C Sharp |
| 2 2327
How to add payments to a PHP MySQL app. by: muto222 |last post by: How can i add a mobile payment intergratation into php mysql website. PHP |
| 3 1999
Comprehensive Guide to Website Development in Toronto: Expert Insights from BSMN Consultancy by: bsmnconsultancy |last post by: In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive... General |
