Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   Synchronising two Access-Databases Hello, We develop dotNet applications. We normally use SQL Server as datastore, but now we have a small project on an existing Access Database. Our issue is that there are two copies of the db, one on a lan and one on a webserver (on the other side of the world). Our customer want's to have those two (identical) database synchronised bi-directional daily. How can this be done in acces... 12 29.09.2006 01:40:41 HTTP Error Hello: I have several replica sets with 10 replicas each one in a single machine working since 1999. Two weeks ago I got this error: "3677 Failure to execute the HTTP request to start the internet synchronizer or the internet server. Use Replication Manager to configure internet synchronizer on the internet server." I have restored a backup of the system, even I have config another... 6 28.09.2006 02:23:47 Would you implement a replicated database in this environment?? Would you implement a replicated Access database in this environment? I have a nonprofit client who would like to collect data on new clients and update data on existing clients via a laptop vs. the current paper method. They would plan to use 2-3 laptops with replicated database on each laptop. Only a single central office with the main copy of the replicated database. Of course the... 2 27.09.2006 21:35:35 Help please. Replication Manager won't start. Had a hard drive start to fail this weekend. It was getting a little sticky on startup, but once it started, it was fine. I got a new hard drive and proceeded to use the hard drive setup program to configure the new drive. The failing drive had two partitions C (OS) and D (replica database). The hard drive program did a sector by sector copy of the C partion. I did the transfer of ... 3 26.09.2006 08:43:45 Replicas exploding to 2GB Hi All, We have a problem where replicas in our replica set will start blowing up to 2GB. We do a compact/repair and they go down to their normal 200-300MB and then as they are used they are used and replicated they start growing again. We fight with this for a while rebuilding replicas and compacting and are able to make the problem eventually go away and then it comes back. We are doi... 4 21.09.2006 23:38:16 Synchronizing both Direct and Indirect Have a situation where the network works well for ~90% of users with DIRECT synchronization. Several other users will need to use INDIRECT synchronization due to their connectivity issues. Both of these user groups will access the same replica for synchronization. DIRECT synchronization works well. Any suggestions with combining this with INDIRECT synchronization? In addition, i... 2 19.09.2006 23:07:46 Is it possible to invoke replication from Front End ? We have an Access Database that a replica has been created by a developer that has left. There is different front end connected to the backend that is replicated with each other. We would like to know would it be possible add some codes so that end user not necessary to close the front end, open the backend and run synchronize. Can it be done at the Front End ? We are using Access ... 7 19.09.2006 13:07:20 Terminal Server Question I would appreciate any helpful comments on the following issues regarding hosting an Access application on Terminal Server. Is it still possible to use the following or do you have to install an email client and Word on the server: 1 DoCmd.SendObject to email 2 GetObject to mail-merge to Word Cheers Nigel -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe... 2 19.09.2006 13:04:47 briefcase replication I am in the process of doing a Briefcase replication as I have no experience with access. We are using Access 2000. I replicate the back end to the briefcase and leave the master alone. It seems to replicate fine. The problem is how do I get the forms to work. I take the laptop off the network and the forms open but I can't open the queries. It says disk error. I know I am getting this error ... 4 18.09.2006 21:27:00 Do this plan sound feasible? Hello all, First of all, I would like to thank everyone who has posted information of this (and other forums). It has been incredibly useful browsing the huge amount of information that people have posted, and I am incredibly appreciative of everyone who has contributed. I have a database which needs to run in 2 different offices (Jakarta and Banda Aceh - it's for an NGO working with the T... 4 18.09.2006 21:24:11 Cannot set the specified Registry parameter for the Synchronizer Hello, Does ANYONE have a clue what this error is about. I am trying to initiate an internet synch using an asp script on a web server that tells a replica on that server to synch back to a "URL'd" location. I can do this on a win2k server running ADO Version: 2.7 and DAO Version: 3.6 using JRO. When I try the same script on a server running win2k or win2k3 with ADO version 2.8 I... 7 15.09.2006 21:36:24 I need a copy of replman.exe I need a copy of replman.exe. Could someone please send me a copy? jason.sandlin@wymtnews.com Thnks Jason ... 3 14.09.2006 14:48:54 Conflict resolution window won't open Our developer just added a couple of new tables to the back end design master. This was done by copying the design master to an ftp site, which he subsequently downloaded, worked on and then re-uploaded to the ftp site. I then copied it back to the original folder. Unfortunately, he sent back a replica (for a yet unknown reason) instead of a design master. I initially missed that. W... 3 13.09.2006 03:58:22 Partner replica is exclusively locked; could not apply changes I have a number of remote sites (12) performing internet replication quite sucessfully. However one of them has come up with the above message. "Partner replica is exclusively locked; could not apply changes" They are using Windows XP sp2 - Microsoft Access Jet 4.0 and replication Manager 4.0. The IIS Server is a Windows 2000 server. Does it refer to permission on the IIS server?? Re... 2 13.09.2006 01:09:36 Replication Documentation Could anyone suggest any articles on the steps involved in creating a replica. I mainly need to have a way for laptop user to sync data to a database on the network. I read many postings and help files but have not found basic instructions on how to perform replication. When I tried to create a replica in Access 2000, I received a message "Microsoft cannot start SQL Dialogues, this feat... 2 13.09.2006 01:06:40 How can I automatically back up the database I have a few nightly routines that update the database....What I want to do, is have a process make a copy of the database BEFORE the nightly routines begin.....incase there is something very wrong. Can some one shed some light here? Thanks -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/Forums.aspx/access-replication/200609/1 ... 2 06.09.2006 18:57:56 Replman - Managing multiple sets of application databases I have three groups of application databases to manage, Set1, Set2, and Set3. Set1 contains 35 databases, Set2 has 5 databases, and Set 3 has 15 databases. These are three distinct, unrelated database applications I hope to implement replication with. I have been able to set up replman to manage what I call Set1 and this works fine. I do not seem to be able to create another Set of... 13 04.09.2006 20:40:29 How to stop database replication Client has an Access 2000 database that is a replica. We are unable to locate the original database it is linked to. The replica was created about 1 1/2 years ago and has not actually been replicated for a very long time. Now she is getting a message: "This member of the replica set will expire in 3 days because it hasn't been synchronized with another member of the replica set. If the member... 2 01.09.2006 18:48:27 Converting back end to Replica slows front end form load times Hi All, After converting the back end of a split database to a replicated set, the data entry forms in the front end take 20+ seconds to load. Back end is around 120MB. Back end and front end are located in the same folder on my C drive. Synchronizer is not running during my tests. Linking the front end tables to a copy of the unreplicated back end in the same folder gives fast (... 2 31.08.2006 06:46:49 General questions It's probably already out there but I can't see where anyone asks: 1. Does the synchronization process matter in what order you do it? Seems like depending upon the order, I've lost my Master Design. I've become quite the expert at recreating it but I'm tired of doing so. 2. Why, once I have synchronized replicas with the Master design and made new replicas for the users, are their... 5 31.08.2006 01:59:02 AutoNumber - Replicated tables With several replicated tables having a primary key named Rec_ID, that is a Random Autonumber, will the same number be used in different tables? Regards. ... 2 30.08.2006 15:31:42 More Replication questions I have read the Chapman/Kaplan article, the MSDN article Database Replication in Microsoft Jet 4.0 and various postings about replication. Still a few [more] questions. I have the TSI synch object installed and working with the MDB applet that I downloaded from Kaplan's site. I also have replman installed and working. My planned implementation ------------------------- My targe... 2 29.08.2006 20:36:45 Missing DLL when Creating Replica All our users are on Windows 2000 and the Access database is using Access 2000. Now we have a newbie and he is on Windows XP but still using Access 2000. When I attempted to put him on the database by Creating a Replica on his PC the error comes up saying he does not have MSRCLR40.DLL. The hardware guys installed it from the microsoft site but can't figure out why it complains about it ... 2 29.08.2006 20:17:31 Need copy of replman.exe Would someone sent me a copy of replman.exe please. Bobalston9 AT yahoo dot com thanks. ... 3 29.08.2006 20:16:03 Replication Manager install/setup office 2003 Is there a setup program in MSDN, 2003 and after? I can not find the 2000 install CD's. Thank you. ... 2 24.08.2006 00:11:07 9 Pages: 1  2  3  4  5  6  7  8  9