Threads Replies Last Post 9 Pages: 1  2  3  4  5  6  7  8  9   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 22.12.2005 23:44:33 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 22.12.2005 17:14:24 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 26.12.2005 20:01:08 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 25.12.2005 19:46:37 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 25.12.2005 19:45:35 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 25.12.2005 01:36:24 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 22.12.2005 06:57:04 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 22.12.2005 02:45:56 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 16.12.2005 22:05:50 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 16.12.2005 20:50:56 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 16.12.2005 17:08:20 Backend bloating We have used a complex Access (02-03) medical billing application for 18 months. The backend is replicated (2 global replicas and a design master) and direct synch has been used only. Roving laptops log onto network locally to sync. There are about 50 tables and there are ~ 700 patient's entered. The back end has crept up from ~12 mb after initial replica creation to a current ~150... 9 14.12.2005 23:33:48 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 14.12.2005 23:20:09 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 14.12.2005 03:52:41 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 13.12.2005 16:30:58 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 13.12.2005 05:15:59 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 22:17:02 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 21:50:57 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 11.12.2005 20:41:33 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 10.12.2005 03:30:31 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 10.12.2005 03:27:47 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 09.12.2005 17:35:02 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 09.12.2005 16:18:03 Linked table somehow became local? Has anyone ever experienced this? I can't imagine how it happened. I've been working with a front end called IM.mdb which points to a replica on the network callled InterfaceUpdate.mdb incidentally, there is a local replica in c:\IM with the same name InterfaceUpdate.mdb... The only code that I can think that would have caused this is my synchronizing code which goes like this: ... 4 09.12.2005 01:04:44 3703 Error due to DAO 3.6 / Jet 4.0 when running the following code: Set dbLOC = OpenDatabase("C:\IM\InterfaceUpdate.mdb") dbLOC.Synchronize "R:\QUEST\Bridges\InterfaceUpdate.mdb", dbRepImpExpChanges I receive the following error: Run-time error 3703 Operation not supported on replicable databases that have not been converted to the current version This is the code I have in my linked Front-End in C:\Windows\Desk... 6 09.12.2005 01:04:03 9 Pages: 1  2  3  4  5  6  7  8  9