Threads Replies Last Post 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12   Pocket Access sync problems with pc replica Hi there, I want to be able to use some software to synchronize a MS Access database between a pc and several Pocket PC PDA's. Each PDA will have a replica of the database on it. I have wrote a front end for the database on the pc and on the PDA's ( each PDA is running windows mobile 2003) What I need is sync software that will sync all the changes on either device (the pc and the p... 7 1/6/2006 3:19:31 AM cannot create design master HI All I am new to replication but have been using access and VBA for many years. I have an access application with a split front end (distributed as an MDE) and back end architecture using access 2000. The users wish to take advantage of replication. I have obtained TSI tools and JRO examples from the access 2000 developers hand book by Litwin & Getz. Using these I have started to bui... 13 1/2/2006 7:32:39 PM FE/BE Replication Question Hello all, My client has an old Access application where all objects including tables are in one database. They are also using replication whereas they have a design master on the server and several locations have partial replicas which are stored on the server, all clients are thin clients. They also are using user level security. That all works fine. Now, I have re-written the app... 11 1/1/2006 12:48:36 AM Database is open after synchronization After performing indirect synchronization using TSI Synchronization object I'm unable to compact and repair the database because it appears to be open by other users. At least there is an ldb file in its directory which won't go away without closing the front end database first. I don't have any recordsets open or any forms which would cause this. It only happens after I synchronize. Does ... 10 12/26/2005 8:01:08 PM Synchronising/replicating access with sql server Hi Is there a way to synchronise/replicate an access db with sql server 2000 db, short of writing the code oneself? Thanks Regards ... 2 12/25/2005 7:46:37 PM how is the GUID generated in the "Replication ID" column in ACCESS? The GUID in that column does not look like a valid GUID. I had values like : {797F0000-0938-797F-64B3-F50AE0E11D00} and {658F0000-0958-658F-B4B9-F50AE0E11D00} and according to this site : http://www.famkruithof.net/guid-uuid-make.html , in a valid UUID the first number in the third part must be between 1 to 5.. ( here I have 6 and 7 ) . So how does ACCESS generate those GUID?? Thanks... 3 12/14/2005 11:20:09 PM Error 3197 - How to identify Memo field Hello, since today I have one replica which can't replicate because of the error 3197 "The Microsoft Jet database engine stopped the process because you and another user are attempting to change the same data at the same time." Searching in this Newsgroup I've found informations that a corrupt memo field shall be the reason. In one older message I've found the advice to check the table ... 3 12/16/2005 8:50:56 PM Replication 4.0 manager problem My setup works with indirect internet replication for more than a year almost without problems, but today clients starts reporting : 'Failure to write to an internet handle, try the oparation again' When I opened the RM on my IIS, it came up with this error: 'Transporter and Synchronizer Can't Share Log File' Then I shut down the RM and the mstrans40.exe, rename the logfile, and restart t... 2 12/16/2005 5:08:20 PM Self Replication Hope someone can help here, I have a few DB's which seem to be self replicating everytime they are used. Does anybody know what is causing the issue. Its driving my users nuts and of course takes up space on net work drives. Harry hjacobs@nebs.com... 2 12/16/2005 10:05:50 PM Testing Connection I have code that initiates an indirect synchronization using the TSI Synchronizer object. This application will be distributed to 3 different locations. Each location will have its own replica set so I can't hard code data paths into the front end. I don't want users to attempt indirect synchronization unless they have a valid connection to the machine they're trying to synch with. I ca... 9 12/22/2005 2:45:56 AM TSI SynchIndirect2 Argument The help file for the TSI synchronizer states this about the argument supplied to the synchindirect & synchindirect2 methods: "Note that the specified database can be one of many different values. It can be: 1. a valid UNC path to a database in the replica set. This option is not usually recommended since Microsoft Jet only stores one UNC name and if a machine has multiple shares o... 3 12/22/2005 6:57:04 AM THE > SUPER-MONEY-SOURCE < THE > SUPER-MONEY-SOURCE < This special program is acquire copyrighting-protected, only with the participation you the copyrighting at this program. Prohibited utilization leads to the notice! THE > SUPER-MONEY-SOURCE < In this program, there is really money. 1200.- Euro / dollar and MORE are in only 3 weeks possible with only 5 participants!! Example, you get Euro o... 1 12/22/2005 5:14:24 PM too many indexes message I am trying to create a design master and keep getting the message that there are too many indexes. What is the limit on indexes in a design master.... 2 12/22/2005 11:44:33 PM Synchronising with remote server Hi We have an internal ms access database which we need to synchronise with our website with sql server 2005 backend which is hosted on a public host. My question is; is there a way to keep the two databases synchronised using the technologies built in sql server 2005 and/or access? We also have the possibility of an in-house sql server 2000. Can this be used in anyway to help, perhap... 2 12/25/2005 7:45:35 PM Earn money Online - without risk! Earn money Online - without risk! For all people, who can utilize money. Are you on the search for a lucrative source of income? Would you like to work of at home out of, without yourself you someone makes directions? Would you yourself like to determine, when, how much and like often you salary? Then you should take yourself a couple minutes time. You happily will be that you ... 1 12/25/2005 1:36:24 AM Cannot Open Access over VPN: very strange behavior Hi all, I face a very strange problem, when opening a MS Access database over a VPN tunnel. The database reacts weirdly to users' opening requests: 1)-Users who are on the Internal LAN can open the database. 2)-VPN users cannot access the database, if the database has already been opened on the LAN 3)-VPN users can open instead the database, if the database has not been opened by any c... 18 12/9/2005 4:18:03 PM Replication newbie question(s) Hi - I originally posted to public.access, but this sound like the right place for my question. This has already been addressed, sort of, but I could not find exactly what I am looking for. I have a low traffic web site with an access 2003 db behind it. I now need to somehow synchronize the live production data to a "shadow" database via http and the internet. The shadow will be us... 6 12/11/2005 8:41:33 PM Must Constantly "Reconfigure" Replication Manager In trying to synch two replicas in two different cities but on the same closed network, I am experiencing an odd problem. After about a week or two of successfully scheduled indirect synchs, they start failing. The only way to get them to work (and even doing a direct synch doesn't get it going again) is opening the Reconfigure Replication Manager window and hitting 'next' until I can hit 'f... 4 12/10/2005 3:30:31 AM Large AutoNumbers? I'm thinking this might have to do with an unsynched replica - but does creating a record with an AutoNumber field generate a large integer like 1412143?? it seemed really out of place and through me off when I looked at the number. I even saw a negative number in a table where the related field was a foreign key. if this is not related to replication, does anyone know what would caus... 3 12/9/2005 5:35:02 PM Replication: Alternatives? Good day, I am ‘just’ starting to familiarize myself with ‘Replication’, and wish to validate some concerns. A client wishes to have a ‘Main’ database on a LAN that will be updated by 4 different users, each with a laptop, and each with a copy of the database (or at least the relevant fields). The database has yet to be designed, however, I anticipate the number of tables (and relationsh... 4 12/10/2005 3:27:47 AM TSI Synchronizer Error I have the TSI Synchronizer installed on two different machines at home and have been trying to configure them to perform an indirect synchronization. I installed the jet synchronizer which I downloaded from microsoft. I forget what they call the service pack but the file I ended up running is called jet40repl.exe. It creates folders identical to the ones that replication manager creates... 5 12/13/2005 4:30:58 PM Replica MachineName Using the replicaset collection of the TSI synchronizer object I looped through each replica and checked the machine name of each. I found that the two replicas that were in folders which are not shared did not have a machine name assigned to them. These are the two replicas I'm trying to use indirect synchronization on. The sample code in the TSI help file uses machine name to select re... 8 12/13/2005 5:15:59 AM Locked by another user during Synchronization I received a synchronization error after logging into my Database. Luckilly, I'm the one who wrote the routine for the sync: Couldn't save; currently locked by another user. (Error 3046) One of my users is currently on and she has a front end which is pointing to a replica back-end on the server. How do I work around this?... 3 12/12/2005 10:17:02 PM How do I create a GUID column in Access without the Autogenerate ? Hello I have an Access database and I use ADO. I want to create one column to contain my GUID value . But when I set the ADOX::adGUID as the property of my column , it creates a Replication ID column and it puts a GUID value in each newly created entry in the table . But I want to use my own GUID to set in that column, I don't want Access to fill it up for me. Is that possible? Or the Repl... 2 12/12/2005 9:50:57 PM Problems with Replica Drop down list When in the replica, in a Form i am using the Filter by Form option: the drop down list is supposed to display a list of rooms referenced from a table. Instead, i get two items only: IS NULL, and IS NOT NULL. If i manually type in the room # and apply the filter, the correct record info will show. When accessing the design master in the same area, the drop down displays what it sho... 2 12/14/2005 3:52:41 AM 12 Pages: 1  2  3  4  5  6  7  8  9  10  11  12