473,800 Members | 2,367 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Database synchronize

Hello,

I need to synchronize one access database with other access database. Tables
and fields are off course same.
Can someone tell me how to achieve this?

Regards
Jan 30 '07 #1
1 3393
"John" <jo*****@hotmai l.comwrote in
news:ep******** **@ss408.t-com.hr:
I need to synchronize one access database with other access
database. Tables and fields are off course same.
Can someone tell me how to achieve this?
Um, are the databases already replicated? If not, then you'll have
to manually run update/insert/delete queries to combine the data in
the two databases. This is not a trivial undertaking!

Once they have the same data in them, you should consider a way to
avoid having to do that again. The best solution is to host the app
on a Windows Terminal Server so that all users update the same
database. If that's not feasible, you should consider Jet
Replication, but it has limitations on the environments in which it
is appropriate.

--
David W. Fenton http://www.dfenton.com/
usenet at dfenton dot com http://www.dfenton.com/DFA/
Jan 30 '07 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

6
3137
by: Sarah Tanembaum | last post by:
I was wondering if it is possible to create a secure database system using RDBMS(MySQL, Oracle, SQL*Server, PostgreSQL etc) and web scripting/programming language(Perl, PHP, Ruby, Java, ASP, etc) combination? I have the following in mind: I wanted to store all my( and my brothers and sisters) important document information such as birth certificate, SSN, passport number, travel documents, insurance(car, home, etc) document, and other...
1
7993
by: Bie | last post by:
Hello, Have any of you ever controlled MS Access Replication from a VB application? I have a VB6 application where I have to send copies of the underlying MS Access 2000 database in remote areas (no LAN or Internet connections), then get the databases back and synchronize them. Any suggestions, articles, etc. would be greatly appreciated.
4
3514
by: Sam | last post by:
Hello everyone, I have around 20 reports in an ASP web-application which connects to a SQL Server 2000 dB, executes stored procedures based on input parameters and returns the data in a nice tabular format. The data which is used in these reports actually originates from a 3rd party accounting application called Exchequer. I have written a VB application (I call it the extractor) which extracts data from Exchequer and dumps the same...
5
1997
by: tom | last post by:
I have a local Excel spreadsheet I am potentially migrating to MS Access. The thought was to use Access on the workstation for data-entry and subsequent generation of mailing labels and other simple reports. I also want to gather data from an internet webform--potentially, the data will be entered into a MySQL database. What is the best method to combine these two endeavors? That is: how can I have workstation access to the database for...
1
2717
by: taleran58 | last post by:
Hi all. I'm writting a multithreading program that will update a loacal Access database. I'm using OleDB connection to get access to the database from each thread and my question is: how do I synchronize between threads\ how do I lock the database so no clashes between threads occurs. do I have to use a diffrent connection\adapters???
1
3215
by: taleran58 | last post by:
Hi all. I'm writting a multithreading program that will update a loacal Access database. I'm using OleDB connection to get access to the database from each thread and my question is: how do I synchronize between threads\ how do I lock the database so no clashes between threads occurs. do I have to use a diffrent connection\adapters???
3
2562
by: Elioth | last post by:
Hi, I want to synchronize Access and SQL database schema. I have running a application and I want sync database because when I create a new Table in the database I need this table in all client database. At this moment I create a Table manually in each database client. Thanks for all help. Elioth
1
4960
by: Elioth | last post by:
Hi, I want to synchronize database SQL to SQL or Access to Access in vb.net. I need to know how to synchronize the tables schema with a Master Database and after synchronize the data in the tables in vb.net . Thanks for all help. Elioth
1
3982
by: vicky12 | last post by:
HI all can anyone help me with this. I have two databases, one at my local host and second one on a web server with same tables. I have to make some changes to my local database and I need to update all those changes to the on line database. A table can take thousands of records even millions. Suppose there are 50,000 records in a table and I add two more records to my local database. Now I have to update these changes to the other database....
0
9551
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,...
0
10276
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10253
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,...
0
10035
tracyyun
by: tracyyun | last post by:
Dear forum friends, With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each protocol has its own unique characteristics and advantages, but as a user who is planning to build a smart home system, I am a bit confused by the choice of these technologies. I'm particularly interested in Zigbee because I've heard it does some...
0
9090
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
1
7580
isladogs
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...
0
5606
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4149
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
3
2945
bsmnconsultancy
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...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.