Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   I have read and read... now a couple of questions OK. I have read and read and read this newsgroup and various related documents. I still have some confusion. 1) Is it recommended to do direct syncs over a LAN between laptop versions of replicated database? I seem to get conflicting advice in this newsgroup. some seem to suggest NEVER doing direct replication; others say to do DIRECT on a LAN connection. 2) Should laptops with a rep... 3 21.08.2006 03:57:49 Entered data in copy of master instead of replication Hi, maybe someone has an idea how to resolve tis problem: My client has field staff who do data collection. They enter their data into Access database replications. Once a week they e-mail their replication to the project manager. He synchronises the databases with his master and sends them back for further data collection. (I know there are other options to achieve this, but that is n... 3 20.08.2006 17:07:55 Need replication setup info I am starting to experiement with replication for ultimate installation at a nonprofit. Ultimately they will have 25 or so laptops with replicated back end database. I would guess that the database will be about 100 meg - without replication overhead. They will sync approx once a week - via 10 mbps LAN connection when the return to the office. Each replica will likely be a full replica. ... 4 20.08.2006 01:21:47 Briefcase replication Hi, i dont know much about replication but i was looking at how briefcase worked. i understand how to do it between a main computer and a laptop using a usb flash drive. what i would like to know is how, if possible, can you make a replica from the flash drive onto, say another computer or 2. The idea being if you go to different work places and have the program/files on other computers... 4 20.08.2006 01:04:30 Cannot create Design Master I'm trying to create a design master for a replica. I went to Tools/Replication/Create Replica... I received a message "Microsoft Access can't convert the database to a Design Master. Cannot make ProjectAction object in the Tables Container replicable". The help with the message suggested the table may have a large number of fields. Since the replication process creates a few new ... 2 17.08.2006 20:32:23 Migrating a replicated database to SQL server I have a MSAccess 2000 database which has been running with replication since inception about 7 years ago. It has been syncing with very few problems but I am concerned that the size and importance of this database makes it critical to the company. The dataset has about 50 tables linked with refferential integrity. the size of a compacted dataset is about 400MB's. There are 12 local user... 6 16.08.2006 13:16:41 MDB crashed when sychronising Hi, I had a corrupt record in one of my replica sets which I have removed by creating a new replica from the desing master and using append an append query to update all the amended records which would normally be done via synchronising. The design master did attempt to synchronise prior to me doing this and now when I try to synchronise with another replica it gets about 90% of the way ... 4 15.08.2006 20:41:44 Replication on Web Server Lets say I set up a web form to submit data to an MS Access database. That information is set to populate a table in the database. Is it possible for that table or database to automatically replicate itself on the web server. My goal would be for the original data that was submitted to stay intact somewhere while still being able to edit a version of the data. So....I guess it would be so... 2 14.08.2006 03:19:19 Corruption on re-replicating a db We've just run TSI unreplicator, which eliminated 90% of the size of a back end db. The unreplicated version ran really well. On re-replicating the db, one form cannot have its datasource updated without crashing the application. This does not happen following unreplication, only after subsequent re-replication. Does this suggest what might be the cause? Nick ... 5 12.08.2006 16:28:35 Rebuilding a replicated database Our current app replicated back end is a bit bloated. My idea is to unreplicate it using an utility and then import all into a new db. After unreplicating, is it better to... 1. In a new db, create empty tables that matching old table formatting, and then somehow pull the content from old tables to equivalent new tables. or 2. Just import entire tables as they are. (I tried a t... 13 08.08.2006 22:56:53 How to Manage a Replica on ReplMan thru program (Automate) Hi There! I have been looking for a solution to Manage a Hub Replica on ReplMan thru VBScript on ASP page. I have code that Make a DesignMaster replicable and create a replica (Hub) and place it on the Web Server. I then manully open the Hub Replica on the ReplMan to Manage and make Internet Aware. While I open the Hub replica on the ReplMan, it prompt saying "This Replica is not ma... 2 08.08.2006 19:45:42 Remove Defunct Replica: Any way to automate? We have a utility that creates, partial, filtered replicas. We have to go into Replman and remove them manually but would like to automate this process. How does Replman remove them? What table(s) in the full replica that the partial replica was created from are impacted? Thanks in advance, RB ... 2 04.08.2006 19:36:36 retention/expired replica HI All This has probably been asked a million times but I can't find any archives with ansers so please be patient on that. I have a replica that has expired. Need to get the new data out of it. Is it possible to recover/re-activate the database at all? I have coverted it to a design master but it won;t synch with the previous deisgn master - no common point to start the synchronisat... 5 04.08.2006 19:33:18 sync of 2 backends in different locations I have a split DB with the FE residing on user's desktops and linking to the BE located on a server. The FE shortcut targets a specific security workgroup file located in the same place as the BE. So far this has remained fairly local, geographically and therefore server connection speed has not been an issue at all. Now.. The database is being migrated to a national server (located offs... 4 04.08.2006 19:32:14 Determine which records have been modified before synchronization I have inherited a database that was converted to use replication. The original database was split into a UI database (forms, reports only) and a database containing data (replica). The UI links to a replica on users workstations. The system works well and replication has been a great success. We do not want to modify the existing UI (forms) because all works well. How can I acco... 3 04.08.2006 01:50:48 Adding a Table and modifying a relationship I have a database with two tables, linked via a key field. The tables have a relationship established with referential integrity. The tables contain data. I need to add an additional table (TableC) that links to TableA & TableB, using referential integrity, and I will also need to update the Relationship. Tables A & B have the same number of records. I do not need the new TableC ... 3 03.08.2006 21:59:49 Internal internet failure (Internet replication) Recently I had a post concerning, if Replication manager synchronizer, could handles different replicaset at the same time.(Answer was yes) So now the Synchronizser handles database "Alfa" and "Bravo"secured with two different workgroup files: "Alfa" serves about 15 clients replicating 20-30 times daily.(Most clients uses Access 2000, and a few 2003 as BE) Have bee working for 3 years ... 8 03.08.2006 20:02:46 Partner replica is exclusively locked cannot apply changes This is an error message I get terminating the internet replication exchange. I can see the lock file open in the folder and I am prevented from deleting it if I try. I have set Access to open the database in shared mode as opposed to exclusive mode. What can be wrong. I used to successfully sychronize this same backend replicated database over the internet in the past. And the exchange ... 2 02.08.2006 18:34:43 LAN Replication I have been reading and trying some code I have found here by David. Private Sub btnSynchronize_Click() Dim dbSource As DAO.Database Dim strDestinationMDB As String MsgBox "Make sure you are connected to the network. Press 'Ok' when ready.", vbOKOnly, "Synchronization" Set dbSource = DBEngine.OpenDatabase("C:\GasOpsDB\database\Replica of customer_be.mdb") dbSource.Synchroniz... 4 01.08.2006 01:38:05 Subject: Replica fails to synchronize, Search key not found, 3709 I've got an Access 2000 format database that has been working well for several years. It's been replicated to two other users. Today I tried to synchronize the Master to one Replica and got this message: "The search key was not found in any record." Supposedly, this is error 3709. When I looked it up in MSKB, it said it maybe caused by an indexed Memo field. However, that's not the cas... 8 26.07.2006 15:19:20 How to make a replica not a replica Hi, Anyone know how to do this? Short of manually editing every database object to make it not replicable? I have inherited a database that was using replication for no reason, a simple split design with the back end on a file server will work fine. So I want retain all the objects, but get rid of replication fields in tables, and hopefully whatever indexing and path info was being used... 4 26.07.2006 00:30:03 syncronization failure Hi, I am trying to syncronize two replicas, but it cannot be completed because of the error shown below. I use direct syncronization with all database objects (tables, queries, and forms). Access 2003 version "The field is too small to accept the amount of data you attempted to add. Try inserting or pasting less data. (Error 3163)" thanks in advance karakas ... 5 25.07.2006 16:55:02 New to Replication - Need Help Hi, I have recently started a new job and 'inherited' a replicated database with which there are problems. I am totally new to replication and have been trying to access the folowing for an overview: http://support.microsoft.com/support/access/content/repl/replication.asp http://support.microsoft.com/support/access/content/repl/replfaq.asp I found the links on a reputable site but the ... 15 24.07.2006 21:00:12 Conflict viewer I have conflicts generated when I sync with one of my replicase. When I answer "yes" to resolve conflicts, nothing happens. Any suggestions would be appreciated... 2 21.07.2006 20:57:57 Indirect Replication need Is there a document, or guidance on how to set up Indirect Replication? I have a VPN connection and need to use Indirect Replication but am struggling on how to start this. Regards, ... 4 19.07.2006 23:52:04 9 Pages: 1  2  3  4  5  6  7  8  9